Access 2003 and SQL 7.0

C

ChadG

Hello,
We currently run a small database with Access 97 as the
front end and SQL 7.0 as the backend. Will there be any
compatibility issues is we upgraded to Access 2003 and
kept our backend as SQL 7.0?

thank you
 
G

Guest

There shouldn't be any issues, but be sure that your MDAC components are up to date. That said, I would suggest that you investigate using an Access Project (available with Access 2000 and forward) rather than linking from Access 97 to SQL Server.

Scott Shearer. MCSD, MCDBA
****msshearer@@@hotmail.com***
----- ChadG wrote: -----

Hello,
We currently run a small database with Access 97 as the
front end and SQL 7.0 as the backend. Will there be any
compatibility issues is we upgraded to Access 2003 and
kept our backend as SQL 7.0?

thank you
 

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

Access and SQLServer Express 2005 3
Form datasource from sql server backend 1
Issues with upgrading VBA application from SQL 7.0 to SQL 2000 4
reports slow after converting to Access 2007 6
linking from access to SQL tables 4
terminal server 3
record locking issues and upgrading to 2007 or SQL 3
Possible to sync Access front end to Sql Server 2000 back end usingAccess? 3

Top