Why not just run Gallery in the MySQL server alongside Zen-Cart? It's built for MySQL by default anyway.

If you have to run in Access for some reason (and it better be a darn good one), that's fine. But my point in asking is why try to solve a problem that you don't have to face in the first place?