By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Using MS Access as front end for MySQL Database -- is it possible to tune & speed per

P: 1
Our company uses a nifty MySQL database to import/store data that is FTP'd to us. It runs QUICKLY to import the data (like... nanoseconds)!

However, being a slightly more advanced than a beginner, I've been told "don't touch!" and build queries in MS Access (Office 2010) using ODBC.

This works, but at times the queries seem to crank on endlessly. I get an Access (not responding) in the title bar and see no progress on the status bar... just SITS. Then starts again or I need to start it again (not sure)

I can't tell if I have a network issue, an Access issue or something completely different.

Normally, I'd start with Access tuning, but I'm concerned about indices in MySQL... can I mess anything up?

Anybody have suggestions?
Oct 25 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.