Why does a form not show all records? (1 Viewer)

[Tiger955]

Hello!

I have a problem with an Access 2010 accdb connected to SQL-server 2008 tables.

There are 3 users entering data in a certain form. Whenever a new record is added, the recordcounter in the navigation bar does not show the actual number of records and a new record of another user cannot be found either. I tried it with linking the form to a view and directly to the table, but this has no influence.

The acivation interval of the ODBC connection (records update, etc.) is set to 5 sec. but does not solve the problem. In an existing record a change of values shows at once, as I set the interval to 250 ms.

Maybe I am doing something wrong at all, when entering data in a form by many users.

I know, that the recordsource has to be refreshed (requery) but how should I do this in an opened form (by timer?? with a bookmark on the current record??).

Please help me on that issues as this leads also to duplicates when different users try to insert the same data into new records.

What is to best was to update a form?

Thanks
Michael

 

[Mihail]

Maybe you should look to the Record Locks property.
This is an idea, not a solution.
Regards.

 

[Tiger955]

Hi Mihail!

It is not a problem of locking the records - which I solved allready - it is the problem of seeing ALL records on this form.

 

[jdraw]

see if this helps
http://msdn.microsoft.com/en-us/library/office/bb238068(v=office.12).aspx