Need a database that supports both 32 and 64bit environments

I have develop开发者_如何学运维ed an application which uses MS Access database (provider = microsoft jet) which works on my 32 bit OS, but not on 64 bit OSes.

What databases can I use instead that can be used on both 32 and 64bit environments and can be developed on a 32bit machine?

I am using VS2008, so please make sure i can use tools provided by VS to use the db

SQL Server Express edition would be a good starting point. Depends how heavy weight you want it. If you want a fairly minimal database, try SQLite.

Typically, you're going to use an 'enterprise' capable database; the big three players (to me at least), are going to be MySQL, Oracle, and SQL Server.

However, you need to define what is 'best' - what criteria determine which database you need? Each database server type has it's advantages and disadvantages.

Use SQL Server, any edition or MySQL/PostgreSQL for open source versions. Access will have issues with scalability as well if you are concerned with that.

Microsoft® SQL Server® 2008 Express Edition Service Pack 1

Requisiti di sistema

Sistemi operativi supportatiWindows 7;Windows Server 2003 Service Pack 2;Windows Server 2008;Windows Server 2008 R2;Windows Vista Service Pack 1;Windows XP Service Pack 3 Sistemi a 32 bit Computer con processore Intel o compatibile a 1 GHz o più veloce (consigliato 2 GHz o più veloce. È supportato solo un processore singolo). Almeno 256 MB di RAM (consigliato almeno 1 GB). 1 GB di spazio libero su disco rigido. Sistemi a 64 bit Processore a 1,4 GHz o più veloce (consigliato 2 GHz o più veloce. È supportato solo un processore singolo). Almeno 256 MB di RAM (consigliato almeno 1 GB). 1 GB di spazio libero su disco rigido.