What is the best way to work with an MS Access database? So far I am using data adapters and data tables, but it doesn't seem efficient. There are a lot of times where I am comparing many tables, and even though everything is working smoothly, I just feel I could do better.
That, and what is the best way to display multi-column rows of data? I tried using a data grid, but it keeps entering in a new row at the end, plus you can edit it. I want a static, clean table, with possibly the ability to click on the cells.
Oh, and do you think record sets would be better than data tables? Like I said, the way I have it is working, but what are some othe popular methods? Thanks!
That, and what is the best way to display multi-column rows of data? I tried using a data grid, but it keeps entering in a new row at the end, plus you can edit it. I want a static, clean table, with possibly the ability to click on the cells.
Oh, and do you think record sets would be better than data tables? Like I said, the way I have it is working, but what are some othe popular methods? Thanks!
