Deleting Table Contents in a different file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chase - 22 Nov 2005 13:40 GMT

Without linking to another database, how do you delete the contents of a
table in one database as part of a process in a second database?

Reply to this Message

Marshall Barton - 22 Nov 2005 15:14 GMT

>Without linking to another database, how do you delete the contents of a
>table in one database as part of a process in a second database?

A rather dangerous thing to do so make sure you have made a
copy of the other mdb file first.

You can use the IN phrase in a Delete query's From clause:

DELETE *
FROM thetable
IN "pathtoothermdb"

Signature

Marsh
MVP [MS Access]

Reply to this Message

Chase - 22 Nov 2005 16:29 GMT

Thanks but I get the following error 3131 Syntax error in FROM clause.
hears the code
StrSQL = "DELETE tblPropertyCopy.* FROM tblPropertyCopy
IN C:\VolumeDatabase\WarehousePropertyCopy.mdb;"

CurrentDb.Execute StrSQL

> >Without linking to another database, how do you delete the contents of a
> >table in one database as part of a process in a second database?
[quoted text clipped - 7 lines]
> FROM thetable
> IN "pathtoothermdb"

Reply to this Message

Marshall Barton - 22 Nov 2005 21:52 GMT

You forgot the quotes around the path:

StrSQL = "DELETE tblPropertyCopy.* FROM tblPropertyCopy
IN ""C:\VolumeDatabase\WarehousePropertyCopy.mdb"""

BTW, an obscure, archaic, alternative syntax is:

StrSQL = "DELETE tblPropertyCopy.* FROM " & _

"[C:\VolumeDatabase\WarehousePropertyCopy.mdb].tblPropertyCopy"

Signature

Marsh
MVP [MS Access]

>Thanks but I get the following error 3131 Syntax error in FROM clause.
>hears the code
[quoted text clipped - 14 lines]
>> FROM thetable
>> IN "pathtoothermdb"

Reply to this Message