Microsoft Access 2010 LoginDB to Open FrontEndDB

  • Status Completed
  • Budget $30 - $250 AUD
  • Total Bids 3

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 “[url removed, login to view]”.

User enters username & password. Routine authenticates password by DAO recordset to “[url removed, login to view]”.

If authentication = true, returns UserPermissions.

UserPermission can be [READ / FULL / ADMIN / OWNER]

MyUserDetails = UserName ; UserPermissions. Split() to delimit at later stage.


1. Open [url removed, login to view] from LoginDB.accde.

2. Pass through UserPermission & Username to [url removed, login to view]

3. Open [[url removed, login to view]] with OpenArgs = UserPermission & Username

4. Maximise [url removed, login to view]

5. Allow for frmMain to open normal size.

6. Close [url removed, login to view]


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")

[url removed, login to view] = True

[url removed, login to view] acCmdAppMaximize

[url removed, login to view] "frmMain", , , , , , MyUserDetails 'sends permissions as an open arg

Future work with tidying up much of my database solution.


Get free quotes for a project like this
Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online