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