force user to signon to ODBC source

[nolanmadson]

I'm developing an MS Access application that creates and executes
stored procedures on a Teradata system using SQL Pass Through queries.
I want the users to have to perform those functions using their own
Teradata UID and password. I've tried omitting Password and UID from
the connect string, but I get a response that there isn't enough
information to sign on. It seems as tho the messages I've found here
are asking how to AVOID asking the user to enter pw and ID. How do I
REQUIRE them to enter that information?

TIA,
Nolan

[Gord]

no*********@gmail.com wrote:

I'm developing an MS Access application that creates and executes
stored procedures on a Teradata system using SQL Pass Through queries.
I want the users to have to perform those functions using their own
Teradata UID and password. I've tried omitting Password and UID from
the connect string, but I get a response that there isn't enough
information to sign on. It seems as tho the messages I've found here
are asking how to AVOID asking the user to enter pw and ID. How do I
REQUIRE them to enter that information?

If you are using ADO, try something like this:

Set con = New ADODB.Connection
con.Properties("Prompt") = adPromptComplete
con.Open strConnect