Hi, aspuser25.
I'm in the process of going the other route...Access to MySQL. I decided to redo everything from scratch. Here are some hints:
o No triggers in Access
o Naming conventions are more lenient in Access. For instance, you could name a table "User", then when refering to it with SQL, place the name in square brackets ("SELECT * FROM [User]...")
o My guess is that you'll find that Access is not as robust as MySQL. I often have to deal with database corruptions.
o Compared to other databases I've worked with (SQL Server, Oracle, dBase...) Access has a small learning curve. You shouldn't have too much trouble getting into it.
Good luck!
--mike