https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 11:09:40 +0000 Tue, 19 Jun 2007 13:47:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23556 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/change-table-names_topic23556_post123860.html#123860 Author: aalbitz
Subject: 23556
Posted: 19 June 2007 at 1:47pm

Hi,

I did do a universal search and replace and replaced every instance of the table name, so there's no instances of it calling the table with the old name.  To test it, all I did was rename the table, I didn't import or export anything yet.
]]> Tue, 19 Jun 2007 13:47:38 +0000 https://forums.webwiz.net/change-table-names_topic23556_post123860.html#123860 https://forums.webwiz.net/change-table-names_topic23556_post123851.html#123851 Author: WebWiz-Bruce
Subject: 23556
Posted: 19 June 2007 at 7:57am

The table names are in 100's of files.

You would need to go through each file and update it to the new table name, which must contain the same field names and data types as the original tblAuthor table
]]> Tue, 19 Jun 2007 07:57:13 +0000 https://forums.webwiz.net/change-table-names_topic23556_post123851.html#123851 https://forums.webwiz.net/change-table-names_topic23556_post123841.html#123841 Author: aalbitz
Subject: 23556
Posted: 18 June 2007 at 9:49pm

I want to change the name of the tblAuthor to tblSubscriber so as to integrate it with my current database.  When I try to change the code, I get this error:


Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_Access_get_forum_data
File Name:- default.asp

Error details:-
Microsoft JET Database Engine
No value given for one or more required parameters.

Is there somewhere else I need to change it in the code (I changed it on the pages from Author to subscriber where neccessary.) 

Is it coded in somewhere that I can't change the table name?

]]> Mon, 18 Jun 2007 21:49:57 +0000 https://forums.webwiz.net/change-table-names_topic23556_post123841.html#123841