Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rbeach1955
Starting Member
8 Posts |
 Posted - 2010-09-23 : 14:46:01
|
| 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 EmployeeIDFROM [Shared Tables].dbo.[Employees Table]WHERE (EmployeeID = [AuditV20.mdb].Forms.Test.Test) |
|
|
sql-programmers
Posting Yak Master
190 Posts |
Posted - 2010-09-24 : 07:12:25
|
| where you are using this script, I assume you are running this script in sql.It is not possible to refer the mdb form object. You can only refer the mdb table's in sql by using the Linked Server concept. check this link for configuring linked server,http://www.sql-programmers.com/SQLResources/ManagementStudio/LinkedServers.aspxSQL Server Programmers and Consultantshttp://www.sql-programmers.com/ |
 |
|
|
|
|
|
Reference Access Form Object