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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Access linked tables to sql server

Author  Topic 

neil
Starting Member

29 Posts

Posted - 2003-01-14 : 09:20:18


I want to give certain users access to tables in sql server but can't give these user sql server client. I thought of using linked tables in access is this the best way ?

Thanks

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-01-14 : 09:21:58
Yeah, it works very well, and it's actually better than giving them Enterprise Manager anyway (EM is NOT NOT NOT a data browsing or editing tool)

Go to Top of Page

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-14 : 09:25:21
If you're going to use access try an access data project.
You will have sps,views,triggers,diagrams along with the usual
forms,reports,datapages.
You can also create nice forms with data verification if they are going to be doing data entry.





Edited by - ValterBorges on 01/14/2003 09:29:29
Go to Top of Page
   

- Advertisement -