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
Project Budget$30 - $250 AUD
Completed In1 day
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online