Perhaps I'm phrasing it wrong, but my searches have been fruitless.

Can I check to see if a table exists in an SQL database from within MS Access?

You can query sysobjects using something along the lines of:


SELECT *
FROM dbo.sysobjects
WHERE id = object_id(N'[dbo].[YourTable]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1