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 lagi: the open 2010, runtime computer, open.mdb file, open mdb file, open.mdb, open 2010, dao architecture, computer software coding, coding computer, basic computer coding, 2010 open, Microsoft work, microsoft visual, microsoft at work, basic shell script, sp1, open file, multiple instance, microsoft, mdb, computer architecture -- 2, chr, arg, application microsoft access, access microsoft

Tentang Majikan:
( 14 ulasan ) Brisbane, Australia

ID Projek: #1531528