Multiple Countries

[CCIDBMNG]

Right now we have offices in Canada, US, and Australia. We have no problems designing databases in English since each of these countries use English. My question is if we decided to expand to France or Germany would access be able to translate everything if they use a French or German version of access or will we have to design a whole new database in that particular language? Any comment or suggestions would be greatly appreciated.

 

[dcx693]

You should get yourself a copy of Access Cookbook by Ken Getz, Paul Litwin, and Andy Baron. They have a section on this very problem. The only translation issue you need to worry about is when you display your messages on screen. Access will present everything else in whatever language that version of Access if running.

If you want to have Access pick the correct language for you, you need to tell it what language to use. They set up a table of messages, where each field is the same message in a different language. I didn't really look deeply into the solution though.

 

[CCIDBMNG]

Thanks for your reply. A friend just gave me the Access Cookbook so I will look into this. Thanks again.

 

[CCIDBMNG]

Thanks Pat. So I will have to translate that stuff but will my VBA code automatically translate or will I have to do that myself?

 

[CCIDBMNG]

Thanks for your help Pat.