Skip third party login screen

[code_hungry]

To whom it may concern. I am putting together some simple Access 2003
databases at work and I am linking several tables to the accounting software
MAS90. everytime I open a MAS 90 linked table, I have to type my network
login id, but not my password.

I want other users to be able to simply open the Access database and not
have to log on. Is there a way to do that?

 

[Brian]

This is actually more of a MAS90/ProvideX ODBC question than Access, but as
it happens, I have done several of these with MAS90. The trick is configuring
the ODBC driver. First, you have to add a new DSN for MAS90 using the MAS90
ODBC Driver. I always do it as a System DSN so that it functions for any user
of the computer. Then, you configure it thus:

On the Logon tab, enter the company code, User ID & password.
On the Options tab, ensure that Silent mode is checked.

These are just the two options relating to bypassing the logon; there are,
of course, other options relating to data paths, but these will likely be set
by default when you create the DSN. Remember that saving the password with
the DSN will save it in clear test in odbc.ini file, which could (but
probably won't) pose a security risk (since most, if not all, your users have
no idea that the password is there or how to find or read the file). Also
remember that this sets one user ID & password for everyone using the ODBC
connection; it does not use the current user's ID/password.

 

[code_hungry]

Brian,

Thank you sooooooooooooooooooooooooooooo much. MAJOR Mile stone for my work.
I owe you icecream.

 

[Brian]

You are very welcome. Because ProvideX is a file-based database (not a true
client-server), you may find that MAS90 ODBC-based data connections run much
faster locally on the server, where there is no network between the DSN (your
application) & MAS90.

I actually use the saved password DSN for some automated processes I
designed in Access 2003. I have a process that extracts data from MAS90,
saves it as a CSV file, and then FTP's it to a client. That program also
polls a local folder for a parameter file (pre-defined format including
paramters the user wants for a report, and the user's e-mail address). When a
parameter file appears, it exports the required data to a shared folder, then
e-mails a notice to the user indicating that the data is ready.