share a database w/ others

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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


/ Jesper
 
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
 
Back
Top