Change Table Names
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23556
Printed Date: 07 April 2026 at 11:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Change Table Names
Posted By: aalbitz
Subject: Change Table Names
Date 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?
|
Replies:
Posted By: WebWiz-Bruce
Date 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
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: aalbitz
Date 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.
|
|