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?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,368
Office Version
2019, 2016, 2013
Platform
Windows
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 ?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,510
Messages
5,487,310
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top