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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-31 : 22:00:07
|
Chris writes "I used the upsize wizard in Access2000 to create an ADP (Access Data Project) to SQL Server 6.5 (NT4 Server w/SP4). Almost everything went okay, but the only people that can get into the DB are the DBO (me) and sa; nobody else can do anything! I even tried giving everybody permission to everything with no luck. Seems like the SQL Enterprise Manager and Access don't agree on who has permission to what. I'm using NT authentification. Clients vary from Win98 to Win2000.
Any advice? I'm new to SQL Server, so pardon my green-ness. The DB is working great... too bad nobody can access it. I'm perplexed?!" |
|
|
|
|
|
ADP Permissioning Problems