Hi all,
Can anyone tell me whether its possible to have open 2 tables from one
Access database at the same time using VBScript and/or ASP.
Unfortunately, I'm not familiar with SQL, plus my server doesn't
support SQL anyway.

If there are any tutorials on the subject I'd appreciate being pointed
in the right direction.

Many thanks

Re: VBScript/Asp/MS Access query by Kevin

Kevin
Mon Jan 31 11:31:59 CST 2005

> Can anyone tell me whether its possible to have open 2 tables from one
> Access database at the same time using VBScript and/or ASP.
> Unfortunately, I'm not familiar with SQL, plus my server doesn't
> support SQL anyway.

Of course it's possible. You would have to write your own code. You just do
the same thing twice. Of course, you would need 2 RecordSets.

> If there are any tutorials on the subject I'd appreciate being pointed
> in the right direction.

My web site (http://www.takempis.com) has some beginning articles and
tutorials about using ASP and databases in general. But as I said, you just
do the same thing you do to open ONE RecordSet, twice.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"John" <im@home.net> wrote in message
news:tupsv0p3rtc9rjdafjivtbick4fi8hcco9@4ax.com...
> Hi all,
> Can anyone tell me whether its possible to have open 2 tables from one
> Access database at the same time using VBScript and/or ASP.
> Unfortunately, I'm not familiar with SQL, plus my server doesn't
> support SQL anyway.
>
> If there are any tutorials on the subject I'd appreciate being pointed
> in the right direction.
>
> Many thanks
>