strange error msgs after moving database to server

M

Maggie

hi,
Aftermoving the adp database to a server, I opened up my ade project and on
my main screen, I have the option of going directly to the
tables,queries,etc. When I do that, I get the error message :"MS office cant
find the table "clients" you referenced in the Object Name argument".

Funny thing is that after I get the message, I can open it up again and it
goes right to the database view.
I didnt get this until after I created the ADE. I looked at the code that
was there for this event (display database window ) and here's what is there
:
*************
strDocName = "Clients"

' Close Main Switchboard form.
DoCmd.Close

' Give focus to Database window; select Clients table (first
' form in list).
DoCmd.SelectObject acTable, strDocName, True
*****************
There is a table called "Clients", so I am not sure what it doesnt like
here. I think I understand what it's doing, but I also am not sure why it is
necessary. What do you think?
 
Top