I have an Access 2010 database on a server. Right now the Access database is not split into a FE and BE. I put a shortcut directly to the database on each user's desktop. My question is, what would be the most efficient way to have them all use it?
1. Keep it as is
2. Split the database on the server into a FE and BE and connect them to the FE via a shortcut
3. Split the database on the server into a FE and BE and put a local copy of the FE on each of their machines
The forms in this database are loaded with code. Nothing super advanced but boatloads of code.
I am not sure which way would cause the least delay and bottlenecks.