Shared databases

J

Jorge

I have an existing database that runs in my computer. My company just put a
server for 20 users and everybody needs to look at this database, do I need
to modify the database itself or do something special before I put it in the
server for everybody? and if I am the only user with writting access to the
database, can I do so while other users are looking at the file?

Thanks for your help and comments.

Jorge
 
S

Shaun Beane

by default Access databases are multi user ready. You should be able to
simply copy the file to a location on the server that everybody can get to.

as for you writing, yes, if you are simply adding new data to the database,
you can do this while others are viewing the data. however, you cannot make
any design changes (create or change existing forms, queries, reports,
tables, etc.).

if this is a relatively large database, then you may want to research
splitting the database to aid in performance and further development. make
sure you understand the concept before you proceed. or just ask here and
we'll try to answer any questions you may have.
 
Top