Re: Copying access objects using .net

You could if Access supports DDL syntax for it, like CREATE PROCEDURE in SQL
Server. If it does, then just execute it as an action query

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FE86716B-C6B6-4CFD-930F-0AB2D54D4A4C@xxxxxxxxxxxxxxxx
> Val, thank you for your response. Although I can create a table in this
> manner, it appears that I cannot create a query. Am I correct?
> --
> Thanks, Bob
>
>
> "Val Mazur (MVP)" wrote:
>
>> Hi,
>>
>> You need to use ADOX library to do this. ADO and ADO.NET manipulate data
>> and
>> could execute DDL statements, like CREATE TABLE etc, but they do not
>> transfer objects from one db to another one as is. If you would like to
>> transfer table using ADO.NET, then you need to create the table and all
>> the
>> indexes first using CREATE TABLE statement and then copy data.
>> --
>> Val Mazur
>> Microsoft MVP
>>
>> http://xport.mvps.org
>>
>>
>>
>> "Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:83A9CA0C-AE90-4012-9885-DFD067B76CBB@xxxxxxxxxxxxxxxx
>> > How do I program vb.net to copy a query or table from one MS Access
>> > database
>> > to another?
>> >
>> > I'd like to accomplish what import does when it copies Access objects
>> > (primarily queries but some tables) from another database into the
>> > database
>> > where the import action is selected---EXCEPT that I'd like to do this
>> > externally with a VB.net program.
>> >
>> > --
>> > Thanks, Bob
>>
>>
>>


.

Relevant Pages

  • Re: Newbie question about formula based values
    ... if the query hangs or if Access crashes or is someone restarts ... If you want to execute the code from your web site, you can do that as well. ... If your web site can execute SQL code against an Access database, ... In Windows scheduler, create a new scheduled task based on Microsoft ...
    (comp.databases.ms-access)
  • TIP #308: Twylites concerns
    ... If, as you say, the simple change of adding a place for [$db execute] ... likely the result of a query against a system catalog. ... > especially for a pure-Tcl implementation for a specific database. ... 'execute' functionality that you discussed above address this concern? ...
    (comp.lang.tcl)
  • Re: .Execute vs. .RunSQL - Speed vs. Size
    ... >to know which is faster - Dim a database and then use the db.execute method ... Execute a sequence of action queries. ... Note that Execute requires you to resolve any query ... can gain orders of magnitude better improvement by making ...
    (microsoft.public.access.formscoding)
  • Re: disable index while doing insert into
    ... source and target table have multiple indexes, ... to execute this query but when i've deleted the indexes on target ... This is a price you have to pay on any database not just Sybase. ...
    (comp.databases.sybase)
  • Re: Execute queries in back-end database via ADO !?!
    ... > I found that by defining an ADO connection to my back end database, ... execute a SQL query stored in my back end database. ... As long as your data is stored in an MDB file all query processing is ... What program would you expect to execute the query on the back end? ...
    (microsoft.public.access.queries)