By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,947 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,947 IT Pros & Developers. It's quick & easy.

I can't connect Access database into more form please help me

P: 1
I am workin with a superstore managment project. I connect Access database with main form . Then it work properly. But now I connect same database with another table or field in another form which is child of main form not working.

Main form stil working but when try to open child a message show as



Please select a valid SQL statement as "Select", "Delet" or "Updat"

I am working with Access . I connect database in same way . but mainform working and child form not working .

** Pont**


I link child form as

Dim child As New frmlogin()


frmmain Load_Event(... ...... ......)...

child.ShowDialog()



my code for data connection is as in load event .....




m_cnADOConnection.Open("Provider=Microsoft.jet.OLE DB.4.0;" & _
"Data source = C:\G3SP\G3SP.mdb")


m_rstProduct.Open("Product", m_cnADOConnection, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockBatchOptimistic)





Please Someone help me ?
Thanking u
Asad
Jul 31 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.