Database Discussion - problem with upsize wizard

Print Page | Close Window

problem with upsize wizard

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5273
Printed Date: 30 March 2026 at 4:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem with upsize wizard

Posted By: Spede
Subject: problem with upsize wizard
Date Posted: 25 August 2003 at 11:37am

I'm using the access upsize wizard to migrate from Access DB to SQL. The wizard completes without error messages, but when it creates tables, the tables names show up like:

tblAuthor
tblBanList

unlike the tables that the MS_sql_setup.asp creates:

tblAuthor (dbo)
tblBanList (dbo)

When in try to run the forum, i get an error message about a missing object (table). I don't really know a lot about databases, but doesn't dbo stand for "database owner"? Is there also some permission problem?

I tried to migrate this way:

1. edit the two or three .asp files needed
2. run ms_SQL_setup.asp
3. delete all tables
4. run the upsize wizard in access

Replies:

Posted By: pmormr
Date Posted: 02 September 2003 at 5:01pm

why can't you just manually edit the table names to match the ones used in access?

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/