Upsizing wizard: run on web server or locally?

M

Matt

Can I run the Access 2003 upsizing wizard to convert from Access to SQL from
my own workstation ( thereby converting a locally stored copy of the
database), or does it have to be run on the web server that SQL is installed
on (and the Access database is also stored)? We have MS SQL Express Edition
on the server.

We do not have a copy of Access installed on the web server, even though the
web server can query and write to the Access databases stored on it through
IIS. I can't get the wizard started on my workstation, possibly because it
is asking for a DSN, which is defined on the web server and not my
workstation. I defined one on the workstation anyway, but still no luck.
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Export Tables to SQL Server 20
Upsizing Wizard Problem 1
Upsizing wizard and SQL Server 2008 Express 4
Trouble upsizing Access to SQL 5
Error when run Upsizing Wizard 2
Upsizing Wizard 10

Top