XXX Chats

dating international russia philippines

Current recordset does not support updating access

Normally the db would be split and it is only the back end that would be replicated. Even if I were to make the requested changes, the front-end would have to be distributed to all users to take effect.

Since I am not at the client location, this would prove to be too complicated to do remotely.

A Boolean value indicating whether or not to force the changes into the database, regardless of whether the underlying data has been changed by another user since the Add New, Delete, or Edit call. Close End Sub Sub Update X2() Dim dbs Northwind As Database Dim rst Employees As Recordset Dim str Old First As String Dim str Old Last As String Dim str Message As String Set dbs Northwind = Open Database("Northwind.mdb") Set rst Employees = _ dbs Northwind. " If Msg Box(str Message, vb Yes No Cancel) = vb Yes Then .

I tried this: https://support.microsoft.com/en-us/kb/290052 But received the same error. I'm not even sure how a database is replicated to begin with.

Is there something I can tell the client to do to make their database more friendly with updated Access?

This may be a limitation of the provider, or of the selected locktype.

This may be a limitation of the provider, or of the selected locktype.

Comments Current recordset does not support updating access