B3gbie
Thread Starter
- Joined
- Nov 30, 2001
- Messages
- 228
Trying to link a vb6 data control to an access 2000 database using following code
Dim SQL As String
SQL = "Select * from " & TTDay
datTT.DatabaseName = "Timetable"
datTT.RecordSource = SQL
datTT.Refresh
The program works until refreshing the control and claims it cant find the database- any ideas why not?
I've tried using all the DAO references and no joy.
Dim SQL As String
SQL = "Select * from " & TTDay
datTT.DatabaseName = "Timetable"
datTT.RecordSource = SQL
datTT.Refresh
The program works until refreshing the control and claims it cant find the database- any ideas why not?
I've tried using all the DAO references and no joy.