Re: ACCESS 2000

Posted by Jeff on March 01, 2001 at 00:08:12:

In Reply to: ACCESS 2000 posted by Alhammad on February 08, 2001 at 05:14:53:

: How can I use Access 2000 with delphi 5 becouse Now I am working with Access 97 ?

Just to let you know, I am a beginner programmer. But anyway,
you can use ADO objects but I don't know anything about it.

I used the BDE Administrator and the ODBC administrator with Delphi 5 Professional. I created an ODBC DSN and then I created the Alias using BDE administrator. One of the properties for the Alias is ODBC DSN.

In my Delphi program I went to Data Access components.
1. TDatabase.
- Go to properties and fill in the Alias Name and Database Name.
2. TTable.
- Go to properties and fill in the Database name and then select the appropiate table. Make the database name the same for TDatabase and
TTable to avoid a login prompt.
3. TDataSource
- Go to properties and fill in the dataset with the TTable.

You don't need to use text boxes. Go to Data Controls and select DBGrid. Use DBGrid referencing the datasource.

Basically:
1. new BDE Alias referencing and ODBC DS N.
2. TTable referenze to 1.
3. TDatasource referenze to 2.
4. component to show Data with referenze to 3 (DBGrid).

I also used Data Component -> TDatabase in order to avoid the login prompt.

You might want to check out the TQuery also.
It might help you out.

There are a couple more notes in the forum.
Under Accessing an Access 2000 database.