Access Networking & Security Issue.

[Zacharia]

I've got an Access 2007 database that we've been trying to get running on a
network environment.

Our db is located on a network file server (nas device). We share that same
db with 3 users on the network. They all want to be able to keep the db
open. For some reason they cannot run or open when the file is opened by
more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista Ultimate.

It seems like this was possible in the past now we can't.

 

[Keith Wilby]

I've got an Access 2007 database that we've been trying to get running on
a
network environment.

Our db is located on a network file server (nas device). We share that
same
db with 3 users on the network. They all want to be able to keep the db
open. For some reason they cannot run or open when the file is opened by
more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista
Ultimate.

It seems like this was possible in the past now we can't.

Don't share database files. Split the app and give each user their own
front end file. More info here:

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.co.uk

 

[david]

Some NAS devices don't support that.

(david)

 

[Zacharia]

I've reviewed both posts. I'm still a bit confused. It seems like we could do
this till Vista came around. ANyway. Putting VISTA aside. SInce the share we
wanting to do would be on 2 - 3 XP Pro workstations. The same file would
reside on our SNAP Server 1100 model.
THe Access database would be opened by one user and also open/available to
be opened by a second or third user with "View" only rights. SInce it's open

 

[david]

You can't normally have a user with "View" only rights.

Unless all the users are "View" only, all the users need
to be able to create/read/write a shared lock file in the
same folder as the database.

If the View only user can't write locks on the lock file,
the View only user can't share the database file with a
R/W user.

(david)

 

[Zacharia]

Well I think this has gone to an area that I didn't intend to.
To be clear again. I don't think this is a user permission issue. All
users have Read and Write. As a matter of fact the users who access this
database are all Administrators.

Once again this is the issue I'm needing help with:
The MS Access 2007 database will only allow one person to look/work at the
database at a time. User 1 was in it and User 2 tried to just access it to
look at something and it wouldn’t open. (the file is open on User 1's
workstation)

Is there any way for our database to be available so that both can be in at
the same time. (one read only is fine)
We have always done this in the past.

 

[david]

If you have set Access to Open Exclusive, it will do that.

Otherwise, this is a file permission issue, or a NAS issue.

It may be a Vista issue, if Vista has implemented a fix for
a common NAS fault to prevent data corruption (this is possible).

It may be an obscure network error or network configuration error.

(david)