Completed

Microsoft Access 2010 LoginDB to Open FrontEndDB

This project was successfully completed by winghei for $80 AUD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 AUD
Completed In
1 day
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.

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

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

Regards,

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