Just remember that views appear as tables and not queries in an Access database!

Direct usage of the tables in Access will not be possible unless you have an OLE DB or ODBC driver for the backend database. If the database is from the...

The very presence of this comment:

"PDF's are almost as good and more commonly used of course, with the advantage that document maps are translated to bookmarks that are usable -...

Perhaps the dbo designation is based on how you're authenticating to the SQL Server. If you import the tables under a dbo-equivalent account (like SA), they'll be owned by dbo....

This article on Microsoft's support site might shed some light on the error:

http://support.microsoft.com/kb/272358/en-us

Hope this helps!

This is a common security issue with ASP and Jet. It and its solution is documented in two articles on Microsoft's support site:

http://support.microsoft.com/kb/295297/en-us

and

http://support.microsoft.com/kb/315456/en-us

Basically, the NT account used by...

It is likely that the SQL Server running your linked server is running under a security context that only has read access to the Excel file. If you have not specified...