access and sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top