Using Access 97 w/ Server 2003

[ADP]

I want to purchase a new Server with Windows Small
Business Server 2003. I have many applications that were
created with Access 97 and converting them at this point
is not an option. Can I install and use Access 97?

 

[Douglas J. Steele]

Are you talking about logging onto the server as a user, and running the
applications there, or are you using it as a real server, where the users
have workstations connected to the server, and are running the application
from their desktops?

If the latter case, there shouldn't be a problem. Your application should be
split into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing just the tables). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, preferably on his/her hard drive.

If the former case, I have heard of some problems trying to run Access (any
version) on Server 2003.

 

[ADP]

I was referring to the latter case. Thank you very much
for your help.