You have chosen to sponsor your bid up to a maximum amount of .
Microsoft Access 2010 Runtime with SP1.
Local copy of "LoginDB.accde" on users computer.
Local copy of "FrontEndDB.accde" on a user’s computer.
Network file of “BackEndDB.mdb”.
User enters username & password. Routine authenticates password by DAO recordset to “BackEndDB.mdb”.
If authentication = true, returns UserPermissions.
UserPermission can be [READ / FULL / ADMIN / OWNER]
MyUserDetails = UserName ; UserPermissions. Split() to delimit at later stage.
1. Open FrontEndDB.accde from LoginDB.accde.
2. Pass through UserPermission & Username to FrontEndDB.accde
3. Open [FrontEndDB.frmMain] with OpenArgs = UserPermission & Username
4. Maximise FrontEndDB.accde
5. Allow for frmMain to open normal size.
6. Close LoginDB.accde
Microsoft Access 2010 Runtime HAS ISSUES with opening multiple instances of Access.
I have used the following Shell script:
Dim x as long
x = Shell(Chr$(34) & strPath & Chr$(34) & " /runtime " & Chr$(34) & FrontEndDBName & Chr$(34))
This opens the FrontEndDB in a new instance of Access and can’t close the LoginDB. It also does not allow for passing variables [that I have worked out!].
NOTE this coding does not work on Runtime Access:
Dim objAccess as Object
Set objAccess = GetObject(MyDBName) ', "Access.Application")
objAccess.Visible = True
objAccess.DoCmd.OpenForm "frmMain", , , , , , MyUserDetails 'sends permissions as an open arg
Future work with tidying up much of my database solution.