Secured 2003 Database conversion to 97

  • Thread starter Thread starter Colm O'Brien
  • Start date Start date
C

Colm O'Brien

After following the guidance of Joan wild and Jack Macdonald in previous
posts I have created a secured database in ms access 2000 format.
Unfortunately now i have been told that the person who will be using it has
only got office97.

If i select tools Database utilities, convert to access97 format it advises
that the new database will contain none of the security information i have
set.

will i have to start and create a new secured workgroup and database owner
and user groups or how will i achieve the same level of security.

admin and users have no permissions at all in the secured database

thanks

colm
 
Unquestionably the safest way (IMO) is to create a new, secured 97 format
workgroup file, create a new 97 format database off that workgroup file,
then import all necessary db objects & start again.

It could be a lot of work, but:

- this approach will ensure you don't get subtle mismatches between the
Admins group in the workgroup file, and what the database >thinks< is the
proper Admins group; and,

- it will prompt you to check what version the user has, when next you write
a database!

HTH,
TC
 
Back
Top