Sharing Access Database on Vista

[Manos]

I have four computers running on a peer-2-peer network. Two are Vista (sp1)
machines and the other two are an XP machines (sp3). All have Office 2003
installed.

An mdb file we have been using between the users with sharing options is
now only allowing one-at-a-time user to access the file on Vista workstations.

I cannot open the mbd file simultaneously on the Vista workstations .

The XP workstation does not have this problem and everything works fine.

 

[Albert D. Kallal]

I going to suggest that

This usually hints at a permissions issue.

If the access can't "create" a file in the shared folder, then it defaults
to single user mode
(seems like a strange thing, but access needs full rights and ability to
create a file in that shared folder).

Since you up to a few users, then I going to suggest that you split your
database, and see if that helps.

I explain the splitting issue here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

The problem is that vista is tighter on file permissions, and it possible
that the locking file is being creased based on the FIRST user to open the
file.

So, you could tweak/play with permissions, but I would try splitting the
database and placing the front end on EACH COMPUTER. this will just simply
"isolate" issues to each machine in a better way.

And, on the vista box, stay away from "program files" dir. Use my documents,
or even a folder on the c: drive like:

c:\MyApplication\MyApp.mdb

 

[aaron.kempf]

Jet isn't designed to support multiple users.. it's never worked
reliably.

Move to SQL Server

-Aaron

 

[Tony Toews [MVP]]

Jet isn't designed to support multiple users.. it's never worked
reliably.

Totally false.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/