Access 97 Security on Network

[MikeAngelastro]

Hi,

I am implementing an Access 97 app over a Win NT 4 server driven network. In order to implement security on the network for this app, do I need to install Access 97 on the network server?

Thanks,

Mike

 

[RichMorrison]

No you don't need to install msaccess.exe on any server. You can install it on every workstation instead.

RichM

 

[MikeAngelastro]

Thanks Rich.

 

[MikeAngelastro]

Hi again,

Now that I know that I don't need Access 97 on the server to use Jet security on the network, I need a little help on how to proceed. We have both the frontend and the backend on the server. The users will have a shortcut on their desktops to the frontend. How do I install Jet security for this app from a client machine so that the mdw resides on the server? I run WRKGADM.EXE but am having difficulty designating the server as the location of the mdw file. I want to go through the network neighborhood ( \\server\ ) so that all the clients don't have to map a server folder to a drive letter.

I have a copy of "Access Security Methods" by Ron and Curt Eastling but it is not exactly clear on this.

Can anyone help me?

Thanks,

Mike

 

[RichMorrison]

You wrote
<<
The users will have a shortcut on their desktops to the frontend. How do I install Jet security for this app from a client machine so that the mdw resides on the server?
>>

You include the name of your System.MDW in the command string of the shortcut.
<<
S:\YourPath\MSACCESS.EXE /wrkgrp S:\YourPath\System.MDW
S:\YourPath\YourApp.MDB
>>
Where "S:\" is some network server mapped to the workstation.

RichM

 

[MikeAngelastro]

Thanks Rich,

I got it set up. My problem was that I needed to log on as the server administrator. I also had to just type in that the mdw path was to be \\server\drive\folder\name.mdw rather than pressing the network button; the network button would only set up a mapped folder as the location of the mdw file.

Basically I followed the instructions in "Access Security Methods" by Ron and Curt Eastling with the variation as above to make sure that the file ended up on the server.

Thanks again.

Mike