Hi everyone,

I'm designing an inventory application with Access 2002, and i'm realizing that it might be better to do this the client/server way since there will be more than one user at a time, and because the company's web hosting allows up to 10 MySQL dbs and they're not using any so far.

However, i've never developped anything like this, and i'm looking for a bit of advice from the gurus here.

What should i look for?

Anything i should keep in mind when it comes to my VBA code?

I was thinking about only having the table in the MySQL db, and all the reports, forms and queries on the client computers. Is this the best way to go?