Mike_In_Ga
Registered User.
- Local time
- Today, 05:34
- Joined
- May 27, 2008
- Messages
- 32
I have connected to a SQL Server Db and pulled in all the "tables". The problem is that some of the "table" are actually SQL views. How can I use the Linked table GUI to ull in only actual SQL tables and exclude the SQL views? It seems that the ODBC connector tool treats a SQL view and SQL table as the same object......ot perhaps in the background Access knows the difference but does not show that to the user in the GUI.
I am trying to run a module I created that performs a bunch of UPDATE procedures to the SQL Db and it is failing because it tries to run the procedure on a view and fails. I can even manually delete the views from the Access Db but I dont know how to tell if the linked Objects in the Access Table screen are SQL views or SQL tables. Unfortuneately I dont have access to the server SQL is sitting on to look directly at the source Db.
I am trying to run a module I created that performs a bunch of UPDATE procedures to the SQL Db and it is failing because it tries to run the procedure on a view and fails. I can even manually delete the views from the Access Db but I dont know how to tell if the linked Objects in the Access Table screen are SQL views or SQL tables. Unfortuneately I dont have access to the server SQL is sitting on to look directly at the source Db.