B
brba
I wrote a database for our use with both front and back ends in Access. One
of the features of this database is linking to an outside database and
copying some data from theirs to mine every morning. This vendor database
used FoxPro tables, so I created a link in my Access database to the FoxPro
data files. I wrote a VBA program that opens the FoxPro recordset, finds the
matching records between the two tables (FoxPro and Access) and copies the
data from 4 fields.
The vendor recently upgrade their database to MySQL. Using the supplied
driver, I was able to link the MySQL tables into my Access database, but the
copying is running much slower.
So my question is basically, am I doing the right thing by using Linked
tables? Or is there another way that I should be using to access the MySQL
database? i always thought that with MySQL, things would be running faster,
not slower.
of the features of this database is linking to an outside database and
copying some data from theirs to mine every morning. This vendor database
used FoxPro tables, so I created a link in my Access database to the FoxPro
data files. I wrote a VBA program that opens the FoxPro recordset, finds the
matching records between the two tables (FoxPro and Access) and copies the
data from 4 fields.
The vendor recently upgrade their database to MySQL. Using the supplied
driver, I was able to link the MySQL tables into my Access database, but the
copying is running much slower.
So my question is basically, am I doing the right thing by using Linked
tables? Or is there another way that I should be using to access the MySQL
database? i always thought that with MySQL, things would be running faster,
not slower.