Login   /   Register

Delete a Record from a Recordset

April 1st, 2008 by daniva
     0 votes, average: 0 out of 50 votes, average: 0 out of 50 votes, average: 0 out of 50 votes, average: 0 out of 50 votes, average: 0 out of 5
Loading ... Loading ...

The following code demonstrates how to delete a record from a table.
The example uses the Flight Reservation Database ( non default records )

Create a Table in a JET Database

April 1st, 2008 by daniva
     1 votes, average: 5 out of 51 votes, average: 5 out of 51 votes, average: 5 out of 51 votes, average: 5 out of 51 votes, average: 5 out of 5
Loading ... Loading ...

The following code demonstrates how to create a new table in the Flight32.mdb

Create a New JET Database

April 1st, 2008 by daniva
     1 votes, average: 2 out of 51 votes, average: 2 out of 51 votes, average: 2 out of 51 votes, average: 2 out of 51 votes, average: 2 out of 5
Loading ... Loading ...

The following code demonstrates how to create a new database named New_db.mdb.

Retrieve a list of the system DSNs installed

April 1st, 2008 by daniva
     2 votes, average: 2 out of 52 votes, average: 2 out of 52 votes, average: 2 out of 52 votes, average: 2 out of 52 votes, average: 2 out of 5
Loading ... Loading ...

If you have no idea what we’re talking about System DSNs are simply a shortcut method for connecting to databases and other data sources. You can view a list of the System DSNs available on a computer by bringing up the ODBC Data Source Administrator dialog box and looking on the System DSN tab

Get a list of the ODBC drivers installed

April 1st, 2008 by daniva
     1 votes, average: 1 out of 51 votes, average: 1 out of 51 votes, average: 1 out of 51 votes, average: 1 out of 51 votes, average: 1 out of 5
Loading ... Loading ...

The registry, is the upstairs closet of the operating system: if you’re willing to look, you can find almost anything in the registry. That’s where can be found the list of installed ODBC drivers, in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers.