Re: Migration and authorisations

John wrote:
Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If the users try to open the mdb they get the message (translated from Dutch):

"you do not have the correct authorisations for the use of object 'G:\... \OurFileName.mdb '. Contact you system manager or the person who has made the object, to establish the correct authorisations for you."

We suspect that there is hard path reference in the mdb that points to the old location of
the mdw (with the old drive's name). I have never worked with 'authorisations' or working grouops and the builder of this application is gone and can not be reached.

Does anyone have an idea on how we can get the mdb to run again? Even if we would lose the whole autorisation and workgroup functionality in this mdb, that would be better than nothing being able to access the mdb at all.

Temporarily moving back to the old network drive is not an option.

Thanks in advance,
john


Either way you still have to know how to access the security settings. You did not mention the database and version or anything like that so you are probably not going to get much usable help. A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.

My suggestion is hire a consultant that knows the database and/or application or some kind of professional outfit that can make some suggestions or help you to accomplish what you want to do. It may save you money and time in the long run. You dont want to find out months from now that you are going to have redo your conversion because you have missing writes to the table and corrupt data.
.