Networking an unsecured database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi-
I am having trouble networking a simple, unsecured database. The databse
consists of six tables, two queries and a form. About 12 people need to use
it to look up customers when they give us a code. I dont need any security on
this because it is all easily available info. The tables are all linked and
reside on a general drive which all reps can access. Right now only one
person can be in the database at a time. If an additional person attempts to
use it, they get a message saying that the database is open exclusively by
another user. I tried (through options, advanced, to set the default opening
property to shared but that didnt do anything. Can anyone help me out??
thanks
 
Keithz said:
Hi-
I am having trouble networking a simple, unsecured database. The
databse consists of six tables, two queries and a form. About 12
people need to use it to look up customers when they give us a code.
I dont need any security on this because it is all easily available
info. The tables are all linked and reside on a general drive which
all reps can access. Right now only one person can be in the database
at a time. If an additional person attempts to use it, they get a
message saying that the database is open exclusively by another user.
I tried (through options, advanced, to set the default opening
property to shared but that didnt do anything. Can anyone help me
out?? thanks
Click to expand...

All users (windows users) need full permissions on the folder where the mdb
is.

You would be wise to give each user a copy of the frontend on their local
machine, linked to the backend on the server.
 
I'm having an odd issue regarding a shared database located on the network. I
can open it from the first desktop shortcut but after that the shortcuts on
everyone else's desktop will not open the database. they would have to open
access then open the database from inside access. In other words the first
person using the desktop shortcut is the only one able to use it that way
although others can open the database. even when the second user double
clicks on the database file it will not open without opening access first.

I'd like the shortcuts to be usable. what could be the issue here? It may
have happened after SP2 updates thoroughout the office so that may have
something to do with it.
 
videotek88 said:
I'm having an odd issue regarding a shared database located on the
network.
Click to expand...

You should split the database and give each user a copy of the frontend on
their computer, linked to the backend on the server.
 
Back
Top