Security issues

[Denise]

Here was the response to my original question below.... I
never placed any password or did anything to secure this
database...I saved it in 97 format because there are still
some users who have old PCs. I just don't know how to get
the program to recognize that I am the Administrator.

Any clue?

Denise


The save process in 2000 is different than in 97 ... in
2000, you MUST have
exclusive access to the database in order to make and save
changes. In 97,
you could work on objects while others were banging away
at the db ... not
so in 2000.

RE: security - are you receiving a logon prompt, or do you
have to enter a
password to get into the database?

message
news:[email protected]...

 

[Van T. Dinh]

You cannot use A2K software to modify / change the *design* of a database in
A97 file format. You need to use A97 to change the design of a database in
A97 file format.

OTOH, you really should (must, really) split the database for a multi-user
application. The Back-End contains only Tables and resides on a shared
network drive. In your case, the Back-End should stay with A97 file format.
The Front-End contains all other Access Objects and each user should have a
copy on his / her Desktop. In your case, you can use 2 versions of the
Front-End, 1 in A97 file format and 1 in A2K file format and distribute the
appropriate version to each user depending on the Access version he / she
has.

Check Access Help on splitting a database.

HTH
Van T. Dinh
MVP (Access)