I've written a script which transfers all data in numerous tables to a MySQL database.
When I run this locally it works perfectly. It also works perfectly on the remote database when there are just a few records.
However, the database now has hundreds to thousands of records in each table and this seems to be causing Access to crash (with no error message).
I can see the data has started to upload when I browse the remote database but some of the larger tables result in an Internal Server Error (using PHPMyAdmin).
Does anyone know if there's some kind of transfer limit that could be imposed on a MySQL Server? I have contact the host but he could take a few days to get back to me so I was just wondering if anyone knew anything about this?
Thanks.
When I run this locally it works perfectly. It also works perfectly on the remote database when there are just a few records.
However, the database now has hundreds to thousands of records in each table and this seems to be causing Access to crash (with no error message).
I can see the data has started to upload when I browse the remote database but some of the larger tables result in an Internal Server Error (using PHPMyAdmin).
Does anyone know if there's some kind of transfer limit that could be imposed on a MySQL Server? I have contact the host but he could take a few days to get back to me so I was just wondering if anyone knew anything about this?
Thanks.
