Free for PREMIUM members
'in general section
dim conn as adodb.connection
dim rs as adodb.recordset
'in form load
set conn=new adodb.connection
set rs=new adodb.recordset
conn="provider=microsoft jet.4.0.oledb;data source=<ur database name>;persist security info=false"
rs.open "select *from ur tablename",conn,adopendynamic,adlockoptimistic
Open in new window
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.