Need help with viewing my database

[kg9ie]

I have an Access database, and I'd like to be able to view one of the tables in a data grid format like the standard presentation in Access.

I want to be able to add records to the bottom of the grid as well. Another requirement would be the ability to scroll when the grid gets too long.

How can I accomplish this?

Thanks,
Todd

 

[Zyrenthian]

You will need to
1. Have the access database as an ODBC datasource
2. Use CDatabase to gain access to it
3a. POSSIBLY use CRecordset to interact easier
3b. Use ExecuteSQL and avoid CRecorset entierly.


If you are just beginning, I would suggest using CRecordset. keep in mind it can be a bit buggy. You can insert a new MFC class and derrive it from CRecordset, select the database source and it will configure itself.

See if this can get you started.

matt