472,125 Members | 1,508 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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

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
0 1854

Post your reply

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

Similar topics

6 posts views Thread by scottyman | last post: by
9 posts views Thread by =?Utf-8?B?RnJpdHo=?= | last post: by
3 posts views Thread by LamSoft | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.