Access mdb in multi user mode

[John]

Hi guys,

I have a VB application that uses MDB as database, the MDB is on a network
driveed, I received complaints about data entered on some computers can not
be seen from other computers.

To isolate the probelm, I asked 2 users to do some testing. User A on his
computer entered a new record into a table "inventory" through MS Access,
not my VB program, then user B opened the same MDB using MS Access, user B
claimed he can not see the new record. However if user B entered a new
record to the same table, user A has no problem seeing it. I asked the
users to close and reopen MS Access serveral times, they said no
differences.

The database was originally created using Access 2000, both users A and B
use MS Access 2003 though, I don't think that matters.

Any Ideas?

TIA

 

[Tom Wickerath]

Hi John,

Can we assume that both users A & B can see records that each of them has
added, after closing the form and re-opening? In other words, can User B see
a record that they added, after closing the form and re-opening it?

Can you see the records if you open the tables directly? If so, it might be
a missing foreign key issue, or perhaps the form is being closed by code, but
a required field has not been filled in. Just guesses on my part. See these
articles for more information:

The Query Lost My Records!
http://allenbrowne.com/casu-02.html

Losing data when you close a form
http://allenbrowne.com/bug-01.html

Incorrect filtering
http://allenbrowne.com/bug-02.html

Common Errors with Null
http://allenbrowne.com/casu-12.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________