How to delete data of other database from current one??

[Mayo123]

I need to delete the data of a table which is located in another Access database. How can I do it?
Thanks for your help!

 

[PHV]

Why not linking the table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mayo123]

I can't do the linking.
So is it possible?

As always, PHV, thanks for your help!

 

[PHV]

So is it possible?
menu File -> External data -> Link tables

The spelling may be different as I don't play with an english version of access.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

How about something like

DELETE FROM OtherDB_Table[b]@TheOtherDB_Name[/b]
WHERE predicates;

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[PHV]

Skip, I think the JetSQL syntax is:
DELETE FROM OtherDB_Table IN \Path\to\TheOtherDB_Name.mdb
WHERE predicates;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Maybe.

Works for me connecting to an Oracle database from Access or MS Query.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[Mayo123]

I tried DELETE FROM OtherDB_Table IN \Path\to\TheOtherDB_Name.mdb
but it failed on me. Maybe I just don't know how use sql statement by adding IN \Path\to\TheOtherDB_Name.mdb at the end. Can you help me out with this?
Thanks!

 

[Mayo123]

I finally made it work by using:
DELETE FROM OtherDB_Table IN \Path\to\TheOtherDB_Name.mdb

Thanks a lot, PHV!!!