Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Views and Underlying tables w/ Access Data Projects
Thanks again. The first article describes EXACTLY what I need to accomplish. However, there is only one problem: I am running SQL Server 7.0 and the VIEW_METADATA option only exists in SQL Server 2000. I also tried to do set it up through Access as described in the article, but I didn't see...- S22
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Views and Underlying tables w/ Access Data Projects
Thank you all for your help. Unfortunately, I still have had no success. When I try this code this is the error I get when trying to update a record in the view: SELECT Permission denied on object 'testtable', database 'testdb', owner 'dbo' If I grant SELECT permission to the user for the...- S22
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Views and Underlying tables w/ Access Data Projects
I don't know if there is a fundamental problem with what I am trying to do, or am I just having problems setting it up correctly: I have a SQL server multi-user database. I want my users to connect to this databsase via Access 2000 Data Project. No problem there. The database consists of one...- S22
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
