Lock up .mdb file when in use

[Remco4IT]

Hello people! I'm rather new to Access so forgive any ignorance I might show, I've googled my ass off but can't really find a solution. Here's the thing: When 2 people are working on the same database (Just a standard .mdb file) there's some issues for a very computer illiterate customer of mine. I figured I could resolve this by finding out how I can make the file lock up while it's in use, whether the second person who tries to open the file gets an error or can open the file in read-only mode doesn't really matter, as long as only 1 person can edit it at the same time. I was hoping you guys could point me in the right direction since I've not really gotten anywhere so far. Thanks in advance!

[June7]

Are you talking about editing design or data entry/edit?

This is not a split db?

[Remco4IT]

Are you talking about editing design or data entry/edit?

This is not a split db?

I'm talking about data entry/editting. I'm not sure if it is a split db, multiple people can open and edit it at the same time. As far as I know it's a fairly basic db.

[June7]

Split means the data tables are in one file (backend) that is placed on a central network server and another file (frontend) links to the tables and this file has queries, forms, reports, code. Each user has their own copy of frontend on their workstation.

Database cannot be 'read only' for one user but not another.

You can manage user interaction with data through forms and reports. Requires knowing who the user is (login procedure).

These are common topics in forum. Search forum or google.

Here is one tutorial http://datapigtechnologies.com/flash...loginform.html

[Vellmen]

Wouldn't opening the db by the 1st person in "exclusive" make it in-openable by 2nd user?

[June7]

Non-openable is not the same as read only.

[Remco4IT]

Wouldn't opening the db by the 1st person in "exclusive" make it in-openable by 2nd user?

That sounds like the kind of solution I am looking for. Read-only isn't what I necessarily want, I will google for this.