We currently have a SQl 2000 database installed on a 2k member server. We are using 2000 pro boxes installed in seperate domain as workstations and an access 97 front end to connect. When we login as administrator we can connect fine, all tables link and they use the connection type specified. Any other account cannot. Once we connect as admin on the box, logout, and then log back in as a general user we can connect to the database, however the links use Other as a connection type versus the Named Pipes we specified. Any help is greatly appreciated.
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cannot Link Tables without being an Admin
- Thread starter shazbot
- Start date
Similar threads
- Question
- Locked
- Question