Access 97 / XP sharing problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brucedodds2 - 28 Dec 2005 16:43 GMT

I have a client with an Access 97 format switchboard based application.
This app is shared across several offices which are being upgraded in
sequence to Access XP. Recently XP users started having the startup
switchboard halt before any items are displayed. Access 97 users still
get the correct startup.

Are there known issues in sharing A97 format applications among XP and
97 users? (This app has tables & forms in one file).

TIA

Reply to this Message

Steve - 28 Dec 2005 17:04 GMT

Without so much as actually answering the question, I'll note that many
sharing issues with Access can be avoided by simply splitting the
database (data in a backend, placed on the server; other objects in
front-end, a copy of which is on each workstation).

As for your current difficulty, have you Compacted and Repaired? I
don't recall whether Access 97 was kept from this useful feature. If
A97 doesn't have it, microsoft.com has a stand-alone tool to do the
same thing. I don't have a link for it right now, but searching
microsoft.com for "compact and repair tool" should do the trick.

How long between the time a machine is upgraded to XP and the Access db
startup goes funky? Does it seem to occur right after a particular
patch or update is applied? Has anything changed for XP users recently?

Reply to this Message

brucedodds2 - 29 Dec 2005 23:11 GMT

Thanks for the reply, Steve. It looks as though the corruption may have
been introduced the first time the XP user touched it.

We converted the file to XP, compact/repaired it, and converted it back
to '97. The XP user can now use it.

I agree about splitting the database, but all offices are scheduled to
be converted to XP over the next four weeks, and there are apparently
only a few users. I'll leave it alone for now.

Reply to this Message