Added records not always viewable

[dimorg]

I have a multi user database. Front ends are stored on each users local drive. Back end is on a nw drive (though have a
lso tried on an individual machine).

users can open a form to see existing data but are also able to add new records. Depending on the user, these addiitons are sometimes visible to the others, sometimes not. Requerying or refreshing has no impact. Nor does refreshing the link through linked table mgr. The only way the newly added records become visible is if the user who cannot see them closes their entire front end opens it again.

the real problem arises in that if the user who cannot see the new records, adds one of their own, the db corrupts.

[zmbd]

+ version of access?
+ VPN, or how is the connection being established?
+ You need to check your front-ends and make sure that they are not opening or attempting open the backend as exclusive - default the open to shared and either no locks or only edited record.
Might also be advisable to use the record level locking by default.
+ The logic of the database may be at fault too... without any understanding of your table structures it's difficult to tell.

++ Keep in mind, by design, the forms make essentially a "snap-shot" record set upon open. It's rare that a form would not pickup new records on me.requery; however, if you have a subform, that form also has to be requeried.

>> A me.refresh will not work to show the new records in a shared situation.

++ We also need to understand what is happening during the new record addition. Are you using a primary key Is that key generated via an autonumber field or as a programmatically generated value?