devxlogo

Get Object Names Out of Jet Collections and into VB Code

Get Object Names Out of Jet Collections and into VB Code

To maintain sanity, I use long descriptive names for tables and queries in Jet MDB files. This leads to errors when I type these names into VB code. To overcome this problem, I open the MDB using the appropriate version of Access. I then highlight the name I want in its collection.Edit Rename (Access 95) or File Rename (Access 2) brings up a rename window. I highlight the long name and copy it to the Clipboard using the Ctrl-C key combination. Edit Copy won’t take because the rename window is modal. I cancel the rename window and then paste the long name into the VB code.

devx-admin

Share the Post: