468,470 Members | 1,651 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,470 developers. It's quick & easy.

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

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
0 873

Post your reply

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

Similar topics

4 posts views Thread by Dave Moore | last post: by
7 posts views Thread by Jim Lawton | last post: by
2 posts views Thread by ameshkin | last post: by
6 posts views Thread by Bob Sanderson | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.