I found an error in my sintax, in the select statement i write the name of the tabel between " ' ", now it gives me the error that this is something wrong in the sentence.
here is what I wrote using the CA builder in the DE of the form

connection string :
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Documents and Settings\Alex\Documenti\access\db1.mdb;Exclusive=1;Uid=admin;Pwd=;

and it seems to work as it opens the database

select command :
select anagraf.id, anagraf.cognome, anagraf.nome from db1!anagraf

I placed db1!anagraf instead of anagraf because it tells me it could not find the table, though know it tells me that the sintax is wrong

cursor schema :
id i, nome c(40), cognome c(40)

As you see I'm trying to connect to the db1.mdb database and select fields from its anagraf table



>uhm it gives me the error 1526, connectivity error , something is wrong in the query sintax
>I'm going to check it later, thx Boris i'll let you know
>Alessio
>
>>Alessio,
>>Did you issue a CursorFill() Method?
>>If you do, try this:
>>
>>

>>IF .NOT. CAObject.CursorFill()
>>   AERROR(arErr)
>>   DISPLAY MEMORY LIKE arErr
>>ENDIF
>>