I have a Microsoft Access Database and I need to do two things with it. It only has a few hundred entries in it.
1. Export the entire database to a single html file that is easily styled through css. I need to be able to update the database in access and then export it to html and then formatting needs to keep working. It needs to be a single html file, for some reason I can't export to a single html file, only multiple ones with pagination.
2. Export the entire database to a mysql database that when exported automatically updates all the tables on the mysql database that I have on a linux server with media temple. I don't really care how this gets done, even if access does this already, I just don't know how to do it and would like for there to be written documentation for access 2007 on how to do this so we can do it ourselves whenever the database is updated.
Use access to login to the web server and manage the mysql tables from access so it just gets edited live.
Basically what I need to do is make this easier for this database to be online and use mysql to do it. I don't have a clue how to do any of it, so I'm open to suggestions as well. A conversation might be in order so when you bid you can explain to me what will be done and I can see if that would work.