Shared Database Info - Form

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

I've created a database for the purpose of keeping an
invoice register. I've made a continuous form that
displays the invoices and the user will input the next
invoice number and corresponding info. This database is
stored on our server. The problem is that there are two
users of this database. If both of us have it open and one
of us enters the next invoice number, the new info doesn't
display for the other person. I've added a refresh button
to the form footer but that doesn't seem to do anything.
Is there a way to make is so that we can both use the
database at the same time with updated info?
Thanks in Advance! Samantha
 
Samantha,

The problem you are facing is nothing compared to what you're in for. A
multi-user monolithic database is a recipe for disaster, it's just a matter
of time before you start getting corruptions!
The right way to go about it is to split your database and give each user
their own copy of the front end. Let me explain briefly:
A split database is one that consists of a Front End and a Back End (as
opposed to a monolithic one, which is in one piece).
The Back End is an .mdb file which contains only the data tables.
The Front End is an .mde file (preferably), or an .mdb one, which has links
to all the tables in the back end, and contains all the forms, queries,
reports, macros, modules plus any temporary tables created at runtime, or
parameter tables (such as lookup tables) which do not change.
Access has a very easy to use built in function to split a monolithic
database, under Tools > Database Utilities > Database Splitter (in A2K menu
structure). Having completed this step, just put a copy of the Front End on
each user's PC, and have them open that one to work with.
Have a look at the access.multiuser newsgroup, it will be quite
enlightening.

HTH,
Nikos
 
Back
Top