VBScript/Asp/MS Access query

J

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
 
K

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.
Click to expand...

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.
Click to expand...

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.
 
Top