Database deployment/network/security question 1

[nedstar1]

Hi friends,

With scads of assistance from the good people here on Tek-Tips, my db is ready for prime time! I've spent the first part of today working out the users and permissions, and that is now set up.

The next step is a bit more complicated for me. I need to provide multi-user access to the DB.

My first step was to create a shortcut using the UNC location of the DB. When I double click it, Access runs and opens my dashboard - before it prompts for the username and password.

When I created the security (using the wizard), it generated an MS Access Workgroup Information file. I'm guessing this is the issue, but I could use the sage advice of someone who has done it before.

I'm heading back to my help files and books to try to find the solution. Any assistance is welcome and appreciated.

TIA

Regards,
Nedstar1

 

[nedstar1]

I forgot to mention - when I open the DB, I can't do anything at all - can't click on any dashboard buttons, etc. I'm locked out. DB is hosted on a WinXP Pro PC and I'm trying to run it over ethernet from a Win2K laptop.

TIA

Regards.
Nedstar1

 

[PHV]

In the shortcut properties you must have something like this:
\path\to\msaccess.exe \path\to\database.mdb /wrkgrp \path\to\file.mdw

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nedstar1]

PHV to the rescue again - I was trying to understand my book's explanation of this very step - you did it better. You should write one too.

Thanks a bunch for the reply. A star for your trouble.

Regards,
Nedstar1