Re: Copying access objects using .net

Not sure about Jet 3.x (Access 97 and earlier) but Jet 4 (Access 2000 and
later) does.

--
Brendan Reynolds (Access MVP)


"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:OEFwmAzjFHA.2852@xxxxxxxxxxxxxxxxxxxxxxx
> 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