Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I just upgraded to MDAC 2.8 and now I can't rs.addnew??? 2
- Thread starter steve728
- Start date
-
1
- Thread starter
- #2
-
1
- #3
Steve
I checked the Microsoft support site -- nothing obvious except for MDAC 2.6.
My suggestion is to...
- Check your references in VBA editor and verify ADO and other libraries are checked.
- Recompile your modules -- compact and repair should do this for you.
- At the code level, do you explicitly references ADO.
For example,
DIM dbs as ADO.database
MDAC 2.8 has been out since August so ant known issues would probably have been reported by now.
Richard
I checked the Microsoft support site -- nothing obvious except for MDAC 2.6.
My suggestion is to...
- Check your references in VBA editor and verify ADO and other libraries are checked.
- Recompile your modules -- compact and repair should do this for you.
- At the code level, do you explicitly references ADO.
For example,
DIM dbs as ADO.database
MDAC 2.8 has been out since August so ant known issues would probably have been reported by now.
Richard
- Thread starter
- #4
Thank you for your quick reply! I'm at a stand still! The follwoing is what I have checked in my References:
Visual Basic for Applications
MS Access 10.0 Object Library
MS ActiveX Data Objects 2.8 Library
MS Jet and Replication Objects 2.6 Library (no 2.8?)
MS ADO Ext. 2.8 DDL and Security
OLE Automation
Please continue to help me!!
Steve
Visual Basic for Applications
MS Access 10.0 Object Library
MS ActiveX Data Objects 2.8 Library
MS Jet and Replication Objects 2.6 Library (no 2.8?)
MS ADO Ext. 2.8 DDL and Security
OLE Automation
Please continue to help me!!
Steve
- Thread starter
- #5
Hi Again Willir
I forgot to add, that i DID Compact/Repair the database
and the ADO code is explicitly used like I always have in the past. For example, a simple test I'm trying right now:
(The adoconnection is already set up like normal.)
Dim rs as RecordSet
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM mytable;" adoconnection, etc...
rs.Addnew
rs.fields("name"
.value = Test"
rs.update
etc...
And still no go!!!
Steve
I forgot to add, that i DID Compact/Repair the database
and the ADO code is explicitly used like I always have in the past. For example, a simple test I'm trying right now:
(The adoconnection is already set up like normal.)
Dim rs as RecordSet
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM mytable;" adoconnection, etc...
rs.Addnew
rs.fields("name"
.value = Test"rs.update
etc...
And still no go!!!
Steve
Steve
Dim rs as [blue]ADODB.[/blue]RecordSet
[red]STOP[/red] 'See note
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM mytable;" adoconnection, etc...
rs.Addnew
rs.fields("name".value = [blue]"[/blue]Test"
rs.update
If this is not the issue...
Have you tried stepping through your code? (Sorry in advance if this is too simplictic for you -- hard to tell level of understanding in these forums) Put a STOP statement as indicated in red. Then use the F8 key to step through each line until you see the failed line.
Probably a good idea to remove any error handling too so you see the actual error.
Richard
Dim rs as [blue]ADODB.[/blue]RecordSet
[red]STOP[/red] 'See note
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM mytable;" adoconnection, etc...
rs.Addnew
rs.fields("name"
.value = [blue]"[/blue]Test"rs.update
If this is not the issue...
Have you tried stepping through your code? (Sorry in advance if this is too simplictic for you -- hard to tell level of understanding in these forums) Put a STOP statement as indicated in red. Then use the F8 key to step through each line until you see the failed line.
Probably a good idea to remove any error handling too so you see the actual error.
Richard
- Thread starter
- #7
Than you for your input friend! All day yesterday I researched the issue inside of MSDN & Microsoft.com. All is well now. I found out the MDAC 2.6 and higher no longer include the latest Jet engine plus other components. I update all service packs and am now up to par.
You are the only one that replied to my cry for help!
Have a great day. You get a star!!!!!
Steve
You are the only one that replied to my cry for help!
Have a great day. You get a star!!!!!
Steve
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question