Upgrading Access 2003 with SQL Server 2005

A

Amin

Hi,

I am using Access 2003, and I was considering getting SQL Server 2005
instead of Jet. Are there significant problems with doing this(as in, will
tables not append or update correctly, etc.) I could not follow the
discussions on this forum about the topic so I was hoping someone could give
me the pros and cons of doing this.

Thanks so much,
Amin
 
P

Paul Shapiro

Searching Google for "upgrade Access database SQL Server" should get you
lots of info. It's been discussed many times.

Basically, there's no reason to upgrade an existing db unless you need some
of the additional SQL Server capabilities, for example, triggers, stored
procedures, remote access, more capable SQL processor, larger database size,
support for more than 100 users, online backup, etc.

Changing the backend database requires work and some of your existing code
or SQL will probably need modification. Why are you considering the change?
 

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

Resources for Migrating Data ONLY from Access 03 to SQL Svr 2005 2
Access 2003 & SQL Server 2005 4
Upgrading Access 97 to SQL Server advise 36
Upgrading to Access 2007 3
Restore SQL Sever 2005 backup database 11
Converting Microsoft Access SQL to Microsoft SQL Server 2005 5
Append Access Data to SQL Server Table 12
Access as FE on SQL Server 13

Top