Roly Reefer
Registered User.
- Local time
- Today, 02:27
- Joined
- Jan 28, 2005
- Messages
- 37
Hi,
I have setup a new database that accesses an ODBC database which requires a username and password. Because the database is for basic level users, we do not want them to know the password.
The database can be programmed to use the password in the background, but having very very basic indeed VBA skills, I do not know where to place the code. I have discovered from the Help files that you can use the DefaultUSer and DefaultPassword, but this does not mention a server (on which the database is stored) and whereabouts in the form's code that I should write the script (for example, General, Declarations). I did try anyway, but it did not work - I don't really know if this is the correct property anyway!!
Can anybody help me on this one, please? I will be really grateful if you can.
All the best,
Roly
I have setup a new database that accesses an ODBC database which requires a username and password. Because the database is for basic level users, we do not want them to know the password.
The database can be programmed to use the password in the background, but having very very basic indeed VBA skills, I do not know where to place the code. I have discovered from the Help files that you can use the DefaultUSer and DefaultPassword, but this does not mention a server (on which the database is stored) and whereabouts in the form's code that I should write the script (for example, General, Declarations). I did try anyway, but it did not work - I don't really know if this is the correct property anyway!!
Can anybody help me on this one, please? I will be really grateful if you can.
All the best,
Roly
