Working with a DataBase
-
Hello, the codegurus around the world.;) The easiest way to work Access is to use Access Basic. However, we can't create the stand alone execute file. So, the next way is to use Visual Basic with ADO since we can create exe files. If you don't like Visual Basic like me, now try to use Visual C++. :rolleyes: ADO expands the approach since we can use the same code to Oracle and SQL server. However, we can't get the benefit of Access database. So, sometimes we had better use CDaoDatabase, CDaoRecordSet, and the other useful classes to deal with the benefit of Access database. If you have a time, try to create the application by the above methods. So, you can understand which way is best for your requirement. Last, Access Database can't deal with concurrent access from the users. (not thread safe) So, we had better use SQL server or Oracle when the many users access the database at the same time like the web based database. Have a nice day! -Masaaki Onishi-