I used Mgmnt Studio to create a Linked Server which "links" to an Access mdb. ( I think)
How do I create a view in an Access ADP to a table in the Linked Server.
How do I create a view in another SQL database to a table in the Linked Server.
I currently have this SQL statement which does not work.
Trackdata: Name of Linked Server
CStrackData: Name of MDB file
tbljob: Name of table in the mdb
I tried with / without the dbo
I have not done anything with DTC (ie have not turned it on or off in any way)