Visual C++ .NET 2003 Database Question

[BlitzPackage]

I need to build an application that will make projections and conduct analysis based on data I have assemblet into MS Access tables. This application needs to be stand alone and able to view, edit, delete, add, etc... records in grid views. While I know of SQL Server and MySQL, I don't know how to build the application so that it contains all of the needed databases (data files) and database technologies (i.e. OLE DB, ADO, or ODBC) with it. This way, it can install on any computer and doesn't need to have SQL server running on it and requires nothing but the user to install the application without having to adjust any settings. So, for example, say I am building a software that stores customer data, prices, and shipment totals, how do I manage that data in the application without requiring the customer to have SQL server, MySQL? Is there a way to just include the data files in some standard database format/technology within the application? I hope you can understand what I am trying to say.

Any help you can provide would be greatly appreciated?

[Hack]

Moved to C#

[jmcilhinney]

It sounds to me like you need to create Data Access Layer (DAL), probably in a seperate library. You would code the DAL so that it can communicate with any database, or at least any that you might be interested in. Your app will then deal with the DAL in a standard way regardless of the database, and you DAL will change the way it operates depending on the database. Here's some tips.

[dee-u]

You may also get some bits in this thread...