Access 03 to Access 13 migration

[JohnPapa]

Welcome back Rainlover,

Just to reiterate, the goal is to convert a A2003 FE.mdb(or FE.mde),BE.mdb, mdw file to a FE.accdb(or FE.accde),BE.accdb. The reason is not the inadequacy of A2003 but the fact that Microsoft has released 3 more versions of Access and they want to "encourage" people to use the latest versions so that they make more money.

I have said it before but I do not believe that the security was set up fully in the first place. If Admin was still the owner then it was not set up correctly. In fact I believe Admin should have been removed completly. I would need to research that to be 100% sure.This really does not matter if things are correct now.

The security was set up correctly initially with Admin disabled. That is why I said to enable Admin again, before conversion to A2013. Unless I am mistaken your test deals with A2003. The goal is A2013. If one follows the steps I outlined (especially the one of copying all db objects to a blank db) the ULS is gone.

If I missed something please point out.

Thanks,
John

 

[RainLover]

You can't convert the .mde or the .mdw.

You can convert the .mdb to a point where the ULS is removed. Based on what you are telling me you have been successful in this regard.

From a .mdb without ULS you should then be able to convert to any other version. Bear in mind you may have conflicts in the code but this has nothing to do with the ULS as you have removed it.

I don't believe there is anything else I can add.

Best wishes with the balance of the project. You know where we are if you need help.

 

[JohnPapa]

You can't convert the .mde or the .mdw.

I know. There is no mdw anyway.

I will try converting existing customer dbs and report back if there is any problem. Not a fun task.

 

[RainLover]

You only have to convert the back end if it is secured.

Just replace the front end with the current unsecured version. But you most likely would have worked that out yourself.

 

[JohnPapa]

Are you saying that one can use the FE mde with the converted BE accdb?

 

[RainLover]

Sorry if I confused you.

If the FE is MDB and unsecured then that is what you use.

The Back End must also be unsecured. I say that because some people secure the BE while others do not.

You only have to convert the back end if it is secured.

Just replace the front end with the current unsecured version. But you most likely would have worked that out yourself.

What I am saying here is that you do not have to remove the security from each of the Customer's Front Ends. All you have to do is to override the customer's file with the latest version of the FE, which is unsecured.