converting access from 32 bit to 64 bit Access 365

[GinaWhipp]

Hmm, that seems strange, the code looks to bring them in. Perhaps you should explain what you mean by lost.

[GinaWhipp]

You need to go click *Go Advanced*

[anjali6]

I managed to get .mde database from one of the user. I tried to export one form to a blank database (.accdb) database. When I tried to export the form, it gave me the error below:



I clicked Ok on this error and then moved ahead to open the VBA file so that i can look at the code. When I tried to do that, I got the below error:



I can attach my .mde database to this forum, but not sure how can I do that. I really need help to convert this database to .accdb and finally to 64 bit.

[CJ_London]

I managed to get .mde database from one of the user.

you cannot use mde, the code is compiled. you need a mdb. Your original post showed a mdb

I was able to remove the replication, but after un-replicating the database, I lost all the forms, queries and Modules.

the advice was to create a new db and import tables/forms etc - so your original should remain unchanged. What did you do?

[isladogs]

MDE files have been compiled which means the code is not available for viewing as you have found out.
It also means that none of the forms/reports/modules can be exported.
That's the whole point of an MDE (and ACCDE) files. They are protected against being edited

You need to go back to the earlier MDB file with replication and obtain the forms etc from there.
You DID keep a backup copy didn't you....

[anjali6]

Hi Ajax,

I un-replicated the database. After un replication, I was asked to save the database, After saving the database, I opened the .mdb file and saw only tables were un-replicated, I didn't see any forms, queries and modules. All the queries, modules and forms were not present in the un-replicated database. I used TSI Access 2000 Un-Replicator by Michael Kaplan to un-replicate the database.

Please advise.

[CJ_London]

You didn't follow the advice given so I cannot suggest anything other than contact Michael Kaplan - however your link states it is unsupported so not sure whether you will get any help. The last update to the whole site appears to be 14 years ago.

The screenshots you provided were for a mde file, now you are saying mdb so I am now confused anyway about what you have actually done.

Follow Colin's advice

[GinaWhipp]

I would suggest using the one posted earlier... https://extramiledata.com/remove-rep...cess-database/

Make sure to follow the steps and use it on a COPY of the database.

[anjali6]

I would suggest using the one posted earlier... https://extramiledata.com/remove-rep...cess-database/

Make sure to follow the steps and use it on a COPY of the database.

Sure, I will follow the steps and will let you know

[anjali6]

I followed step by step instruction to un-replicate the database from the Extra Mile Data article. I created the new database and I created another database for the module. when i ran the function "unReplicate()", I got the below error:




I looked into the comment section of the same article and someone mentioned about this error, but I could not understand the solution. below is the screen shot of all the references that i choose:



Any help will be greatly appreciated.

[CJ_London]

Not sure why you don't just create a new 2000 db (using access 2000), import the tables, queries, forms etc, then remove the replication fields. The amount of time you are spending trying to use 10+year old software intended to be used in much earlier versions of access than 2016. It is not as if you have more than 10 or 12 tables - shouldn't take more that 15 minutes to do.

with regards the error that is showing two tables MSysNavPaneGroupCategories and MSysNavPaneGroups apparently combined into one name. They are tables that did not exist before access 2007

[isladogs]

Just to expand on the error 3012 message, that is telling you that a relationship of that name already exists for the two ACCDB MSysNavPane system tables so it can't be re-created. Have a look in the Relationships window

Agree with Ajax about the best strategy to take in your endeavour. It shouldn't be that difficult to do.

[GinaWhipp]

There was solution posted for that error.

That said, the table does not exist in an .MDB file so I am unclear how you are getting an error that it already exists. Did you upgrade your .MDB?

[anjali6]

Not sure why you don't just create a new 2000 db (using access 2000), import the tables, queries, forms etc, then remove the replication fields. The amount of time you are spending trying to use 10+year old software intended to be used in much earlier versions of access than 2016. It is not as if you have more than 10 or 12 tables - shouldn't take more that 15 minutes to do.

with regards the error that is showing two tables MSysNavPaneGroupCategories and MSysNavPaneGroups apparently combined into one name. They are tables that did not exist before access 2007

I cannot import all the queries, Modules and forms. It is not letting me select all the forms and Modules. This is the first thing, I tried , before posting the question on this forum

[anjali6]

Hi,

I cannot import the forms and Modules. Below is the screen shot when i tried to import. each and every form is disabled.


I tried to look at the relationship table and could not find anything called MSSysNavpaneGroupCategories. Below is the screen shot of my database relationship:



I am not sure what am I doing wrong.