Networking a Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Dub - 24 May 2008 09:23 GMT

Hi Guys,

I have a simple database that I would like two people to be able to access
from the office network at the same time. Is this possible ?. I am new to
database design.

Mike

Reply to this Message

Jeff Boyce - 24 May 2008 14:24 GMT

Yes.

Split the db to a back-end (tables only, lives on the network) and a
front-end (everything but the tables, linked to the back-end tables, one
copy per user on the user's PC).

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hi Guys,
>
[quoted text clipped - 3 lines]
>
> Mike

Reply to this Message

Daniel Pineault - 24 May 2008 17:38 GMT

Jeff is right about splitting your database. But if you are new to this I
thought I'd give you a few links.

http://www.databasedev.co.uk/split_a_database.html
http://www.members.shaw.ca/AlbertKallal/Articles/split/
http://www.granite.ab.ca/access/splitapp/index.htm

But basically it boils down to using the Tools-Database Utilities-Database
Splitter command.

Signature

Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

> Yes.
>
[quoted text clipped - 9 lines]
> >
> > Mike

Reply to this Message

Mike Dub - 24 May 2008 22:11 GMT

Great.Thanks for your help.

Mike

> Jeff is right about splitting your database. But if you are new to this I
> thought I'd give you a few links.
[quoted text clipped - 19 lines]
> > >
> > > Mike

Reply to this Message