How to secure database once on the server

[Bessie]

Hello,

I need some help! I created a database in access and it's
on the server. I put the orginal on the server and when
others logon I get locked out; therefore, I can not do
anything in the backend until everyone is off. I have
4900 records and I want to find a way to secure my
database if I am in the backend, without losing infor.

my e-mail address: (e-mail address removed)

 

[TC]

Hello,

I need some help! I created a database in access and it's
on the server. I put the orginal on the server and when
others logon I get locked out; therefore, I can not do
anything in the backend until everyone is off. I have
4900 records and I want to find a way to secure my
database if I am in the backend, without losing infor.

Before we can answer:

- How are you "locked out"? What is the message?

- What things do you want to do in the back-end while people are still in
the front-end? Data changes? Design changes?

- Why are you worried about "losing infor.[mation]"? How might that occur
(from your viewpoint)?

my e-mail address: (e-mail address removed)

"Ask here, answer here".

HTH,
TC

 

[Craig]

This is because the person which has the database open,
does not have full rights to the directory. This person
is not able to properly create or delete the .ldb file
which is associated with a database. When a database is
opened, this file is created and when closed this is
deleted. If this file is not created when a person opens
the database, it will return an error that the user has
opened the database exclusively even when they didn't. I
have run across this with our network and had to make
changes to the folder permissions. They need to be able
to Read, Write, Modify, Execute.

Craig

-----Original Message-----

Hello,

I need some help! I created a database in access and it's
on the server. I put the orginal on the server and when
others logon I get locked out; therefore, I can not do
anything in the backend until everyone is off. I have
4900 records and I want to find a way to secure my
database if I am in the backend, without losing infor.

Before we can answer:

- How are you "locked out"? What is the message?

- What things do you want to do in the back-end while people are still in
the front-end? Data changes? Design changes?

- Why are you worried about "losing infor.[mation]"? How might that occur
(from your viewpoint)?

my e-mail address: (e-mail address removed)

"Ask here, answer here".

HTH,
TC



.