share a database w/ others

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carol Shu - 18 Nov 2006 06:41 GMT

i have a DB, got it running great, now i'm trying to let other people (about
3 people) in the office to share this same DB not to do update or change
data, just for print report and use query only, i'm not sure i should share
this DB on a network (i use wireless network now) ? or split database ? or
maybe try replicate a database ? could someone tell me the best way for me to
do, thank you.

Reply to this Message

fdcusa - 18 Nov 2006 08:02 GMT

Simplest solution would be just to copy the database to the 3 workstations.
Perhaps create a batch file that will copy the database (when not open) to a
shared folder on each workstation (none running the database). This would be
ideal if they need updates periodically. There are many ways to do this, but
for what you need, I think this is quite enough. Unless you want them to
have realtime data. Then you should investigate splitting to
Back-End/Front-End.

Reply to this Message

Carol Shu - 18 Nov 2006 21:54 GMT

thank you. just one more question, our company also have a web site, what if
i upload the database to the web and make everyone get a user name and
passwoard before log on? is it possiable

> Simplest solution would be just to copy the database to the 3 workstations.
> Perhaps create a batch file that will copy the database (when not open) to a
[quoted text clipped - 3 lines]
> have realtime data. Then you should investigate splitting to
> Back-End/Front-End.

Reply to this Message

Jesper - 18 Nov 2006 10:21 GMT

>i have a DB, got it running great, now i'm trying to let other people
>(about
[quoted text clipped - 5 lines]
> to
> do, thank you.

Beware that a split Access db cannot run on a wireless network.
Data packages are lost and the database will become corrupted.

/ Jesper

Reply to this Message