469,287 Members | 2,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,287 developers. It's quick & easy.

Insufficient base table information for updating or refreshing ...

Hi All,

context:
I am using Access 97 tablkes with VB.
I can see records in the MDB, using Adodc and datagrid.
No problem.
But when doing:
rsprivate.AddNew
rsprivate!For = rsusers!identification
rsprivate!Receivedon = ladate
rsprivate!Fromnumber = lenum
rsprivate!Message = lemessage
rsprivate!Fromname = rscontacts!Prénom & " " & rscontacts!Nom
' rscontacts is another MDB opened the same way
rsprivate.Update
I got the "Insufficient base table information for updating or refreshing"
message.

What do I do wrong ?

Rgds, Bernard

here is the way I open the MDB:

In General/Declarations:
Private WithEvents globalConnection As ADODB.Connection
Private WithEvents rsglobal As ADODB.Recordset

In the Form_Load()
globalProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
globalDataSource = "Data Source=" & Text10 ' Text10 contains the
path to the network volume where the MDB is located
globalConnect = globalProvider & globalDataSource
Set globalConnection = New ADODB.Connection
globalConnection.CursorLocation = adUseClient
globalConnection.Open globalConnect
Set rsglobal = New ADODB.Recordset
rsglobal.CursorType = adOpenStatic
rsglobal.CursorLocation = adUseClient
rsglobal.LockType = adLockOptimistic
rsglobal.Source = "SELECT * From received ORDER BY received.Receivedon
DESC;"
rsglobal.ActiveConnection = globalConnection
rsglobal.Open
Set gridglobal.DataSource = rsglobal.DataSource

Jul 17 '05 #1
3 7890
SA
Bernard:

Stop by the Microsoft Knowledgebase and look at the following article:

Q190108:
FIX: Error Updating adUseClient Cursor Based on MDB Query

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Bernard André" <be****@bernan.net> wrote in message
news:3f********@news1.mweb.co.za...
Hi All,

context:
I am using Access 97 tablkes with VB.
I can see records in the MDB, using Adodc and datagrid.
No problem.
But when doing:
rsprivate.AddNew
rsprivate!For = rsusers!identification
rsprivate!Receivedon = ladate
rsprivate!Fromnumber = lenum
rsprivate!Message = lemessage
rsprivate!Fromname = rscontacts!Prénom & " " & rscontacts!Nom
' rscontacts is another MDB opened the same way
rsprivate.Update
I got the "Insufficient base table information for updating or refreshing"
message.

What do I do wrong ?

Rgds, Bernard

here is the way I open the MDB:

In General/Declarations:
Private WithEvents globalConnection As ADODB.Connection
Private WithEvents rsglobal As ADODB.Recordset

In the Form_Load()
globalProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
globalDataSource = "Data Source=" & Text10 ' Text10 contains the
path to the network volume where the MDB is located
globalConnect = globalProvider & globalDataSource
Set globalConnection = New ADODB.Connection
globalConnection.CursorLocation = adUseClient
globalConnection.Open globalConnect
Set rsglobal = New ADODB.Recordset
rsglobal.CursorType = adOpenStatic
rsglobal.CursorLocation = adUseClient
rsglobal.LockType = adLockOptimistic
rsglobal.Source = "SELECT * From received ORDER BY received.Receivedon
DESC;"
rsglobal.ActiveConnection = globalConnection
rsglobal.Open
Set gridglobal.DataSource = rsglobal.DataSource

Jul 17 '05 #2
Thanks Steve,
I will have a look now and will keep you informed.

Regards,
Bernard

"SA" <~f***********@nspm.com> wrote in message
news:bh**********@ngspool-d02.news.aol.com...
Bernard:

Stop by the Microsoft Knowledgebase and look at the following article:

Q190108:
FIX: Error Updating adUseClient Cursor Based on MDB Query

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Bernard André" <be****@bernan.net> wrote in message
news:3f********@news1.mweb.co.za...
Hi All,

context:
I am using Access 97 tablkes with VB.
I can see records in the MDB, using Adodc and datagrid.
No problem.
But when doing:
rsprivate.AddNew
rsprivate!For = rsusers!identification
rsprivate!Receivedon = ladate
rsprivate!Fromnumber = lenum
rsprivate!Message = lemessage
rsprivate!Fromname = rscontacts!Prénom & " " & rscontacts!Nom ' rscontacts is another MDB opened the same way
rsprivate.Update
I got the "Insufficient base table information for updating or refreshing" message.

What do I do wrong ?

Rgds, Bernard

here is the way I open the MDB:

In General/Declarations:
Private WithEvents globalConnection As ADODB.Connection
Private WithEvents rsglobal As ADODB.Recordset

In the Form_Load()
globalProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
globalDataSource = "Data Source=" & Text10 ' Text10 contains the path to the network volume where the MDB is located
globalConnect = globalProvider & globalDataSource
Set globalConnection = New ADODB.Connection
globalConnection.CursorLocation = adUseClient
globalConnection.Open globalConnect
Set rsglobal = New ADODB.Recordset
rsglobal.CursorType = adOpenStatic
rsglobal.CursorLocation = adUseClient
rsglobal.LockType = adLockOptimistic
rsglobal.Source = "SELECT * From received ORDER BY received.Receivedon
DESC;"
rsglobal.ActiveConnection = globalConnection
rsglobal.Open
Set gridglobal.DataSource = rsglobal.DataSource


Jul 17 '05 #3
Hi Steve,

Thanks for the tip but it must be something else.

In fact, it does work for some MDB tables that I update, and doesn't for
some others.
Is there, at you opinion, a problem when opening several tables from the
same MDB, with a connection for each table?
What's funny is that some tables from the same MDB can be updated and some
can't.

Bernard

"SA" <~f***********@nspm.com> wrote in message
news:bh**********@ngspool-d02.news.aol.com...
Bernard:

Stop by the Microsoft Knowledgebase and look at the following article:

Q190108:
FIX: Error Updating adUseClient Cursor Based on MDB Query

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Bernard André" <be****@bernan.net> wrote in message
news:3f********@news1.mweb.co.za...
Hi All,

context:
I am using Access 97 tablkes with VB.
I can see records in the MDB, using Adodc and datagrid.
No problem.
But when doing:
rsprivate.AddNew
rsprivate!For = rsusers!identification
rsprivate!Receivedon = ladate
rsprivate!Fromnumber = lenum
rsprivate!Message = lemessage
rsprivate!Fromname = rscontacts!Prénom & " " & rscontacts!Nom ' rscontacts is another MDB opened the same way
rsprivate.Update
I got the "Insufficient base table information for updating or refreshing" message.

What do I do wrong ?

Rgds, Bernard

here is the way I open the MDB:

In General/Declarations:
Private WithEvents globalConnection As ADODB.Connection
Private WithEvents rsglobal As ADODB.Recordset

In the Form_Load()
globalProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
globalDataSource = "Data Source=" & Text10 ' Text10 contains the path to the network volume where the MDB is located
globalConnect = globalProvider & globalDataSource
Set globalConnection = New ADODB.Connection
globalConnection.CursorLocation = adUseClient
globalConnection.Open globalConnect
Set rsglobal = New ADODB.Recordset
rsglobal.CursorType = adOpenStatic
rsglobal.CursorLocation = adUseClient
rsglobal.LockType = adLockOptimistic
rsglobal.Source = "SELECT * From received ORDER BY received.Receivedon
DESC;"
rsglobal.ActiveConnection = globalConnection
rsglobal.Open
Set gridglobal.DataSource = rsglobal.DataSource


Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by crack4u | last post: by
1 post views Thread by Zri Man | last post: by
3 posts views Thread by bikkaran | last post: by
reply views Thread by jefftyzzer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.