I am working with a book on Access 97 and I am working in Access 2000. I have part of some code I am trying to add and I am recieving an error. My code is as follows:
Private Sub cmdChange_Click
Dim strMsg as string
‘This is the line that gives me the error
Dim wks as Workspace
Dim strErr as String
On Error GoTo cmdChange_Click_Err
Set wks = DBEngine (0)
That is the area on my problem. When I try to declare the workspace I donot get Worspace as a choice. How do I declare a Worspce in Access 2000
Dennis