Prev: Can I split Office Prof 2003 Apps between Computers & put Access on seperate PC?
Next: MichaelDonline
From: Steve Woodward on 17 Jan 2010 22:09 I am trying to migrate membership data from a local Access table to MySQL on the web. I installed ODBC and set up the DSN and was able to export my local data directly to MySQL (*way* cool!). Queries and reports run great, but using a form to access a single record takes forever. When in the form, I click on the member number fiield (which is the key of the record) and then click on "find" to get to the record I want. There are about 4500 records. If I choose one towards the end of the file it takes more than a minute to return that record. What should I be looking at? Thanks, ~Steve |