Error 3251: Current recordset does not support updating, this maybe the limitation of provider or locktype

Ngoclong226

New Member
Joined
Mar 20, 2019
Messages
5
Hi all
Currently i encounter with a problem just as the title
I have a program writing in excel vba and interact with 1 access data base.
It allow user to input their data from excel user form to access. And some simple query to extract the collected data.
Total user connect to database is about 25.
The problem sometime happen, when i close all the user file. Then reopen it become OK.
Anyone know the reason?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
the machine that holds the Db, does it have enough memory/resources to be able to handle 25 simultaneous continuous connections, could each be timed out after ten minutes on non use ?
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top