Converted Database

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I converted our work database from 97 to 2002. The only
errors I received were "Error Description
Microsoft Access was unable to refresh the linked
table 'Accounts' in database '\\Server\DB\Backend.mdb'
during conversion. Try and refresh the links manually by
using the Linked Table Manager (Tools menu, Database
Utilities submenu).."

I did so and successful refreshed the links. From a form
we designed there is a button to find an account. When I
type in the account name for query - it says "this
account name does not exist in the database" when it does
when I look at the table.

I spent three hours looking at the macros and queries and
can't find the problem. Please help.

Sincerely,
Sara
 
It is possible that in the conversion your find account button didn't
compile correctly or somehow became corrupted. Open the form in question
into the VB code editor and reissue a compile on your database. If there are
any missing references or problems with code you will not compile and should
be sent to the offending line of code. If this happens open Tools |
References while in the VB code editor and look for any MISSING references.
Find the reference in the list below or you may have to locate it under your
Windows | System or System32 folders.
 
Back
Top