Bypassing logon screen of a a VBA form bound to table linked to Oracle

[mozgheib]

Hello,

I was wondering how can I make my forms that are
bound to linked tables not ask about a user logon
to the database via odbc. I want to give control
to a switchboard that has a logon main screen that
loads the forms and ask for one logon instead.

Thanks.

 

[oharab]

When you join link the tables, make sure you enable the save password option. That way it won't ask you for the password at any point.
Alternatively, you will have to loop through all the linked tables and change the connect string to have the users password.

hth

ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[mozgheib]

Hello,

Since I want to capture the logon user and not
save the same user for every time I went with
option two.

Now, what I did I am looping thru the tables
collection and if I find the table that is bound
to my form I call a connection object. I then load
the form. The problem is I am still getting the forms
logon screen.

Do I need to pass a parameter when calling the form??
Please advise.

 

[oharab]

What you need to do is loop through the tables & find the connected ones, then change the connection string of that table to include the password. You will then have to then unset it when you are finished.
There is some code at

http://www.mvps.org/access/tables/tbl0009.htm

which will give you a start, you will need to change it to include your username and password string.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------