|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 26th, 2002, 12:42 PM
|
#1 |
|
Board Regular
Join Date: Feb 2002
Posts: 217
|
I'm using MS Query to connect to an ODBC database (MAS90 for those who might know what this is) and I would like to know if I can program my macro to pass along the company, userid and password to the ODBC login so I don't have to enter this info everytime I want to run the app.
[ This Message was edited by: 2077delta on 2002-03-26 11:42 ] |
|
|
|
Mar 26th, 2002, 01:01 PM
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Hi
You should be able to simply edit your connection string and then remove the prompt or login dialog? Tom [ This Message was edited by: TsTom on 2002-03-26 12:02 ] |
|
|
|
|
Mar 26th, 2002, 01:32 PM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Looks like the post i made has GONE!
ermmmm
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Mar 26th, 2002, 01:40 PM
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Sorry that last post went ????
Poss linked incorrectly OK MAS90 is SAGE yes so will be cool in ODBC If ODBC is new drivers then login once will allow repeat access via ODBC on network without re enter PW. IF not speak with Administrater as poss old drivers in use or the way licence is set up. i couild be that must login each time. I recall the Script will allow for auto enter PW as refresh takes place. Does this help... BTW Of cause if needs by Sage helpLine will solve this and will be a part of the maintaince service package you have bought as MAS90 is current... Sage helpline is really very good in UK or so i have found, should be price yopu pay for software and stationary is aweful!
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Mar 26th, 2002, 01:40 PM
|
#5 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Sorry that last post went ????
Poss linked incorrectly OK MAS90 is SAGE yes so will be cool in ODBC If ODBC is new drivers then login once will allow repeat access via ODBC on network without re enter PW. IF not speak with Administrater as poss old drivers in use or the way licence is set up. i couild be that must login each time. I recall the Script will allow for auto enter PW as refresh takes place. Does this help... BTW Of cause if needs by Sage helpLine will solve this and will be a part of the maintaince service package you have bought as MAS90 is current... Sage helpline is really very good in UK or so i have found, should be price yopu pay for software and stationary is aweful!
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
