Excel + Access Help

[Mohideen]

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]

Does a user have it locked?

What type lock did you set?
e.g.
[VBA] RecordSet.LockType = adLockOptimistic[/VBA]