By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,733 Members | 1,263 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,733 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(... ...... ......)...


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
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.