Forums

This topic is locked

Sql t reference Access object for view

Posted 23 Sep 2010 19:48:58
1
has voted
23 Sep 2010 19:48:58 Rick Beach posted:
Please let me know the correct syntax to use that will allow a SQL View to reference an Access Fom Object. Below is a sample of the View in the SQL Database. The "WHERE" statement is what I need.

SELECT EmployeeID
FROM [Shared Tables].dbo.[Employees Table]
WHERE (EmployeeID = [AuditV20.mdb].Forms.Test.Test)

Reply to this topic