By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

Insufficient base table information for updating or refreshing ...

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.