Sharing database w/97 and XP Users

  • Thread starter Thread starter C
  • Start date Start date
C

C

My company is currently upgrading all workstations from 98
to XP - databases are not split. Since the upgrades some
individuals (XP users) can not open databases at different
times - is it because someone with a previous version of
access has the application open and the XP user can not
enable the database?
(I am new to the company and am planning to split all DBs
in the near future)

Thanks in advance for your interest. CC
 
The near future is now.

You can leave the backend in Access 97, and have two
different frontends, XP (2000), and 97. This way, they
can both talk to the backend.



Chris
 
Chris give you the technique.

For more details, see http://support.microsoft.com/default.aspx?scid=kb;en-us;296179. Although not rewritten for Access 2002 or
2003, the info still applies. Lowest front-end version for the backend database.

Biggest thing to look out for is to make sure *ALL* of the computers have the latest Jet updates. See
http://support.microsoft.com/default.aspx?scid=kb;EN-US;300216. I had a client run 97 (Jet 3.51) and 2000 (Jet 4.0) front-ends
against a 97 backend for over a year while they upgraded their desktop computers. The only problem we ever had was when one of the
machines didn't have the latest updates. And the problem went away after the updates.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
I dont think that will work (forgive me if wrong) - I
would move it all to SQL server - then its ODBC all the
way - works - and works well.
 
I dont think that will work (forgive me if wrong) - I
would move it all to SQL server - then its ODBC all the
way - works - and works well.
Click to expand...


You can most certainly mix the front ends of access97, and have other pc's
using accessxp. As long as the back end is still access97 format, then all
will work. and, if those users accidentally convert the "front" a97
application to accessxp...nothing will be harmed...and all will be able to
work un-interrupted.
 
Back
Top