'Insufficient base table information' using ADP's connectionstring

[ocliff]

Hi,

I'm adding and updating some rows in my ADP. I get an error on rs.Update...
(ADODB)

Does anyone know why I get the 'Insufficient base table information'-error
when I use the ADP's connectionstring? (Only when I use a client side cursor.)

CurrentProject.Connection.Connectionstring:

Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=SERVER\INSTANCE;Integrated Security=SSPI;Initial Catalog=DATABASE;Data
Provider=SQLOLEDB.1

This one works:
Provider=sqloledb;Data Source=SERVER\INSTANCE;Initial
Catalog=DATABASE;Integrated Security=SSPI;

Just curious, I would really like to know!

 

[Sylvain Lafontaine]

Are you trying to set the connection string directly or if you are calling
CurrentProject.CloseConnection() followed by a call to
CurrentProject.OpenConnection(strConnect, user, password)?

CurrentProject.CloseConnection
CurrentProject.OpenConnection connectionString, user, password

And when opening the connection, don't use the version with the
Microsoft.Access.OLEDB.10.0 provider; as this will be set up automatically
by Access. Access (or ADP) opens three connections (and sometimes more)
when connecting to the SQL-Server and it is possible that with your method,
all these connections aren't set up correctly.

More info:
http://support.microsoft.com/kb/q240293/

http://support.microsoft.com/kb/281784/