473,838 Members | 1,654 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Running a 32 bit database on a 64 bit machine

94 New Member
I have a database I originally created on a 32 bit machine, which needs the front end updating, but my computer is 64 bit, and so therefore none of the code runs. However, I don't want to convert the database to 64 bit if I can help it, as all the machines it will be running on are 32 bit, I just need to edit it. All are running Access 2010, and windows 7.

Is there any way of editing it on my computer? Or will converting it to a 64 bit database still allow it to work on the 32 bit machines?
Feb 26 '13 #1
13 69245
zmbd
5,501 Recognized Expert Moderator Expert
Once you convert to 64bit the file will not be usable on the 32bit PC.
You need to check which version of MS Access you are using, and which "bit" version.

At Work: Windows 7 - 64bit - Enterprise with 32bit version of MS Access/Office-2010. The files I create and run here on the work PC, run just fine on my home PC running under WindowsXP-MCE-SP3 using MS Access/Office-2010-32bit.
Feb 26 '13 #2
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
First note that 64 bit machines can (and quite often do) run 32 bit Office. In fact I believe it is the recommended practice to install 32 bit office. It is actually the default.

With that said, you can edit a 32 bit version of an access db if your office installation is 32 bit. It does not matter if your windows installation is 64 bit. If you use API calls it gets slightly more complicated as some of these API calls will have to be fixed to use the 64 bit equivalents of the API.

Hope that helps.
Feb 26 '13 #3
zmbd
5,501 Recognized Expert Moderator Expert
A few things to consider: Choose the 32-bit or 64-bit version of Office

A slightly different set of information (but close):
Learn about the 32-bit versus 64-bit version in the new version of Office

Compatibility Between the 32-bit and 64-bit Versions of Office 2010
Feb 26 '13 #4
James Bowyer
94 New Member
Access 64 bit is already installed on my PC, Could I install a 32 bit version on my machine?
Feb 26 '13 #5
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
From what I have read elsewhere, Office as a package can only be installed as either 32 or 64 bit.

I don't have much experience with virtual machines, but maybe that could be an avenue to persue, since you presumably already have the windows and office license.
Feb 26 '13 #6
James Bowyer
94 New Member
I'll try and look into the virtual machine idea. Its bizzare, I've created databases on my 64 bit machine which work fine on other computers, which I'd always assumed to be 32 bit, and I've never had an issue until now with a 64 bit or 32 bit machine (in fact, I'm pretty sure the machine that I originally created it on was 64 bit, although the install of Access must have been 32).

Why can't everything just work?!
Feb 26 '13 #7
zmbd
5,501 Recognized Expert Moderator Expert
Please read the links I gave you in post #4
Here is also one means
HOWEVER
The exact method for installing Office to a VM will depend entirely upon what software you are using...
I'd also recomend that you have like, really, monster level equipment or Office will run like a slug on a hot sidewalk:
Virtualizing Microsoft Office 2010

and a trade mag/e-zine: How can you run Office 2010 32-bit and 64-bit on the one machine?
Feb 26 '13 #8
James Bowyer
94 New Member
Fortunately I've just discovered my spare machine, despite being 64 bit, has a 32 bit access install. Which is helpful.
Feb 27 '13 #9
neelsfer
547 Contributor
This gave me nightmares, but its working fine now. I luckily also have a spare 64bit windows OS system pc. I take the Access accdb file created on the 32 bit, and then "compile" the accdb file on the Windows 64 bit pc with Access to Accde. It works great. Also check in the Regional settings that the date/time shown as HHMMSS, is changed to lower casings hhmmss, as this seems to create a problem coming from 32bit or Access 2007 to Access 2010. This fixed my dates on the 64bit system in the application, when i "compile" it.
Feb 28 '13 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1236
by: Todd Bright | last post by:
I have a Windows service that I wrote in C#. It uses a form in another thread to keep it running because we needed some user interface activity. When the service is running the machine will NOT reboot. Anyone have any ideas about this? Is there a way to respond to a Windows reboot event? Thanks, Todd
29
5827
by: pb648174 | last post by:
I have a very long transaction that runs on the same database that other users need to use for existing data. I don't care if they see data from the transaction before it is done and am only using the transaction because I need a way to roll it back if any errors happen during the transaction. Unfortunately all tables affected in the long running transaction are completely locked and nobody else can access any of the affected tables while...
0
1260
by: Jeff Leckrone | last post by:
Hi. I am running a replicated Access 2003 database on our Windows terminal server. I put the copies on the network so that the users that need to access them can see them. When they opened their database the first time, everything seemed to work normally. However, every subsequent time they opened their database, Access would say that errors were encountered and the database needs to close. There is a button to send the error report...
1
1615
by: Stinky Pete | last post by:
Hi, I've got two users needing to look at the same database, but both are running differnent versions of access. One is running running Win 98 / Access 97 and the other is running Win XP / Access 2003. I've converted the file to 97 format so both can use it - but is there a better way to do this and not mess with the original version? Obviously ugrading would a good, but I'm not going to get approval to change until a new PC is...
2
2012
by: Gershon | last post by:
I have an ASP.NET/C# web application running against a SQL Server database using ADO.NET. Whenever there is a long-running database query, the web application hangs until the database query is complete. Even clicking the browser's stop button and clicking on other links within the web application fails. The only thing the user can do is close the browser and open up a new browser window. Is there any other way for a user to interupt a...
2
9585
by: Nans | last post by:
One basic ASP.NET database issue…. I have a c# app running on a iis6 on one win2k3 adv servermachine & database on other win2k server machine…(in the same domain) Using windows authentication in web.config. Set impersonate =true . Connection string has Integrated security=SSPI. Logging in with my ID which is system administrator and has rights all DBs on the sql machine. But still, I get this error..(even I tried putting for test...
0
1306
by: sameer | last post by:
Environment: OS of sql server 2000 server: windows 2003 standard server , .NEt framework 1.1 , sql server does not have any service pack, machine has the latest Windows service pack. Personal firewall is not enabled on this machine. All machine are within the same network. All i am dong is trying to open a connection from a .Net webservice (using ADO.NET which uses a connection string comming from web.config file) which is sitting on...
3
5646
by: axaya | last post by:
How can I transfer an online MS SQL Database with all data to a local machine MS SQL server. I am using Import Export Tool provided by MS SQL Enterprise manager but the referential integraity breaks (Primary and secondary key relationship). Thus the Data concurrency is lost and the database becaomes of no us. Most of our database projects have Stored procs, Views, Triggers and contain data. Sometimes we have to take back up of the running...
0
1133
by: peter palus | last post by:
Hi, I have a problem, how to cancel a running oracle-query. The situation: The user can type in a form, which kind of information he wants to now e.g. articletext like 'abc%'. This information is transformed to a query and the oraclecommand open is and the oraclereader execute it. That works fine. But when the oraclereader tries to read the first record, it takes a long time. This is normal, a like predicates instructs the...
0
1174
by: DUG | last post by:
There is a server in a remote location. We receive a full .bak of this database to restore on our server, where we use the data for a seperate purpose. The .BAK file is almost 3GB - zipped! They also send us transaction logs 2x / day. We would like to use those, and not download the full .BAK every night. Is it possible (how?) to "update" our version of the live database by just applying the transaction logs, and not have to begin with...
0
9696
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10584
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10645
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10290
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9425
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7827
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7015
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4063
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3131
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.