Create a blank *.txt file with NotePad ģ. BUt the simple way to do/learn it would be go through these steps:ġ. You can search the Internet for the connection string to connect *.mdb/*.accdb. It is recommended DSN-less connection, that is, with ConnectionString specifying data provider/driver, data source and security information, usually OleDb provider (ODBC provider can also be used, if you choose so). Once the DSN is created, the ADO.Connection's uses the DSN as its connection string, something likeĪs you can see, using ODBC DSN is like hard-coded database file name, which is not very flexible. In "System DSN" tab, click "Add" button and follow the wizard to create a DSN that connect to the target *.mdb/*.accdb file. To use ODBC DSN (data source name), you create either a user DSN or a system DSN (usually system DSN, so that any user logged into that computer would be able to reach it).
The picture you showed is for creating ODBC data source, which you may or may not have to do: the ADO connection can be either connected via ODBC data source name (thus, you need to create DSN on each computer that runs your program), or connected via OleDB provider.
You can do ahead to write code to connect to *.mdb/*.accdb with ADO, or DAO (older technology, if you prefer for certain reason, such as re-using existing old code). It looks look you have MS Access DB Engine 64-bit installed.
0 kommentar(er)
