export/linking for access 95 and MySQL

[doddo]

Hi, I have an access95 DB on a client that I need to link to MySQL to make the data available to a larger audience. This has a number of forms for data entry. When I remove the table and replace it with a link to one on the MySQL DB (which has the same name) the form claims that it cannot find the table. All i have done is move the table onto the MySQL db and create a link to it using ODBC. Does anyone know why this would be?

Also, as an alternative I have tried to export tables directly from the Access db to the Mysql using ODBC. In this case I get a message to the effect:

[TCX][Myodbc] Unknown table 'tablename' (#1051)

It works on every other machine with other databases. I have given this machine access and it will link tables. The only thing on this machine that is different is that you have to log on to access to use it (the db is also replicated). could this be our problem?

any help greatly appreciated
cheers

 

[AshleyRickards]

When you link tables via ODBC to SQL the table will include the owner name. Such as DBO.TABLENAME. If your query in underlying record source then you'll need to modify the query to include the dbo. etc.. Ashley L Rickards
SQL DBA