Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our POE scripts. All of our scripts for Dynamics GP can be found here
POE Scripts
 
No records to display.
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