Linked Tables Refresh

[rajeshsarin]

Folks,

I have a database with front of each user (about 15) and a backend that sits on Windows SBS 2008.

The issue I am facing is that when one user inserts a new record in the database, the other users who already have the database open on their machines cannot view it.

Either the others users have to close their front and and then restart it to see and get access the updated record or they have to press F5 to refresh the database.

How can I avoid this problem? and why is it happening?

Cheers

Raj

 

[pbaldy]

Typically you need to requery the form users are viewing records with.

 

[rajeshsarin]

Typically you need to requery the form users are viewing records with.

I how do I achieve that? I am not very conversant with VB

 

[pbaldy]

From within the form, the code would be:

Me.Requery

 

[rajeshsarin]

Reply: Linked Tables Refresh

From within the form, the code would be:

Me.Requery

and where should I insert this code? On some event in the main form? or create a button and put hte code behind the button.

 

[pbaldy]

Depends on your needs. You could use a button, or the timer event to run it every few minutes or whatever, or whatever fits your situation best.

 

[rajeshsarin]

Thanks for the suggestions.

I used the Me.Requery behind a button and it works well.

However when I use On_Timer & Timer_Interval things to a bit ackward.

Timer_Interval = 30000
On_Timer = Me.Requery

When I am entering some notes for customer number 220, and while in the middle of typing the notes the from refereshes, it takes me back to customer no 1.

How do I avoid this?

 

[pbaldy]

You can use technique like this to stay on the same record:

http://www.baldyweb.com/Requery.htm

 

[rajeshsarin]

Reply: Linked Tables Refresh

Thanks,

Works like a dream