Sedang Disiapkan

Microsoft Access 2010 LoginDB to Open FrontEndDB

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.


Kemahiran: Microsoft Access, Kejuruteraan Perisian, Visual Basic

Lihat lebih lanjut: runtime computer, open 2010, dao architecture, computer software coding, coding computer, basic computer coding, 2010 open, microsoft visual, microsoft work, basic shell script, sp1, multiple instance, microsoft , mdb, chr, arg, application microsoft access, access microsoft, 2010 access, runtime, visual basic access application, recordset, access 2010 application, admin access, amp shell script

Tentang Majikan:
( 14 ulasan ) Brisbane, Australia

ID Projek: #1531528