Exporting Objects from 64-Bit File for 32-Bit File

hhzyousafi

Registered User.
Local time
Today, 17:55
Joined
Nov 18, 2013
Messages
74
I have spent the better part of this past week developing an application for my staff; however I did so on my laptop and my laptop is currently running a 64-bit version of Microsoft Access. My staff currently has a 32-bit version of Microsoft Access on their computers - what can I do? I have tried a few things but I have only been able to successfully recover my tables thus far; what about the rest of the objects in the files? Is anything possible? :banghead:
 
Thank you for the quick response Paul; however the issue here is that I have created the file in the 64-Bit version of Microsoft Access. As a result the file doesn't even open on a 32-bit installation. I reviewed the code in your post; however I am unclear as to where I would actually enter that code.
 
Unless the File is compiled ACCDE you should be able to simple import the objects. Insead of Exporting, try importing from the 64 bit file.
 
I am trying to import the objects to the 32-bit file. The problem is that Microsoft Access imports the objects into the file and then converts the file into a 64-bit file. Is that what is supposed to happen?
 
How do you identify that the file is converted to 64-bit? :confused:
 
Because when I try opening the file in a 32-bit version of Microsoft Office it gives me an error saying that the file has an "unrecognised database format". When I try opening that same file in a 64-bit version of Microsoft Access it opens up as expected.
 
Can you post a Stripped DB here?

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)
 
Please find attached the file I am referring to. The attached file is in 64-bit and there is one table and one form (i.e. tblAccessLevel and frmAccessLevel).
 

Attachments

I opened the file in 32-bit Access it opened with no issues at all !

EDIT: Checked opening the file in 64 bit Access it opens no problem. Think your file might be getting corrupted somewhere along the lines. Try a Compact & Repair.
 
Is there any chance you are just messing with me!? :o

I hope not :) What version of Microsoft Access are you using (i.e. 2007, 2010, 2013)?
 
Is there any chance you are just messing with me!? :o

I hope not :) What version of Microsoft Access are you using (i.e. 2007, 2010, 2013)?
Lol ! I sure am not messing with you..

MS Access 2010 32-Bit on Windows 7 64-Bit (Personal) and
MS Access 2010 64-Bit On Windows Server 2000 64-Bit (Work)
 
Last edited:
Paul I think I am going to have to start paying you a consulting fee now! I really do appreciate the prompt responses. Are you using Microsoft Access 2007, 2010, or 2013? I am assuming you are probably using 2010?
 
Paul I think I am going to have to start paying you a consulting fee now! I really do appreciate the prompt responses.
Invoice and bank details sent to your PM. :p Just kidding. We all learn from this, so its all good !
Are you using Microsoft Access 2007, 2010, or 2013? I am assuming you are probably using 2010?
Access 2010. I have that in my signature, thought that might be quiet evident. :D
 
Thank you for your help Paul! I have successfully been able to convert from a 64-Bit Access File that was made in Access 2013 to a 32-Bit File that is now compatible with Access 2007. Gotta love Microsoft and their backwards compatability! Nonetheless thank you very much. The steps you outlined got me going!
 
Thank you for your help Paul! I have successfully been able to convert from a 64-Bit Access File that was made in Access 2013 to a 32-Bit File that is now compatible with Access 2007. Gotta love Microsoft and their backwards compatability! Nonetheless thank you very much. The steps you outlined got me going!

Could you please tell us exactly how you did this? I'm having the same issue and cannot find anything helpful on the subject elsewhere...
 
Could you please tell us exactly how you did this? I'm having the same issue and cannot find anything helpful on the subject elsewhere...
If you have some specific problem, I suggest you explain your problem in a new thread ! So you can advantage from several other users support, than limiting yourself to a few by reviving an old thread.
 

Users who are viewing this thread

Back
Top Bottom