Hi Folks,
I am working on a non-profit database for the county. I am pleased with the database, but have a problem that I cannot seem to find a remedy to.
I have a access front-end database that is linking into SQL Server. A main form is used to populate the linked table. The table is actually linked to the SQL Server. Everything works perfect, except the refresh rate. Three people use this database at the same time, and anytime data is entered, it is successfully stored on SQL Server via Access. However, if any one of the users enter data, it takes a very long time for the other users to see that data via the main form. The strange thing is that if the users open the table link to SQL Server from Access, the new data can be seen immediatly. And, if a user closes out of the database then logs back in, the data can be seen in the form.
I have tried a refresh macro, I have tried a refresh button that is pushed before the user wants to view the record that another user has just entered, and I have tried to go into the Advanced Options menu and set the refresh rate as well as the refresh interval to 1 second ... nothing works. If someone can please help me out, I would really appreciate it! Thank you.
I am working on a non-profit database for the county. I am pleased with the database, but have a problem that I cannot seem to find a remedy to.
I have a access front-end database that is linking into SQL Server. A main form is used to populate the linked table. The table is actually linked to the SQL Server. Everything works perfect, except the refresh rate. Three people use this database at the same time, and anytime data is entered, it is successfully stored on SQL Server via Access. However, if any one of the users enter data, it takes a very long time for the other users to see that data via the main form. The strange thing is that if the users open the table link to SQL Server from Access, the new data can be seen immediatly. And, if a user closes out of the database then logs back in, the data can be seen in the form.
I have tried a refresh macro, I have tried a refresh button that is pushed before the user wants to view the record that another user has just entered, and I have tried to go into the Advanced Options menu and set the refresh rate as well as the refresh interval to 1 second ... nothing works. If someone can please help me out, I would really appreciate it! Thank you.
