Check if SQL table exists from Access

[wh00t]

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?

 

[tehNellie]

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