Access

message from =?Utf-8?B?R2VvZmZU?= on 1 Jun 2004
i am using access 2003 and have started getting the folowing error message when trying to open a database = "set dbs=CurrentDb()"
Compile error - Error in loading dll

Anyone got any ideas?

' 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)
 

Archived message: Access (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.