Referencing Tables

[DeutchBose]

I am able to run following in Access '97, but not in Access XP:

Dim db as Database
Dim tbl as Table
Dim pDate as Date

Set db as CurrentDb()
Set tbl as db.OpenTable("Table1")

tbl.MoveFirst
If Not tbl.EOF Then
pDate = tbl.ProcessingDate
End If

This code works fine for Access 97, but after converting to XP, it doesn't recognize 'Table' as a 'user-defined type'. If I change Table to Recordset, it then won't recognize the field name 'ProcessingDate' in the table.

The only difference as far as I can tell is that '97 uses the DAO 2.5/3.5 Object Library, while XP is using the DAO 3.6 Object Library.

Any ideas?

Thanks.

 

[ChrisUK]

Here's a snippet of code I used to do something similar;

Dim wrkODBC As Workspace
Dim dbsNorthwind As Database
Dim conPubs As Connection
Dim rstTemp As Recordset
Dim rstTemp2 As Recordset

Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
Set dbsNorthwind = wrkJet.OpenDatabase("chris.mdb")

Set rstTemp = dbsNorthwind.OpenRecordset("LinkTable", dbOpenForwardOnly)

If Not rstTemp.EOF Then
Debug.Print rstTemp.Fields(1)
End If


HTH

Chris

 

[SydneyGeek]

Check Tools | References iin a module. Is DAO above ADO in the list of ticked items? If not, change the order and try again.

Denis