Windows Forum

Ask something
Discussion Locked

Using MS Access to link to SQL backend.

0 helpful
1 reply

by gjonascu

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an SQL srv 2000 STD SP3a with a db that has AD user security setup and AD users have been given access to the DB.

From the client machines, I created an ODBC SQL Server driver w/ Win Authentication to the SQL DB for the db. I'm using MS Access 2000 to create table links so the SQL tables can be modified. But when any users that is setup on the SQL Server users container tries to add a new record they can not. The menu item is grayed out.

What I have tried.
1. tried different users including domain administrator.
2. Created DB on different SQL Server and improted the data same problem.
3. Crated a SQL user only and granted access to the db but still same.

Any suggestions.

1 reply

by theohkm

From you words, I believe it can be solved without huge difficulties.

I'd like to suggest that:
- Try to remove all security settings.
- Try to find a documentation or article that closely exemplifies your requirement.
- Follow the examples and see if it works.

If it does not, it may relate other issues such as security updates, service packs and drivers combinations, etc.

Hope it helps!

This discussion is closed to new replies.