Converting a Database without Permission

[Guest]

I have a database - originally programmed in Access 97 by someone that has
now left my organisation. I have now been upgraded to XP and now the database
will not open.
I get a message saying 'The current user acount doesn't have permission to
convert or enable this database'.
Obvisouly the database is trying to convert itself to Access 2002.
As the original person has now left I cannot add myself to workgroup, or
change myself to the administrator (I don't think anyway?)
I've tried Importing the data/tables etc to a new database - but its so
complicated that doesn't work (and I don't have the expertise to fix).
Is there anyway to get around this problem - either by forcing the database
to convert - or adding myself as an administrator..??

Thanks for any help.

Phil

 

[Joseph Meehan]

I have a database - originally programmed in Access 97 by someone that has
now left my organisation. I have now been upgraded to XP and now the
database
will not open.
I get a message saying 'The current user acount doesn't have permission to
convert or enable this database'.
Obvisouly the database is trying to convert itself to Access 2002.
As the original person has now left I cannot add myself to workgroup, or
change myself to the administrator (I don't think anyway?)
I've tried Importing the data/tables etc to a new database - but its so
complicated that doesn't work (and I don't have the expertise to fix).
Is there anyway to get around this problem - either by forcing the
database
to convert - or adding myself as an administrator..??

Thanks for any help.

Phil

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

I suspect you are not going to have much luck unless you have the
password for the administrator for Access security.

Hopefully you will be able to copy - import the data into a new
database.

If you would like help with copying the data, I suggest starting a new
thread for that issue and give as much information about that situation as
possible, explaining your difficulties.

This does bring up an not uncommon issue with secured databases. It is
extremely important that there always be at least two people with written
documentation on the security and with full access to the database. When I
retired I left with three different people having full information and
administrative access, one management person and one tech person from each
business unit. I suggest everyone do the same and remember that it needs to
be an ongoing thing and reviewed or a regular schedule. Unexpected things
happen, we don't all get to retire.

 

[Guest]

Thanks for the help - Its much apprieciated.

I have a database - originally programmed in Access 97 by someone that has
now left my organisation. I have now been upgraded to XP and now the
database
will not open.
I get a message saying 'The current user acount doesn't have permission to
convert or enable this database'.
Obvisouly the database is trying to convert itself to Access 2002.
As the original person has now left I cannot add myself to workgroup, or
change myself to the administrator (I don't think anyway?)
I've tried Importing the data/tables etc to a new database - but its so
complicated that doesn't work (and I don't have the expertise to fix).
Is there anyway to get around this problem - either by forcing the
database
to convert - or adding myself as an administrator..??

Thanks for any help.

Phil

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

I suspect you are not going to have much luck unless you have the
password for the administrator for Access security.

Hopefully you will be able to copy - import the data into a new
database.

If you would like help with copying the data, I suggest starting a new
thread for that issue and give as much information about that situation as
possible, explaining your difficulties.

This does bring up an not uncommon issue with secured databases. It is
extremely important that there always be at least two people with written
documentation on the security and with full access to the database. When I
retired I left with three different people having full information and
administrative access, one management person and one tech person from each
business unit. I suggest everyone do the same and remember that it needs to
be an ongoing thing and reviewed or a regular schedule. Unexpected things
happen, we don't all get to retire.

 

[Guest]

I think I now see why you made the Access Security Reminder post. ;-)

Also Access security is so complicated that it often isn't implemented
properly leaving some back doors. Possibly the previous owner of the database
didn't remove permissions from Admin.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a database - originally programmed in Access 97 by someone that has
now left my organisation. I have now been upgraded to XP and now the
database
will not open.
I get a message saying 'The current user acount doesn't have permission to
convert or enable this database'.
Obvisouly the database is trying to convert itself to Access 2002.
As the original person has now left I cannot add myself to workgroup, or
change myself to the administrator (I don't think anyway?)
I've tried Importing the data/tables etc to a new database - but its so
complicated that doesn't work (and I don't have the expertise to fix).
Is there anyway to get around this problem - either by forcing the
database
to convert - or adding myself as an administrator..??

Thanks for any help.

Phil

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

I suspect you are not going to have much luck unless you have the
password for the administrator for Access security.

Hopefully you will be able to copy - import the data into a new
database.

If you would like help with copying the data, I suggest starting a new
thread for that issue and give as much information about that situation as
possible, explaining your difficulties.

This does bring up an not uncommon issue with secured databases. It is
extremely important that there always be at least two people with written
documentation on the security and with full access to the database. When I
retired I left with three different people having full information and
administrative access, one management person and one tech person from each
business unit. I suggest everyone do the same and remember that it needs to
be an ongoing thing and reviewed or a regular schedule. Unexpected things
happen, we don't all get to retire.