Hi!
I have a big problem when requering a form (in Access 2010 runtime) connected to SQL-server 2008 R2.
a branch of our company is 600 km away and the users are connected via ODBC to the server. I have local tables but as much as possible I use stored procedures on the server.
The main form which many users put in data have to be refreshed (by requery) in an intervall of 2 minutes by a timer-event on the main form, otherwise the data of the other users are not included which leads to duplicates, although I check for duplicates (recordsetclone) when entering date in the namefield.
When the requery starts the application seems to get a timeout and has an interrupt for ALL other opened forms as well.
That means, even if the main form has not the focus the user cannot work in other forms and the blue circle appears for a certain time, up to 10 seconds and "paralyze" the whole application.
In Access options for the clients the intervalls are short, but this brings no requery of course, so there might not be a screw to draw further.
Is there any way to change this behaviour of the main form and still requery the main from? I have to "reload" the main form somehow.
Thanks your help
Michael
I have a big problem when requering a form (in Access 2010 runtime) connected to SQL-server 2008 R2.
a branch of our company is 600 km away and the users are connected via ODBC to the server. I have local tables but as much as possible I use stored procedures on the server.
The main form which many users put in data have to be refreshed (by requery) in an intervall of 2 minutes by a timer-event on the main form, otherwise the data of the other users are not included which leads to duplicates, although I check for duplicates (recordsetclone) when entering date in the namefield.
When the requery starts the application seems to get a timeout and has an interrupt for ALL other opened forms as well.
That means, even if the main form has not the focus the user cannot work in other forms and the blue circle appears for a certain time, up to 10 seconds and "paralyze" the whole application.
In Access options for the clients the intervalls are short, but this brings no requery of course, so there might not be a screw to draw further.
Is there any way to change this behaviour of the main form and still requery the main from? I have to "reload" the main form somehow.
Thanks your help
Michael
