I'm looking for direction and wisdom from the individuals that have been where I am. I have two split DB's each used by individuals around the country, the front ends are on the users computers but the back ends are hosted on our shared drive. When there was minimal usage this worked, but as more users are using it things are getting slowed down and I think my next move probably needs to be to transition to a Oricle backend, but I need direction. I say Oricle because my company has a Oricle server but I will have go thru a long process to apply for its use. When that time comes I would like my databases and my knowledge to be ready, so here's my questions-
1. Are there any online courses for working a access database with a Oricle?
2. Is there such a thing as a "Test environment" that I could use to start checking my database for compatibility?
3. Are there any rookie mistakes that you can pass on so I hopefully wont make them.
I'm sure there are many other questions but mainly how do I get my databases, code and self ready to go to a server.