Linking to SQL Server 2000 views?

cronid

Registered User.
Local time
Today, 14:16
Joined
Dec 26, 2004
Messages
10
In Access can I link to a SQL Server view? I am currently linking to the
SQL Server tables in my database and don't have any views. But if I can link to views I could give the workgroup permissions in Access to the views, not to the primary tables. This would provide some added security from the user who bypasses my switchboard forms and goes to modify the Access tables directly.
 
Yes; it will appear just like a table when linking.
 
That works fine.

Thanks

Den
 

Users who are viewing this thread

Back
Top Bottom