Thanks for that and all your prevous help. The database needs to be local, to
limit the input to just one authorised user at one site. I shall try your
latest advice.

"Andreas" wrote:

Create a folder in your "C:" drive.
Call it "Database" (without the quotes).
Copy the database (.mdb) into that folder.
Copy the workgroup (.mdw) into that folder.

Create a shortcut as follows:
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\Database\YourDatabaseName.mdb" /WRKGRP
"C:\Database\YourWorkgroupName.mdw"

Ensure the workgroup file is the one the wizard created and not the
original one. Ensure you type the above with the quotes as shown without
pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in
the directory as per above - if not, modify the path appropriately.

If this doesn't work, I am out of ideas.
You can make Access look at the workgroup file permanently but then you
will have issues with any other databases that may be in use or created
later, therefore I won't go there.

As far as security is concerned, this is a whole discussion in it's own
right.

My main concern at this point is that if you are going to have multiple
users and the database is not on the server, and anyone makes changes,
the others will not be able to see those changes as everyone has their
own local copy, which is not shared.

Regards,
Andreas


cel504 wrote:
Sorry, Andreas, I have done exactly as you described and it's to no avail. I
even tried to move the file location to another part of my computer to try
it, ie from Desk top to my documents and retype the code on the short cut.
The error is always it can't locate the database. Is this the best way to
secure a database by the way, or am I missing a trick somewhere. I don't want
to put this on a public drive server, but just limit it to a few Desk Top
users.



"Andreas" wrote:


The parts you are specifying a
Program Database /switch Workgroup

So, the first part is the location of the Access program:
Example: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe"

The second part is the location of your database:
Example: "C:\My Documents\Databases\Database.mdb"

The third part is the switch, which allows you to specify your workgroup
file: /WRKGRP

The fourth part is the location of your workgroup file:
Example: "C:\My Documents\Databases\Workgroups\Workgroup.mdw"

You need to supply each example above as written (including quotation
marks), with a space between each argument (for readability anyway),
substituting the directory and file names as appropriate.


Regards,
Andreas


cel504 wrote:

Andreas,

Sorry to be a pain, but does the rest of the code stay the same, as in
test\supplier, test\ secure or does that have to be substituted by another
code.

What is actuallly happening with the code and sequence.

Thanks again.

"Andreas" wrote:



Probably the wrong group, there is a group dedicated to security.

If the shortcut can't find the program, then you need to change the part
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" to reflect the
location of MSACCESS.exe. Use Windows Explorer or Start.Find to locate
the file.

Regards,
Andreas


cel504 wrote:


Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:




Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:




If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:



I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:





Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON