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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

mgreenway@xxxxxxxxx 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 <datatype>"
2. Change "Set <variable> = New <class>" to
"Set <variable> = createobject("<class>")
--
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"


.

Relevant Pages

  • ASP app not working in IIS 6
    ... I have taken an .asp application from Win2K Professional personal web server ... to a deployment on a Win 2003 IIS 6 setup. ... followed the instructions for changing IE config for the "HTTP 500" errors ... I have configured the file to allow the IIS 6 user ...
    (microsoft.public.inetserver.iis)
  • Re: Populate form data in Word from ASP
    ... I've dealt with VBA a little in macros, ... I do know ASP and SQL. ... > Dian D. Chapman, Technical Consultant ...
    (microsoft.public.office.misc)
  • Re: Accessing Page Setup Options from VBA
    ... There are loads of page setup parameters that can be set in VBA ... File menu, change one of the settings, stop the macro recording. ... I know that the page setup options are specific to the printer, ...
    (microsoft.public.excel.programming)
  • Re: Accessing Page Setup Options from VBA
    ... Duplex or non-duplex printing isn't one of them. ... There are loads of page setup parameters that can be set in VBA ... I know that the page setup options are specific to the printer, ...
    (microsoft.public.excel.programming)
  • Re: Days / Hours / Minutes / Seconds - Calculation Help Needed Please
    ... the languages you can use with ASP, is a lot like VB or VBA." ... ASP isn't a programming language: ... program in it using VBScript, ...
    (microsoft.public.access.queries)