Removing workgroup security

[Guest]

We recently added workgroup security to our database due to the amount of
people that were using, i.e. to have more control.

Now we realise that it was properly a step too far and has caused other
proplems such as external printers and other software that linked in to our
database.

How do we remove the workgroup security completely, i.e. not be prompted for
user id and passwords etc.

Thanks

 

[Wayne Morgan]

For the other items connecting to the database, you can create a DSN for
them to connect to. The security information can be entered into the DSN.

To remove the security, the easiest way may be to create a new, blank
database and import everything into it. The security won't follow the
import. Remember to open the code editor and do a compile after doing the
import. You may have to set References in the code editor before it will
compile without errors (Tools|References). This will depend on what
References you've used in your database. Just compare the References
settings in the new database to the current one. You will need to do this
for the front-end and the back-end file if the security has been applied to
each of them.