Access 2003

Neville · 14-03-2008, 03:22 PM

How do i enable my access database to have multi users being able to use it at the same time without it being locked.

As I have a database that a few people might be updating at the same time.

SYNACK · 14-03-2008, 11:08 PM

I think you just need to add in account support by going to Tools -> Security -> User level security wizard

Users wont be able to modify the same value at the same time but it should allow multiple access.

pallen · 17-03-2008, 02:45 PM

Split the database to have a seperate data file and a front end. Multiple users can access the database at the same time.

Tools>database utilities>Database splitter.

powdarrmonkey · 17-03-2008, 02:54 PM

You should only not be able to get in if another user has the database open in exclusive mode (for changing forms, etc). In normal operation, access performs row-level locking, ie locks the actual row that you're changing, so that another user doesn't change the same data. Other rows and datasets are open to other users, regardless of user security levels, split databases, etc. That's the whole point of Jet.

Exclusive mode is an option in the Open dialog. Normally it's non-exclusive.

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

14-03-2008, 03:22 PM	#1
Neville Join Date: Feb 2008 Posts: 44 Thanks: 1 Thanked 0 Times in 0 Posts Rep Power: 0	Access 2003 How do i enable my access database to have multi users being able to use it at the same time without it being locked. As I have a database that a few people might be updating at the same time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS access 2003 security problem	rhyds	Windows	5	16-01-2008 05:26 PM
Vista & MS Access 2003 Problem	ICTNUT	Windows Vista	6	15-06-2007 03:10 PM
Exchange 2003 - Outlook Mobile Access	ajbritton	Windows	7	20-12-2006 06:11 PM
Cannot run reports in Microsoft Office Access 2003	MrDylan	Windows	3	10-03-2006 02:54 PM
Exchange 2003 web access problem	Ross2k5	Windows	3	18-01-2006 11:09 AM

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

		EduGeek.net Forums > Coding and Web Development > Group Project
Access 2003

14-03-2008, 11:08 PM	#2
SYNACK Join Date: Oct 2007 Location: Auckland, New Zealand Posts: 1,844 Thanks: 60 Thanked 267 Times in 243 Posts Blog Entries: 2 Rep Power: 59	I think you just need to add in account support by going to Tools -> Security -> User level security wizard Users wont be able to modify the same value at the same time but it should allow multiple access.

17-03-2008, 02:45 PM	#3
pallen Join Date: Mar 2007 Posts: 307 Thanks: 3 Thanked 8 Times in 8 Posts Rep Power: 5	Split the database to have a seperate data file and a front end. Multiple users can access the database at the same time. Tools>database utilities>Database splitter.

17-03-2008, 02:54 PM	#4
powdarrmonkey Join Date: Feb 2008 Location: Alcester, Warwickshire Posts: 1,211 Thanks: 60 Thanked 121 Times in 99 Posts Rep Power: 26	You should only not be able to get in if another user has the database open in exclusive mode (for changing forms, etc). In normal operation, access performs row-level locking, ie locks the actual row that you're changing, so that another user doesn't change the same data. Other rows and datasets are open to other users, regardless of user security levels, split databases, etc. That's the whole point of Jet. Exclusive mode is an option in the Open dialog. Normally it's non-exclusive.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Register now for FREE and post messages!
Username: Password: Confirm Password: E-Mail: Confirm E-Mail: Birthday: Image Verification I agree to forum rules