V
vandewinkle
I am accessing an access db (pts.mdb) via VB6. Everything has been working
great. I added 2 tables to the pts.mdb and whenever I try to read the new
tables I get the above message; but if I change the table name (PTS_Vendors)
to an original table name then it reads just fine.
How can it read one table but not another?
There are no other users on this database and here is my VB6 code on the read:
Private Sub ConnectToPTSDB()
Dim cnnConnectString As String
Set rs = New ADODB.Recordset
Set cnn = New ADODB.Connection
rs.LockType = adLockOptimistic
cnn.ConnectionTimeout = 30
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=F:\MyDir\database\pts.db;Persist Security Info=False"
cnn.Open
'Check to make certain we have a good connection
If cnn.State = adStateOpen Then
'select something from a table to check to see if we have a good connection
Set rs = cnn.Execute("select * from PTS_Vendors")
PS - Thanks in advance for your time on this =)
great. I added 2 tables to the pts.mdb and whenever I try to read the new
tables I get the above message; but if I change the table name (PTS_Vendors)
to an original table name then it reads just fine.
How can it read one table but not another?
There are no other users on this database and here is my VB6 code on the read:
Private Sub ConnectToPTSDB()
Dim cnnConnectString As String
Set rs = New ADODB.Recordset
Set cnn = New ADODB.Connection
rs.LockType = adLockOptimistic
cnn.ConnectionTimeout = 30
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=F:\MyDir\database\pts.db;Persist Security Info=False"
cnn.Open
'Check to make certain we have a good connection
If cnn.State = adStateOpen Then
'select something from a table to check to see if we have a good connection
Set rs = cnn.Execute("select * from PTS_Vendors")
PS - Thanks in advance for your time on this =)