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
Edited by Spede