Unanswered: Access Client/ MySQL Server
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?
There are 10 kinds of people, ones that understand digital, others that dont