ADP Project not Prompting Me for an SQL Password

A

Altemir

I have an ADP project that has the following characteristics:

1) On startup, an autoexec macro automatically loads a form whose
record source is view 'qryXYZ'

2) View 'qryXYZ' is based on table 'tblABC'

3) Table 'tblABC' is a linked table that is linked using Transact SQL
to a table in another database

4) I believe that restricted user permissions for 'tblABC' are
properly set up in SQL Server

I was expecting users to be prompted to enter an SQL Server password so
they could get authenticated for 'tblABC', but no password prompt ever
comes up.

I'm using CurrentProject.Connection.Properties("User ID").Value to trap
the current user's name. For some resson it always recognizes me as
'SA' even though I have not explicitly logged in. I've run the ADP on
other users' machines and their current user name goes unrecognized
(i.e., CurrentProject.Connection.Properties("User ID").Value returns
'#name').

This has worked fine on other databases I've built. What could I be
missing that is causing users to go unauthenticated?
 
S

Sylvain Lafontaine

SQL-Server cannot prompt you for a password for the table tblABC because any
communication with SQL-Server requires that you have an open connection with
it and therefore that you are already authenticated. The authentification
with SQL-Server is done at the level of SQL-Server itself and not at the
database level.

For you second problem, this is probably because you are using integrated
security in your connection string.
 

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