VBScript/Asp/MS Access query

[John]

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

 

[Kevin Spencer]

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.