64 Bit Windows

I just upgraded my web server to 64 bit windows.  File Vista does not function due to unsupported OLEDB on 64 bit.  Is there a workaround for this?

Currently there is no 64-bit version of Microsoft.Jet.OLEDB.4.0 provider thus you can not use the Microsoft Access database (.mdb) in 64 bit mode. You have two options:

1. Use SQL Server insead as there is the 64-bit version of OLEDB provider for SQL Server.

2. Try running the application in 32-bit mode. On IIS7, there's an option to run your app in 32-bit mode. In the Advanced Options under the Application Pools where your app is, there's an option to Enable 32-bit Applications. 

Let me know.

I suggest that instead of defaulting to access, that you use VistaDB (http://www.vistadb.com/) this way you can support x64 clients without having to use SQL Server. 

A developer license of VistaDB is low-cost and allows. this would be a great feature enhancement.

thanks

We have tested VistaDB last year and it seems to be a promising database engine. Note that FileVista can connect to any OleDB database so it's not dependant on specific database types. This means, if VistaDB still offers an OleDB provider (not sure for v3.3) then FileVista out of the box can work with VistaDB if you just change the connection string in FileVista.config for OleDB provider of VistaDB and convert FileVista.mdb to VistaDB format with their convertor. 
Let me know if you don't think this makes sense.

I switched to a SQL Server based database and everything works well with 64 bit Windows.

Thanks

Dave