Conversion from Acess 2003 to 2007

[doddiah]

The first Line


Dim dbs as Database does not work after converting to Acess 2007 from Acess 2003 with a to missing DAO350.dll version 5.0 and it cannot compile the following Sub

it cannot pass "Dim dbs as Database"

What should I do to overcome this problem
Private Sub FillOptions()
' Fill in the options for this switchboard page.
' The number of buttons on the form.
Const conNumButtons = 8

Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer

' Set the focus to the first button on the form,
' and then hide all of the buttons on the form
' but the first. You can't hide the field with the focus.
Me![Option1].SetFocus
For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False
Me("OptionLabel" & intOption).Visible = False
Next intOption

' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL)

' If there are no options for this Switchboard Page,
' display a message. Otherwise, fill the page with the items.
If (rst.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this switchboard page"
Else
While (Not (rst.EOF))
Me("Option" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Visible = True
Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
rst.MoveNext
Wend
End If
' Close the recordset and the database.
rst.Close
dbs.Close
End Sub

[CJ_London]

Access changed from JET to ACE in 2007 now requires you specify what type of database/object so redeclare as

Dim dbs As DAO.Database
Dim rst As DAO.Recordset

And the library should now be ACEDAO.DLL (Microsoft Office 14.0 Access database engine Objects)

[doddiah]

Hi,

Tried to make this DLL part of the "MISSING" DAO Object in the References tab, but it is still not recognizing it yet are there any other DLL's that need to be present in that .

directory that I created in Program Files/Common File/Microsoft Shared/DAO

Alternatively how should I change the code, this is used to populate a switchboard

Thanks

[doddiah]

Tried DAO360.dll and setting the reference helped thanks