MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 5: MS Access Modules & Macros
Save & Exit Visual Basic window
1. Once you have written all the code and
updated the account (login/password) information, make sure to save the
module by clicking the save icon on the tool bar as shown in the
screenshot above.
2. Finally exit out of Microsoft Visual Basic code window.
The sole purpose of creating this module is to have auto-login ability
to Oracle database via MS Access. If you don’t have this functionality
in MS Access database then every time you open the MS Access instance,
you would be prompted to login to Oracle Database Server provided you
have linked Oracle tables in your MS Access database.
The story is not complete yet at this point. We have just prepared the
code which will give MS Access the ability to communicate account
credential (Username/Password) with Oracle. In MS Access Macro section
i.e. the next one of this chapter; we will learn how to make this module
auto executable whenever we open the MS Access database instance.
Chapter 5: MS Access Modules & Macros
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: