is UPDATE or DELETE QUERY able to touch another database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mezzanine1974 - 21 May 2008 09:08 GMT

Is it possible to UPDATE or DELETE any record which is located on
another database table, by using update and delete query?
I can manipulate a table on another database by using APPEND and MAKE
TABLE query.
Thank you for any help.

Reply to this Message

Douglas J. Steele - 21 May 2008 11:39 GMT

UPDATE [;DATABASE=E:\Folder\File.mdb].TableName
SET Field2 = 4
WHERE Field1 = 2

DELETE FROM [;DATABASE=E:\Folder\File.mdb].TableName
WHERE Field1 = 3

Of course, you can also just link to the table.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is it possible to UPDATE or DELETE any record which is located on
> another database table, by using update and delete query?
> I can manipulate a table on another database by using APPEND and MAKE
> TABLE query.
> Thank you for any help.

Reply to this Message

mezzanine1974 - 21 May 2008 13:30 GMT

Hello Doug,
Thanks for your explanaiton.
I tried all combinations below but i failed. Could you please clarify.
I can not fix Syntax problem.

UPDATE [;\\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb].Tbl_Nakladnaya
UPDATE [;' \\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb'].Tbl_Nakladnaya
UPDATE ' ;\\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb'.Tbl_Nakladnaya
UPDATE ";\\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb".Tbl_Nakladnaya
UPDATE [' \\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb'].Tbl_Nakladnaya
UPDATE ' \\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb'.Tbl_Nakladnaya
UPDATE "\\mer_rus_1\financedata$
\X_FROM_YULIA_TO_LILIYA_X.mdb".Tbl_Nakladnaya

Reply to this Message

Douglas J. Steele - 21 May 2008 14:13 GMT

You're mssing the DATABASE= part of the address:

UPDATE
[;DATABASE=\\mer_rus_1\financedata$\X_FROM_YULIA_TO_LILIYA_X.mdb].Tbl_Nakladnaya

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello Doug,
> Thanks for your explanaiton.
[quoted text clipped - 15 lines]
> UPDATE "\\mer_rus_1\financedata$
> \X_FROM_YULIA_TO_LILIYA_X.mdb".Tbl_Nakladnaya

Reply to this Message

mezzanine1974 - 22 May 2008 14:25 GMT

It is working excellent now!
I tried before with DATABASE part and failed. But i understood that
SET and WHERE parts of my SQL code was wrong.
Thank you Douglas

Reply to this Message