MS Access Copy Table And Data *Using ASP*

I am in the process of merging approximately 5 databases for
development into 1 final database but will for the new merged copy to
go live I need to copy over all the data on a live server using a
single asp script.

In access I can do a copy and paste using structure and data.

How can I do this using ASP?
I have researched using a VBA and it doesnt fit with my requirements.
I will need to set up IIS using the script at the same time, which is
impossible to do with a VBA.

The problem with creating and populating simply i need the autonumbers
to remain the same.

I know that I previously posted a similar issue but that route (VBA)
didn't prove to be a fruitful endevour. So my understanding is that I
should start a new topic. To make it easier to follow

Thanks for your help

MGREENWAY

Re: MS Access Copy Table And Data *Using ASP*

mgreenway@gmail.com wrote:
> I am in the process of merging approximately 5 databases for
> development into 1 final database but will for the new merged copy to
> go live I need to copy over all the data on a live server using a
> single asp script.
>
> In access I can do a copy and paste using structure and data.
>
> How can I do this using ASP?
> I have researched using a VBA and it doesnt fit with my requirements.

It would help if you outlined the requirements that VBA does not meet. You
may be wrong about this ... I am not aware of anything a vbscript script can
do that cannot be done via VBA


> I will need to set up IIS using the script at the same time, which is
> impossible to do with a VBA.

Why? And what setup of IIS are you talking about that can be done via an ASP
page? The abilities of an asp page to do any "IIS setup" are limited (and
rightfully so). IIS would need to be "setup" correctly in the first place
BEFORE an asp page could run, if I am interpreting what you mean by "setup"
correctly.

>
> The problem with creating and populating simply i need the autonumbers
> to remain the same.

Which makes TransferDatabase ideal for you.

However, the first link I posted was to a VBA procedure that used ADOX to
create the tables and ADO recordsets to move the data. Clunky and slow, but
easily translatable to vbscript [1]. Could you explain why this oes not meet
your requirement?

>
> I know that I previously posted a similar issue but that route (VBA)
> didn't prove to be a fruitful endevour. So my understanding is that I
> should start a new topic. To make it easier to follow

No, starting a new thread on the same topic will make the conversation
harder to follow, especially if someone replies to your first thread,
resulting in two threads on the same topic. But it's not a huge faux pas.

Bob Barrows

[1] 1. all variables are variants in vbscript, so get
rid of all the occurrences of "as "
2. Change "Set = New " to
"Set = createobject("")
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"