troubleshooting Question

Access 97/2003/SQL Server Express

Avatar of Daren Anderson, MSIS
Daren Anderson, MSISFlag for United States of America asked on
Microsoft DevelopmentMicrosoft Access
15 Comments2 Solutions230 ViewsLast Modified:
Currently we have an Access97 database - we were rewriting it in Access 2003.  Once everything was tested on 2003, we were going to leave the frontend programs in 2003 and put the data in SQL Server Express.  Unfortunately, since Microsoft is dropping Access 2003; it is harder to get the upgrades so my question is this:  What would happen if we run Access97 as the front end with SQL Server Express as the back end?  Are we going to run into performance issues?  Or is there another solution I am not thinking of?  We are a small office with a limited budget but a large project is quickly approaching.  BTW, we are running Windows XP 2.4Ghz systems, 512mb RAM on a Windows 2003 Server.  Thank you
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 2 Answers and 15 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 2 Answers and 15 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004