Shared Database!!

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

Guest

Hi..
I need your help please...

I have an access database (2002) in a server..
I want to make it accessible for some users
I gave them the authority or permission..
but the problem is that if it is open by one user the others can't access it..

also..
can i open the report without opening the access .. or at least make the
background invisible??
 
Engo said:
Hi..
I need your help please...

I have an access database (2002) in a server..
I want to make it accessible for some users
I gave them the authority or permission..
but the problem is that if it is open by one user the others can't access
it..

also..
can i open the report without opening the access .. or at least make the
background invisible??
Click to expand...

Engo,

Regarding your first question:

Assuming all users have read/write permissions to the directory in which the
database resides it sounds like the first user is opening the database
exclusively. Make sure users do not have the rights to do this.

Regarding your second question:

What do you mean by "the background"? If you mean the database window you
can turn this off under Tools > Startup > Untick "Display database window".

If you mean the MS Access window it is possible to do this, but is rather
more trouble than it is usually worth (in my opinion). Post back if you want
me to detail this for you...

Ed Metcalfe.
 
have you split your database? The tables on the server and the
forms/queries/.... on eache computer.
 
i am attempting to do the same thing with my db. my problem is with the
permissions. i can't figure out how to give people permission to access the
db. at first, i was getting the same message as Engo that only one person
can open the db at a time.
now i am getting a message as that says that someone else has "opened it
exclusively..." there is no one else that has the db open and i tried taking
the open/exclusive feature off of the users. when the error message appears,
it displays the path on the server to where the backend of the db is, not
where the front end is (where i am accessing it).

am i missing something???

i have tried splitting the db and replicating the db to be able to share the
db, and nothing that i have tried has worked. i am not an expert on access,
and i think that i amy be attempting a task above my skill level, but i can't
ask anyone at work for help. i heard that this place was a wealth of info
with regards to finding info and troubleshooting. thanks in advance.
 
This is a Windows permission issue. All users of the database need modify permissions on the folder where the backend is located. This is so the associated ldb file can be created/modified by users. Without the proper permissions, the first person in can't create the ldb and the file is opened exclusively.
 
Thanks all. I was able to get the db working. I split the db (fe and be),
put them in a shared folder on our server, sent test users a copy of the fe
to save to their local machines, and viola - it worked. I was even able to
access it remotely from my lap top using a fe db, t-mobile aircard and a vpn.
It is slow, but it works. This is exactly what I designed and intended the
usage for. It also allows multiple users to input and access data
simultaneously and generates reports in real time.

Thanks to all that contributed. You guys are great.

Rob Q
 
Read the last response and wondering why you need to split the database at
all - why can't you just leave the entire database out on the server so
everything is in one location?????

I am trying to tap into our companies database from home and have the
exclusive issue even when people have it already opened under just OPEN.
What needs to be done on the home office on setting the permissions to that
FOLDER???? so a few of us can be in at the same time???


Thanks,
barb
 
Back
Top