Subject | Re: Is Firebird a good idea for Upsizing a MS Access database? |
---|---|
Author | Aage Johansen |
Post date | 2002-03-29T10:41:11Z |
Andrew Rogers wrote:
clients as well. And, you will only have one backend system to worry about.
It seems that the ODBC driver from Easysoft works well, probably also for
Access/VB.
Regards,
Aage J.
> I have a very large MS Access Database system (lots of tablesThere is really no reason why you should not use Firebird for the smaller
> 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)
clients as well. And, you will only have one backend system to worry about.
> Is this realistic? Should I be looking at another SQL serverSince I don't use Access or VB or ODBC myself I shouldn't try to answer!
> (MS SQL, PostgreSQL etc)? Does the ODBC driver perform well with
> Access/VB? Any thoughts on this would be appreciated.
It seems that the ODBC driver from Easysoft works well, probably also for
Access/VB.
Regards,
Aage J.