Edit a recordset direct in a linked table

[primagic]

Hi
I have a database with forms and queries and the tables linked to a seperate database.

How can I updated the recordset in a linked table directly from a form in the other database.

I can do it if the tables were in the same database as the queries and forms using but how would i change the code to update a linked table?

Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("tblxxx)
rst.Index = "PrimaryKey"
rst.Seek "=", Me.xxxx
rst.Edit
rst!xxx = Date
rst!.Update
rst.Close

 

[JBinQLD]

If it's linked, then code will treat it the same - what error are you getting with your logic?

I assume that the missing <red>"</red> on

Set rst = CurrentDb.OpenRecordset("tblxxx)

is just a typo?

JB

 

[primagic]

yes its a typo

If I leave the code as above I get the message

"Operation is not supported for this type of object"

Worked when I had them all the tables with the queries and forms together

 

[JBinQLD]

which line is highlighted with the error mate?

Have you tried it without the DAO, just:

dim rst as recordset
set rst=currentdb.openrecordset("XX", dbopendynanset)

and then

rst.findfirst "YourField=" & me.xxx

finally,

rst!.update

The bang (!) is typo too right? Cos naturally it should be just .

Hope this helps, JB

 

[dhookom]

You can't use "Seek" on a linked table from another database when using "CurrentDb".

Set rst = CurrentDb.OpenRecordset("tblxxx)

You must replace CurrentDb with a database object of the remote mdb. Check How to perform Seek on Linked Tables

Duane
Hook'D on Access
MS Access MVP