User rights issue

Scotty7

unread,

Sep 15, 2009, 11:51:01 AM9/15/09

to

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

Scotty7

unread,

Sep 15, 2009, 12:12:02 PM9/15/09

to

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?

Sylvain Lafontaine

unread,

Sep 15, 2009, 5:14:00 PM9/15/09

to

Very strange. Are you sure that you have saved the right password and that
you are really connecting using the sa account?

--
Sylvain 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)

"Scotty7" <Sco...@discussions.microsoft.com> wrote in message
news:E29096B5-B16C-49A2...@microsoft.com...

Sylvain Lafontaine

unread,

Sep 15, 2009, 7:03:38 PM9/15/09

to

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.

--
Sylvain 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)

"Sylvain Lafontaine" <sylvainlaf...@yahoo.ca> wrote in message
news:uvYf$lkNKH...@TK2MSFTNGP05.phx.gbl...

Scotty7

unread,

Sep 17, 2009, 9:48:01 AM9/17/09

to

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

Gema ; Rodriguez

unread,

Dec 18, 2009, 12:38:31 PM12/18/09

to

"Scotty7" <Sco...@discussions.microsoft.com> escribió en el mensaje de
noticias news:E29096B5-B16C-49A2...@microsoft.com...

Gema ; Rodriguez

unread,

Dec 18, 2009, 1:06:44 PM12/18/09

to

"Scotty7" <Sco...@discussions.microsoft.com> escribió en el mensaje de
noticias news:E29096B5-B16C-49A2...@microsoft.com...

Gema ; Rodriguez

unread,

Dec 21, 2009, 2:01:04 PM12/21/09

to

voy, a, ser, tia,

"Scotty7" <Sco...@discussions.microsoft.com> escribió en el mensaje de
noticias news:E29096B5-B16C-49A2...@microsoft.com...

laura trammell

unread,

Jan 25, 2010, 3:43:57 PM1/25/10

to

well this is what u should do turn your computer off
"Gema ; Rodriguez" <santander:cantabria> wrote in message
news:e9$WdzAgK...@TK2MSFTNGP06.phx.gbl...

thomas

unread,

Feb 6, 2010, 6:10:46 AM2/6/10

to

"Gema ; Rodriguez" <santander:cantabria> a écrit dans le message de
news:OfdXsjAg...@TK2MSFTNGP04.phx.gbl...