Upsizing Wizard table links not created

C

Curt Gough

I am upsizing an Access 2000 database to SQL Server 2000 using the Upsizing
Wizard. I select the "Create New Database" option and supply a user and
password with create database permissions (note: I have also tried this
using the sa login and password with the same results). The database is
created fine on SQL Server, the local tables in Access are renamed with
"_local" at the end of each, but the links to the SQL Server tables are not
created.

I have applied Office service pack 3 and SQL Server sp 3.

Any ideas?

Curt Gough
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL upsize 2 databases 2
Trouble upsizing Access to SQL 5
Upsizing Problem with number of records 2
Upsizing Access 2000-SQL Server2005 6
SSMA linking Tables 4
Upsizing Wizard Access 2000 7
Error when run Upsizing Wizard 2
Upsizing wizard and SQL Server 2008 Express 4

Top