How to access DBISAM & MS Access for a common App

[JayBird265]

Hi;

I am developing a common standalone application for two customers, one will use DBISAM and the other MS ACCESS. The table structures are all the same, and I would like some suggestions on the best way to develop my forms that will allow me to switch between the two databases. I have created one DataModule with DAO and TDBISAM, but the challenge I have is how to handle all the Queries, Client DataSets, etc.

Any help would be greatly appreciated.
Thanks in advance
Jay

 

[svanels]

When I don't want to lock myself to a specific product (database), I just use the BDE with the Borland components like ttable, tquery, tstoredproc etc..
Changing from on database to another is in this case a simple modification in the alias, using the BDE Administrator

Steven