Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section.
I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried
total = "SELECT COUNT(*) FROM Product" But it doesn't seems like working. There's a mismatch type error. I created another object and connect it to my MSAcess table and do a DO WHILE loop to count the number of record. Any other better suggestions??