Question

Locked

VB & ACCESS CONNECTION QUERY

By ashok.sharma ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums