2003 access micorosft training - Sharing an Access Database

Resolved · Low Priority · Version Standard

Sharing an Access Database

Simon has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course

by - delegate Simon [4 posts] (2007 Nov 2 Fri, 11:52) Reply

I have written my access database and placed it on our file server. I have placed a shortcut on 5 pc's but if it's already open on 2 computers it wont let any of the other pc's open it . They don't show any error messages, they just do nothing. Please can you advise, i'm using Access 2003 if that helps. Cheers

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Sharing an Access Database

by - trainer Stephen gold contributer [386 posts] (2007 Nov 9 Fri, 09:45) Reply

Hi Simon,

Could you clarify how you placed the database on the server?

Did you use the "database splitter" utility to create a front end and a backend?

If you did then we need to look in detail at what you did. If you didn't then we will need to guide you through the process.

Regards