Web Development

Ask something
Question Locked

VB & ACCESS CONNECTION QUERY

0 helpful
2 replies

by ashok.sharma

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Set db = New Connection
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ASHOK\D$\VB PROJECT\DATA\A.mdb;Persist Security Info=False"
Set XL = New Recordset

XL.Open "DATA0607", db, adOpenStatic, adLockOptimistic
*/////
BUT I WANT TO USE
XL.OPEN "SELECT * FROM DATA0607 WHERE MONTH="+MT+" OR MONTH = "+MT1+",DB, ADOPENSTATIC
BUT THE ABOVE SYNTEX IS NOT WORKING

2 replies

by tony hopkinson

to create a command object
set it's commandtext property to the SQL.

Then pass in command on the recordset.open call.

This discussion is closed to new replies.