Sharing a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

How1 - 05 Jul 2007 11:32 GMT

Hi

I have created a shared database on the company server and have created
shortcuts on each of the users desktops. We cannot all access the database at
the same time if we use the shortcuts. However it allows us to access the
database at once if we open the access application first and then open the
database in the application.

Can someone advise on how to overcome this?

Signature

How1

Reply to this Message

Allen Browne - 05 Jul 2007 11:56 GMT

See:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have created a shared database on the company server and have created
> shortcuts on each of the users desktops. We cannot all access the database
[quoted text clipped - 4 lines]
>
> Can someone advise on how to overcome this?

Reply to this Message

How1 - 05 Jul 2007 12:14 GMT

Thanks for the feedback Allen.

Can you please advise on how this is done?

Signature

How1

> See:
> Split your MDB file into data and application
[quoted text clipped - 9 lines]
> >
> > Can someone advise on how to overcome this?

Reply to this Message

Douglas J. Steele - 05 Jul 2007 12:24 GMT

In addition to the information Allen has in the link he already gave you,
see what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thanks for the feedback Allen.
>
[quoted text clipped - 16 lines]
>> >
>> > Can someone advise on how to overcome this?

Reply to this Message

Allen Browne - 05 Jul 2007 14:16 GMT

I guess you missed this part of the article:
Access includes an Add-In to perform the split
with details of where to find it in different versions of Access.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for the feedback Allen.
>
[quoted text clipped - 14 lines]
>> > the
>> > database in the application.

Reply to this Message

Keith Wilby - 05 Jul 2007 12:47 GMT

> Hi
>
[quoted text clipped - 6 lines]
>
> Can someone advise on how to overcome this?

The tried and tested method for a multi-user scenario is to split the
database and give each user their own copy of the front end. More info
here:

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.com

Reply to this Message

jahoobob - 05 Jul 2007 13:53 GMT

Access users would be wise to have Doug's, Tony's, and Allen's web sites in
their Favorites. There is a wealth of information there from beginner to
advanced.

>> Hi
>>
[quoted text clipped - 10 lines]
>Keith.
>www.keithwilby.com

Reply to this Message