Excell Queries from ODBC driver

[Eddie]

Every time I do a query from a database the system forces
me to input my user name and password to the software
that I'm extracting the info from. Is there a way to
turn this off? (VBA??)
thx
Eddie

 

[Frank Kabel]

Hi
this is probably a good idea
Of course you could automate this within VBA but this is in my opinion
a security issue!

 

[Guest]

Frank,
Not too concerned about the security issue, I will be the
only one using the macro to create a certain report. So
you have good ideas of some VBA magic that could help me
out? Would it be like protecting and unprotecting a
sheet? I've done that before, but this is asking for 3
different input variables. It ask for them 3 times for
one query, very announying..

 

[Jamie Collins]

So you have good ideas of some VBA magic that could help me
out? Would it be like protecting and unprotecting a
sheet? I've done that before, but this is asking for 3
different input variables. It ask for them 3 times for
one query, very announying..

I think you need to post some details. How are you accessing the
database e.g. MS Query? How do you connect e.g. DSN, connection string
(can can't the UID and password be specified here)? Are you using an
intermediate Jet database to access the actual database (if so, can
you connect to the actual database instead?)

Jamie.

--

 

[Eddie]

The query is coming out of my Mas 90 software:
I go to excel, data, import external data, new database
query.
Then I chose SOTAMAS90 as my data source, then ok.
this then jumps me into the query wizard, after inputting
the user code and password..
this is about all the details I know, sorry..

 

[Jamie Collins]

The query is coming out of my Mas 90 software:
I go to excel, data, import external data, new database
query.
Then I chose SOTAMAS90 as my data source, then ok.
this then jumps me into the query wizard, after inputting
the user code and password..
this is about all the details I know, sorry..

I wonder, then, if you are able to create a DSN with the logon details
i.e. Control Panel, Administrative Tools, Data Sources (ODBC), User
DSN, choose the driver from the list, hit Configure and in the
resulting dialog have a look around for somewhere to specify the user
ID and password. If you can create a DSN, it will subsequently appear
in the list of 'Databases' when you create a new database query in
Excel.

Jamie.

--