Access with MySQL + SQL Server

  • Thread starter Thread starter Edward Hass
  • Start date Start date
E

Edward Hass

I'm not an Access user, so please forgive my ignorance.

Can Access be used to join tables in two different database architectures?

Specifically, I have a table in a MySQL database and another in Microsoft
SQL Server. I'd like to do a join on these tables to create a report.

Can Access's link to external tables be used to create such a join?

Thanks,
Ed Hass
 
Edward Hass said:
I'm not an Access user, so please forgive my ignorance.

Can Access be used to join tables in two different database architectures?

Specifically, I have a table in a MySQL database and another in Microsoft
SQL Server. I'd like to do a join on these tables to create a report.

Can Access's link to external tables be used to create such a join?
Click to expand...

You can sure can do the above. This one cool reason why we like access.
However, as Rick pointed out, it often cause performance issues as the join
has to be done "locally".

If performance issues arise, and if possible, I would use two make table
quires and pull the data from both tables to a temp mdb file..and then do
the join on that. If you doing a complex report on the data, then pulling
both tables local will make the report run MUCH faster. You also want to
consider using an external linked mdb file if you decide to pull the data to
your local machine (since pulling data to a table and deleting it will cause
a lot of bloat if the tables are in the same mdb as your query/report).
 
Thank you for your replies. It looks like Access will help me out here.
This is a query that will be run only once a month, so performance won't be
a major issue.

Thanks,
Ed Hass
 
Back
Top