I know that its possible to view MySQL tables using M$ Access, but is it possible to add/remove/edit tables using access, or can you only link to them to view?
not to go off topic or anything...but you can open MySQL tables in Access??!
Sure, use MyODBC available on the mysql.com site, install it on your Windows box, make a MySQL-connection in the Control Panel/ODBC Sources and voila, you can connect to MySQL with any ODBC-client on that box, including Access.