I have a very large MS Access Database system (lots of tables that aren't too big) broken into multiple front end and backend MDBs.

Eventually Access is not going to perform satisfactorily so I need to upsize.

I only want to maintain one front end system (Access or VB probably) which can attach to two backend systems: 1. Access MDBs (they work great for our smaller clients) and 2. Firebird (or some other SQL server)

Is this realistic? Should I be looking at another SQL server (MS SQL, PostgreSQL etc)? Does the ODBC driver perform well with Access/VB? Any thoughts on this would be appreciated.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Andrew Rogers (Computer Systems Administrator)
Christian Outreach College, Brisbane
322 Wecker Rd, Mansfield 4122, Brisbane, Australia
http://www.brisbane.coc.edu.au
-----------------------------------------------------------------------------
Email: andrew@...
Ph:07 3347 5890 Fx:07 3347 5900 Mobile:0403 045 692
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-