ADOX - Create new query in Access Database

Hello!

This is my question. I'm working with Delphi 6, ADO, MS Access 2000
Database.
I want create a new view (query) in Access database with ADOX library. This
is my code:

....
dbName := sPathStampe + '\WorkReports.mdb';
DataSource := 'Provider=Microsoft.Jet.OLEDB.4.0' +
';Data Source=' + dbName +
';Persist Security Info=False';
Cat := CoCatalog.Create;
Cat.Set_ActiveConnection ( Datasource );

sSql := 'Select * from DatiPrv';
Cat.Views.Append ('v_Prova', sSql );
.....

Compilator return error on sSql parameter of Append method (IDSpatch)

thaks

Giuseppe
Italy


.

Relevant Pages

  • Re: Data connection not working properly in Server Explorer
    ... Apparently I have to use %Crystal when running it through ADO ... > I have a data connection to an access database, ... > When I run this query in Access it works fine, and I get back a list ... > View" it comes back empty. ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: Having problem with this query
    ... Are you using ADO? ... try to use % as wildcard, instead of *, also, use ' ... > I have a few records in an Access database. ... > If i use this query in Access, ...
    (microsoft.public.vb.general.discussion)
  • Re: linked tables
    ... table defined in the Access database which is linked to a SQL Server table. ... but when I try to run a query that joins the linked & ... Can somebody explain to me how this is done in ADO? ... Microsoft MVP ...
    (microsoft.public.vb.database.ado)
  • Re: running a make table query in an access database from VB
    ... Here is an example how to call the query against Access database. ... inside of the example, you will see that ADO ... but will not return the recordset. ...
    (microsoft.public.data.ado)
  • Re: ADOX - Create new query in Access Database
    ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... I want create a new view in Access database with ADOX library. ... Compilator return error on sSql parameter of Append method ...
    (borland.public.delphi.database.ado)