microsoft access training - Access - Working with more people at same time?

Resolved · Low Priority · Version Standard

Access - Working with more people at same time?

Adrienne has attended:
Access Introduction course

by - delegate Adrienne [13 posts] (2007 Dec 14 Fri, 14:24) Reply

Hi

Our database is saved on a server, accessible for more people. Is it possible to get some sort of message when I want to work in it, that I can see who is working in it. (Like with a shared Excel sheet?)

Thanks

Adrienne

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 28 Wed	Bayswater	8	book now	£110	£205
Full Schedule: See all 44 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access - Working with more people at same time?

by - trainer Richard platinum contributer [818 posts] (2007 Dec 17 Mon, 12:42) Reply

Hi Adrienne

Thank you for your question regarding using Access in a multi-user environment.

Microsoft Access was designed to be used in multi user environment, so it is a little different from Excel. As far as we know there is no LISt that yuo can refer to to see who is connected to the database.

The default setting for an Access database is to allow many users to connect to it. There are options to enable USERS with SECURITY settings and permissions. In this way you can control WHO is accessing what part of the database.

Regards

Richard
Microsoft Office Specialist