Windows Forum

Ask something
Discussion Locked

XP SP2 Chages affecting MSAccess

0 helpful
6 replies

by luke.hinson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access 2003 database that, since the upgrade on the host laptop, is no longer allowing concurrent access to the database. Once one is signed in, others are blocked. The only thing that has changed is the OS upgrade. Previously, multiple users could access the Access DB w/ no problem.

6 replies

by blackcurrant

Hi

Open the Windows Firewall from the Control Panel and make sure that File and Printer sharing is enabled.

Good luck

by luke.hinson

I can access the database with 1 user, but cannot have a second user accessing it concurrently. Previously, i was able to have multiple users signed in at the same time.

by rkuhn040172

Double check something:

In Access, click on Tools, Options, Advanced and make sure the Default Open Mode is Shared and not Exclusive.

by rkuhn040172

Double check something:

In Access, click on Tools, Options, Advanced and make sure the Default Open Mode is Shared and not Exclusive.

by monkeywrenchit

We are observing similar behavior with our Access DB, but as a MSSQL guy, I thought this was normal for Access and didn't notice it beginning with SP2. Iknow there is a windows update for the MS Jet ODBC that now prompts us with a useless "are you sure you want to open this database message"... I think that might have been the beginning of the problem.

by ni70

Not an answer, but a question. I noticed this has been answered and was wondering what the problem was and how you fixed it.

This discussion is closed to new replies.