junkmail32
IS-IT--Management
I can not figure out how to configure Access to pull data from the Macola database. I use SQL daily to pull data from Macola into Excel via SQL. I need help figuring out to set up the same in Access.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating link from Access to Progression database
- Thread starter junkmail32
- Start date
- Status
Create an ODBC DSN to the Macola database and create link tables in Access.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
crystalreporting
Instructor
Note that if you're using Macola ES there are some tables you will not be able to link to due to the limit on the number of indexes and columns. You can get around this by creating a view on the table in SQL and linking to the view instead.
Peter Shirley
Macola Consultant, PA and surrounding states.
Peter Shirley
Macola Consultant, PA and surrounding states.
- Status