PDA

View Full Version : Excel + Access Help



Mohideen
01-31-2011, 09:36 AM
Hi,

I have created one application, which takes input from multiple users at a single point of time and adds that record into access mdb file.

Now the issue is it is giving error as "Current Recordset does not support updating. This may be a limitation of the provider, or of the selected LockType.

Any help on this......

Kenneth Hobs
01-31-2011, 09:51 AM
Does a user have it locked?

What type lock did you set?
e.g.
RecordSet.LockType = adLockOptimistic