Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple users in same access database

Status
Not open for further replies.

badger8

MIS
Aug 3, 2001
34
US
I want mutiple poeple to be able to use the same database, but how can two poeple make chnges to content within the same table.

We have a database that stores all of our contacts. I have two columns one that says bad mail and do not email. I need to go in and check off those records that mail is bad or do not email. I would like help with this, but I don't know how to set up the databse so multiple people can make changes.

Whaould I need to make a form view that has some kind of update button?

Does this make sense?

Thanks

Ray
 
You might want to take a look at the various types of locking schemes available to you. They range from locking the entire database at one time to locking just the current record. Also look under tools->options->advance to set locks (at least under Access 2000).
You can also set locks and permissions thru the ADO/DAO connect option.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top