Hello,
I am working on an MS Access 2010 database. I need to put the backend of the database on a web server, but apparently it is not possible to connect an MS Access frontend to an MS Access backend on a web server, so I exported the backend tables to a mysql database on the webserver. I was able then to create a dsn and link the tables to the Access frontend.
PROBLEM: The linked tables do not have the same attributes as the tables in the Mysql backend. Required fields are not marked required in the linked tables, and unique indexes are also missing.
I really need to use composite (multi-column) keys for processing, so the missing attributes are a shot in the heart.
HELP!