Way Around Delete Query Not Working

[marcon]

I have an access db on another server and when I try and run or save the delete query from my desk an error occurs. It indicates that access is looking for the database on my c drive.

Is there away around this? Do I have to copy it on my c drive save the query and then put it back out there?


The sql is very straight forward

Delete from table1
where table1.pn IN ( Select table2.pn FROM table2)


Any help or comments appreciated!

 

[tlbroadbent]

Are you opening the database on the server in Access? Or are you doing this through a front end databse or program? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[marcon]

Yes I am opening access up on the server. Thanks for the response!

 

[tlbroadbent]

Is either table a linked table? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.