Project with SQL Server 2005 back-end using a schema

P

Paul Linton

Hi,
My SQL Server 2005 database has some tables in a schema apart from dbo.
For example there is a table called Audit.AuditEvents
I can open and read this table from VBA using a recordset
rst.open "Select * from Audit.AuditEvents", CurrentProject.Connection
I can see the table in the database window but if I double click to open
it I get
"ADO error: Object 'dbo.AuditEvents' does not exist or is not a valid object
for this operation"
How do I tell Access what the correct name of the table is? Or do I just
need Access 2007?
thanks in advance
Paul
 
Top