currentproject.connection.execute high severity error

G

Gianluca

Hi,
I do an abstract of my situaton.

I have 2 machines for server.
First (production) SBS 2003 SQL server 2000 SP3a & MDAC 2.8
Second (dev) XP SP2, MDAC 2.8 SP1
The errors i get are the same if i connect on the first or on the second
server.

I develop on Access 2003 SP2 , with mdb project format 2002-2003.
Recently I have created a new 2002-2003 project and imported all forms,
modules,.. from the previous project. So the project is clean (I think).

I have these references in VBA:
VBA
Acces 11.0
ADO 2.8
Microsoft scripting runtime
Office 11
Excel 11
Word 11

The problem.
From one/two months i have several errors like this
Run-time error '-2147418113' errore irreparabile
on lines of code written 4/6 months ago.

All lines of code with this error are like this:
currentproject.connection.execute "UPDATE TABLE SET... WHERE...",,adcmdtext
+ adExecuteNorecords
or
currentproject.connection.execute "UPDATE TABLE SET... WHERE..."

The problem is on UPDATE and DELETE, not for INSERT.
The only workaround I found is to open a new connection with OLEDB
and execute the command with this one.

I'd like to avoid modifying tons of code to open/close a new connection
(and to modify syntax!) each time i have to execute a sql command.

Can anyone help me?
Thanks in advance
Gianluca
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top