There are 9 users who access the MS Access database and it has got user access level security applied on it. So everyone has got their user id's and passwords. The problem is now that User's company has decided to give them a remote access connection So they would have Laptops to connect to their server to work on the database.
So If the laptop has got different version of access and Desktops at office would have different versions of access, In such case the code behind the user level security has to work irrespective of the version of access. The user's company IT guy has thought if everyone has to go through the remote access to work on the database irrespective of whether they are in office or at home then we could maintain just one version of access. In this way we do not have to worry about multiple versions of access. please help me whether this is the right way to go or not and let me know if i would face any difficulties in the future , what ever that comes to your mind is helpful. Thank You.