How to add system.mdw ? 1

[essnrv]

Hi all,

How can I implement system.mdw authentication to my .mde/.mdb file. For installation, I am using wise installer to distribute final mde file.

Thank you,

 

[MoLaker]

The workgroup used at any given time Access is started it the last workgroup joined - unless the workgroup is specified in a command-line switch when starting Access.

Can you explain what you are doing with the Wise installer just a little more. Are you installing Access run-time files as well as the mde? If so, then include the system.mdw workgroup file with your installation. You could then include a desktop (or start menu) icon with the appropriate command-line to call the workgroup file - but Access should use the system.mdw file by default anyway.

If you are not installing Access run-time files, I assume you know each user must already have Access installed (the same version as your mde). In which case, system.mdw already exists somewhere on the workstation, but not in an entirely predictable location. To be sure, you probably should include the workgroup file with the mde (same directory) so you know where to point the command-line. If this is the direction you take, I highly recommend you rename your system.mdw file (and the command-line pointer) so that is is not confused with the system.mdw that was installed with Access initially.

 

[essnrv]

Thanks MoLaker for your response.

Yes, I am using wise installer just to copy .mde file. Presently, I am modifying existing Access project. Some bosy already implemented system.mdw to this project. Due to unknow reasons(to me) I am not getting any login screen, where as my client is getting login screen sometimes and sometimes not.

Hope you understand the situation.

Thanks

 

[MoLaker]

A logon screen will be presented anytime the user ADMIN has a password. If your client says the logon window occurs only sometimes, he must be switching workgroups somehow. I would think using a desktop or start menu icon with the workgroup included (with full path) in the command-line would solve this problem - as long as the client always uses the icon to access your database.

 

[essnrv]

How can I include a workgroup in the command-line ? ( I am new to this, sorry)

 

[MoLaker]

Do a search for 'startup command' in Access Help. You should find 'Startup command-line options'. Towards the bottom is the switch /wrkgrp workgroup.

The idea is to create a desktop or start menu icon which opens MS Access using a specific workgroup and MDB. So, an icon command-line would look something like

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "c:\myapp\myapp.mdb" /wrkgrp "c:\myapp\system.mdw"

In this case, MS Access would open using c:\myapp\system.mdw workgroup and then open database c:\myapp\myapp.mdb. Notice, the icon does not point directly to the database.

The path I show for system.mdw is the same as the path as the database. This is what I meant by including the system.mdw file in the db directory so you know exactly where it is.

Now, the trick is to get the client to use this icon and not try to open your app by double-clicking the MDB.