Networking a Database

[Mike Dub]

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

 

[Jeff Boyce]

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).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

 

[Daniel Pineault]

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.
--
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.

 

[Mike Dub]

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.

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.
--
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.