Hello, I'm brand new to experts exchange... so I'm praying here that this site will help me out. I'm having a problem using ADO in VB. I can connect fine, navigate through records (Access 2000 Database), Add records, Edit records, Delete records, Update records... with no problems. That is until I pass a commondialog.filename to a textbox and try to update the database. The problem is quite unusual, every time I save a record in the database, I requery the database... and have no problems with any textboxes (linked to fields) on my form. As soon as I pass the commondialog.filename to ANY textbox on my form and update... the update is successful, but then I get the error when the program requeries the recordset. Again, I'm using an ADODC data control with no problems on my VB6 (service pack 5) form, and having no problem with the update then requery... but after passing the commondialog1.filename to any textbox then update/requery the error pops up. Please help, I've been racking my brain for about 3 hours and searched the web up and down for something along the lines of this problem.
BTW... It is passing the path C:\Books2.Gif to a textbox/textboxes that are linked to fields inside the database (MSAccess 2000, Jet4) with valid datatypes. I've tried memo and text with a length of 255 chars. And if I type the path in it can save and requery, but if it gets passed from the commondialog.filename (Exactly the same string), it crashes during requery.