access and sql

[Sher]

Hi all,
Sorry for grabbing at straws.
My senerio is that I need to upgrade some of my depts to access 2003 and the
other depts will still be using access 97. We have a shared database written
in access 97 that all depts use.
Is there any solution using sql where access 97 users and access 2003 users
can use the same database?
Or is there a way to install access 97 on a server/pc and share the program
itself from a shortcut? or is their some kind of run time program to use.
Thanks in advance for any solutions that you may have for me.
Sher

 

[Kevin3NF]

The easiest thing to do is split the db (if you haven't already) and make
sure to leave the backend (with the tables) in Access 97. All the various
Front-ends should be able to link to it regardless of the version.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Arvin Meyer [MVP]]

If you can get the proper drivers, you may be able to use both versions of
Access front-ends with a SQL-Server back-end. I am pretty sure that both
Access versions will read the data from SQL-Server 7.0. As to ADPs, there
are none for Access 97, you must use an MDB.

You cannot run Access 97 from a server (other than a terminal server, and
you still need licenses for each copy). You can build runtime versions for
Access 97 (or any other version) if you have the developer's kits. In all
cases, splitting the front-end and back-end into the data itself (back-end)
running on a server is mandatory.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access