Microsoft Access 2010 LoginDB to Open FrontEndDB

IN PROGRESS
Bids
3
Avg Bid (AUD)
N/A
Project Budget (AUD)
$30 - $250

Project Description:
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.

CODING REQUIRED:
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

IMPORTANT:
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.RunCommand acCmdAppMaximize
objAccess.DoCmd.OpenForm "frmMain", , , , , , MyUserDetails 'sends permissions as an open arg

Future work with tidying up much of my database solution.

Regards,

Skills required:
Microsoft Access, Software Architecture, Visual Basic
Hire SherpaSolutions
Project posted by:
SherpaSolutions Australia
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.