Users cannot access data entered by others in a shared BE!!!

[Bee]

Hi folks,

I've a BE/FE database where the BE is on the server and the FE on different PCs. I have got linked tables in my FE and the connection between them and the BE is correct; however, users cannot view data entered by others. They can only view data entered by themselves!!

I'm not sure if the records are getting locked that's why they can't see others inputs.


Any help will be very much appreciated,
B

 

[Jibbadiah]

Bee,

Suggest that you run a few tests just against the linked tables first.
Check that data entered in the linked table of one f/e is shown on the back-end db.
Check that the data entered on the linked table of one f/e is also shown on the linked table of another f/e.
If these tests are ok then you may have a problem refreshing it from within your form.

Anyone else with suggestions?!

J.

 

[Rabbie]

A user may need to open the table after the other has updated the table. You dont always see records added after you opened the table.

 

[Bee]

Will try that - thanks Jibbadiah.
I don't understand what you mean Rabbie. Can you elaborate please?

 

[Rabbie]

Will try that - thanks Jibbadiah.
I don't understand what you mean Rabbie. Can you elaborate please?

I will try to explain.

In Time order - earliest first

User A opens table and views through form

User B opens Table in form

User B adds record to table from form

User B exits from tableand Form

User A scrolls through form to end of table. Unless User A has requeried the data for the form they will not see the record added by User B.

I hope that is a little clearer now. Let me know if it is still not clear