Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our UPR scripts. All of our scripts for Dynamics GP can be found here
steve gray 8/9/2011 7:21:55 AM

Code to loop through the querydefs collection in Access

 Recently I was migrating some tables to SQL from an old Access database. The original programmer had put spaces and other punctuation in the field names that SQL didn't allow so I changed them, but that broke Access when I linked the table back. This code will loop through the querydef collection and find all instances of a table name or field name.

 

Version: Unknown or N/A
Section: Microsoft Access


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3