Records Not Showing Up on Form on Different Computers???

[batowl]

Hi All,

I recently built and deployed a database for my colleagues at work but we are running into a problem that makes no sense to me.

On my computer when I enter a record into the database, everyone else in the office can go into the database, open the form, and see the record I created. All is good.

However, when one of my colleagues enters a record into the form on their computer, that record does not show up on the form on anyone's computer. Not mine and - after they exit the form then re-enter it, not on theirs. (The record they created on their computer does show up in the underlying table though).

Is there some kind of setting in Access that would make this happen? I am at a loss for how to explain this, fix it, and get this database working properly.

[orange]

Tell us about your database. Is it split? Is the BE stored on a shared server? Does each user have their own copy of the FE?
We need more info.

[batowl]

No, the database is not split. It is just one file that people access once at a time individually on their computer. This file is stored on our local server.

[batowl]

I tried splitting the database and the same problem occurs.

[burrina]

Is it shared, are Locks enabled? Under Client Settings!

[batowl]

Um, I have no idea how to find where the Client Settings are or how to change them. Could someone please guide me?

[Missinglinq]

Records 'disappearing' after a given user closes and then reopens the Form suggest that the Form's Data Entry Property is set to Yes. This only allows the entering of New Records, not the viewing of existing Records. The property's name is very misleading! It does not have to be set to Yes in order for data to be entered!

In Form Design View go to Properties - Data and if it is currently set to Yes,change the Data Entry Property to No.

And to avoid future major problems, you have to keep this app split, with the data in the Back End, on a shared drive, and a copy of the Front End, with everything else, on each users hard drive.

Linq ;0)>

[burrina]

Sage advice. Look under File/Options.