I'm hoping this is possible...
I run several MySQL dbs on my webserver for a variety of applicaitons. A variety of people in my office use this info, and will ask for the records in a given DB. In the past, I've always used ODBC to import the MySQL table into Access, then e-mailed them the Access file. This works fine, but can get tedious for me.
Is there a way I can create an MS Access file that is "linked to" the MySQL tables such that the Access DB is updated in real time, showing up to the minute changes to the MySQL DB? I could then share the Access file over the network to allow people to get the records on their own.
Did that make any sense? TIA.
