S
Steve Schapel
Anyone with more experience than me can suggest what might be happening
here?
I have an Access 2000 app which links via ODBC to a MySQL database on a
web server. The ODBC connection itself tests ok, and it is obviously
connecting from within the app, as there are remote tables that are
getting deleted and renamed successfully. But the part of the process
where data is supposed to get uploaded (DoCmd.TransferDatabase) to the
MySQL database just isn't happening. No error is being raised. It used
to work ok, and it still works ok from my computer. Also, when you go
to File|Get External Data, and try to connect to the data source, it
used to show you the tables in the remote database, but no longer does
so (the Import Objects or Link Tables dialog just doesn't happen). This
has been the result of a change from Windows 2000 Server to Windows
Server 2003, but the system admin guy can't find any explanation. Where
should I start looking?
here?
I have an Access 2000 app which links via ODBC to a MySQL database on a
web server. The ODBC connection itself tests ok, and it is obviously
connecting from within the app, as there are remote tables that are
getting deleted and renamed successfully. But the part of the process
where data is supposed to get uploaded (DoCmd.TransferDatabase) to the
MySQL database just isn't happening. No error is being raised. It used
to work ok, and it still works ok from my computer. Also, when you go
to File|Get External Data, and try to connect to the data source, it
used to show you the tables in the remote database, but no longer does
so (the Import Objects or Link Tables dialog just doesn't happen). This
has been the result of a change from Windows 2000 Server to Windows
Server 2003, but the system admin guy can't find any explanation. Where
should I start looking?