User rights issue

  • Thread starter Thread starter Scotty7
  • Start date Start date
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
 
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?
 
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)
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
 
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
Click to expand...
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
 
Back
Top