User rights issue

S

Scotty7

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
 
S

Scotty7

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?
 
S

Sylvain Lafontaine

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

Sylvain Lafontaine

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 said:
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 said:
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
 
S

Scotty7

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

Sylvain Lafontaine said:
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 said:
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 said:
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
 
G

Gema ; Rodriguez

Scotty7 said:
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
 
G

Gema ; Rodriguez

Scotty7 said:
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
 
L

laura trammell

well this is what u should do turn your computer off
Gema ; Rodriguez said:
Scotty7 said:
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
 
T

thomas

Gema ; Rodriguez said:
Scotty7 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top