How do I set database so Only the record I am entering data is loc

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

Guest

In workgroup my p/c is the main one.
When I am entering data the others who are connected to my p/c cannot access
the database.
I did select no locks in Tools.
Also, noticed under Run Permission that User's is checked. Unsure about
owners.
Appreciate any help.
 
JoanOC said:
In workgroup my p/c is the main one.
When I am entering data the others who are connected to my p/c cannot
access the database.
I did select no locks in Tools.
Also, noticed under Run Permission that User's is checked. Unsure
about owners.
Appreciate any help.
Click to expand...

I see a couple of interesting things.

My guess the answer to your problem is that you have opened the database
under exclusive mode. It is also possible that with no locks selected
Access may just lock everyone else out. I have never tried that.

I assume that when you are not entering data they don't have a problem?

General information that may or may not have anything to do with your
question. Access likes a very robust LAN connection. My guess is your
computer acting as a server may well not be up to the task. What operating
system are you using? All users, including you, should have their own
front end on their own machine linked to a single back end. Is that what is
being done?
 
I'm not at the office, but I have WindowsXP-professional edition I think. I
don't understand what front end means. Guessing: everyone has Access
installed on their p/c - they do.
I did see the .mdw file. Can I add each name of each computer in that file.
Will that help? I am still learning. Have Access Inside Out book that shows
a sample of this.
My Access is not opened under exclusive mode.
Hope you can help. Thanks.
 
JoanOC said:
I'm not at the office, but I have WindowsXP-professional edition I
think. I don't understand what front end means. Guessing: everyone
has Access installed on their p/c - they do.
I did see the .mdw file. Can I add each name of each computer in
that file. Will that help? I am still learning. Have Access Inside
Out book that shows a sample of this.
My Access is not opened under exclusive mode.
Hope you can help. Thanks.
Click to expand...

For information on setting up security and understanding Access security
I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Access demands a very good LAN system. Normally that means there needs
to be a dedicated server that others long onto to access the information
there. That is where the Access mdb or mde file should be located. Peer to
peer LANs usually are not not up to the job as needed by a professional
product like Access.

When I talk about front ends and back ends that is part of the process
to best share data with Access. When Access is a shared product out of the
box, it is far better and far less troublesome to split the database into
two parts. A back end that contains all (or almost all) the data and front
ends that have the forms, reports queries etc. Each user should have their
own copy of a front end which is located on their own machine and which is
linked to the data on the back end located on the server. Access even has a
wizard to help you split an existing database.
 
Back
Top