 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / February 2010User rights issue
Hi I'm having the following issue with user rights. My ADP connection is using the sa account, and I save the password. I can see all the tables, however, after each table it has (NT Authority\Auth Users) When I try to open a table I get the following error; ADO error: Object '[NTT Authority\Auth Users].t_table1' does not exist. I believe it's a sql server rights issue, but sa is the owner of the db - so I'm confused. sql server is running in mixed auth mode. Thanks for any help. Scott I think I narrowed the issue down. I can see db.sysdiagrams, but I cant see any of the other schema users tables. Shouldn't the sa account be able to see all shemas? > Hi I'm having the following issue with user rights. > [quoted text clipped - 11 lines] > > Scott Very strange. Are you sure that you have saved the right password and that you are really connecting using the sa account?  SignatureSylvain Lafontaine, ing. MVP - Windows Live Platform Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please) Independent consultant and remote programming for Access and SQL-Server (French) > Hi I'm having the following issue with user rights. > [quoted text clipped - 12 lines] > > Scott I would suggest that you reconnect the ADP project but this time, without saving the password. This way, when the system will ask you for the password, we'll be sure that you are connecting using the sa account. SignatureSylvain Lafontaine, ing. MVP - Windows Live Platform Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please) Independent consultant and remote programming for Access and SQL-Server (French) > Very strange. Are you sure that you have saved the right password and > that you are really connecting using the sa account? [quoted text clipped - 15 lines] >> >> Scott Thanks for the reply. I connected the tables using the sa account. I can get to the data if I set a forms record source using the fully qualified name ProdUser.Table1. This will work for now - but it would be nice just to set the forms record source to the table. Thanks again. Scott > I would suggest that you reconnect the ADP project but this time, without > saving the password. This way, when the system will ask you for the [quoted text clipped - 19 lines] > >> > >> Scott > Hi I'm having the following issue with user rights. > [quoted text clipped - 12 lines] > > Scott >> Hi I'm having the following issue with user rights. >> [quoted text clipped - 12 lines] >> >> Scott > Hi I'm having the following issue with user rights. > [quoted text clipped - 12 lines] > > Scott well this is what u should do turn your computer off >> Hi I'm having the following issue with user rights. >> [quoted text clipped - 12 lines] >> >> Scott voy, a, ser, tia, > Hi I'm having the following issue with user rights. > [quoted text clipped - 12 lines] > > Scott |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.