access automation error

Hello,

When I create a switchboard in access and then try to open it, it gives
me a automation error.
I have tryed changing the code from dim db as database to dim db as
dao.database and this doesn't fix the error. When I move to the next
line the code reverts back to dim db as database.
I am in access 97.

When I try to close the application, access freezes up.
I have build switchboards before in this db...
with no problems. Why would this be happening now?
the back up copie works just fine.

Thanks for any help
Robin

.

Relevant Pages

  • Re: FATAL ERROR WHEN SENDING ACCESS REPORT TO PDF....
    ... ' Fill in the options for this switchboard page. ... Dim con As Object ... Compact the database to get completely rid of the Name AutoCorrect junk: ... > BTW, when Acrobat installs, it loads the Acrobat Assistant into your Windows ...
    (microsoft.public.access.reports)
  • File Format Problem - I think!
    ... I have been personalising the Microsoft Access 97 ... I converted my database file using the Access Tools → Database Utilities → ... ' Fill in the options for this switchboard page. ... Dim dbs As Database ...
    (microsoft.public.access.gettingstarted)
  • SQL Server
    ... After splitting the database and using the upsize wizard I received the ... following error from a popup window, run-time error '91': ... ' Fill in the options for this switchboard page. ... Dim rst As Recordset ...
    (microsoft.public.access.gettingstarted)
  • Visual Basic run-time error -2147221164 (80040154)
    ... of sub FillOptions ... it happends even if i start a blank database and create a new swichboard ... ' Fill in the options for this switchboard page. ... Dim con As Object ...
    (microsoft.public.access.gettingstarted)
  • Problem with Switchboard Form
    ... Dim rst As Recordset ... code says "Dim dbs As Database." ... >' Fill in the options for this switchboard page. ... > Dim rst As Recordset ...
    (microsoft.public.access.formscoding)