Microsoft Access Database requires user level security .MDW specified - how do you do this?

Microsoft Access Database requires user level security .MDW specified - how
do you do this when using Crystal Enterprise v9? (or how can you remove the
need for a password)?

"We have a Microsoft Access Database (register32.mdb) that requires user
level security. All user id and password information is stored in a
Microsoft Access Workgroup Information file. In this case, the file is
ff4sys.mdw

I used the Crystal Ent. report publishing wizard and all went through ok,
however we are
unable to run the report.

Need to have instruction on where we specify how Crystal Enterprise Standard
v9.0 is to find and use the mdw file (tried to specify within the Crystal
Management Console - under the report settings but to no avail.)"

Thanks in advance
Rick

Generally, I advise people to not use Crystal because the Access report
generator is just as good, if not better. However, if you need to use it,
then you will need to add some switches to your connection string to specify
the workgroup and the username and password. I can't tell you the syntax for
doing that in Crystal, but the switches a

/wrkgrp "FullPathToWorkgroup.mdw"
/user "UserName"
/pwd "Password"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Rick" wrote in message
...
Microsoft Access Database requires user level security .MDW specified -
how
do you do this when using Crystal Enterprise v9? (or how can you remove
the
need for a password)?

"We have a Microsoft Access Database (register32.mdb) that requires user
level security. All user id and password information is stored in a
Microsoft Access Workgroup Information file. In this case, the file is
ff4sys.mdw

I used the Crystal Ent. report publishing wizard and all went through ok,
however we are
unable to run the report.

Need to have instruction on where we specify how Crystal Enterprise
Standard
v9.0 is to find and use the mdw file (tried to specify within the Crystal
Management Console - under the report settings but to no avail.)"

Thanks in advance
Rick

Thanks Lynn - We currently use the command line parameters to do exactly as
you explain. Crystal is required due to other SQL systems replacing the
Access database - but there is a protracted period where we still need to
use the legacy system.

Crystal Enterprise does have an area to specify the userID password and
location of MDB file - however it does not work (in my experience).

"Rick" wrote in message
...
Microsoft Access Database requires user level security .MDW specified -
how
do you do this when using Crystal Enterprise v9? (or how can you remove
the
need for a password)?

"We have a Microsoft Access Database (register32.mdb) that requires user
level security. All user id and password information is stored in a
Microsoft Access Workgroup Information file. In this case, the file is
ff4sys.mdw

I used the Crystal Ent. report publishing wizard and all went through ok,
however we are
unable to run the report.

Need to have instruction on where we specify how Crystal Enterprise
Standard
v9.0 is to find and use the mdw file (tried to specify within the Crystal
Management Console - under the report settings but to no avail.)"

Thanks in advance
Rick

Thanks Lynn - We currently use the command line parameters to do exactly as
you explain. Crystal is required due to other SQL systems replacing the
Access database - but there is a protracted period where we still need to
use the legacy system.

Crystal Enterprise does have an area to specify the userID password and
location of MDB file - however it does not work (in my experience).

"Rick" wrote in message
...
Microsoft Access Database requires user level security .MDW specified -
how
do you do this when using Crystal Enterprise v9? (or how can you remove
the
need for a password)?

"We have a Microsoft Access Database (register32.mdb) that requires user
level security. All user id and password information is stored in a
Microsoft Access Workgroup Information file. In this case, the file is
ff4sys.mdw

I used the Crystal Ent. report publishing wizard and all went through ok,
however we are
unable to run the report.

Need to have instruction on where we specify how Crystal Enterprise
Standard
v9.0 is to find and use the mdw file (tried to specify within the Crystal
Management Console - under the report settings but to no avail.)"

Thanks in advance
Rick