Deleting Linked SQL Server Table - Linked as Pass Through Query

J

JimP

How do I delete a linked SQL Server Table linked as a Pass through Query,
e.g.

DoCmd.DeleteObject acQuery, "TableName"

creates a 7874 error - cannot find the object.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
On Error not working 2
On Error not functioning 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
Access to SQL 4
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Pass Through Queries (Access 2002) 2
Delete a Query, or Empty it and Reload With New SQL? 3

Top