Linked tables

[pwicr]

I have imported a linked table into the BE of another database. I have a calculated field that is Right (CHVIN, 6) which

CHVIN PK 17 digits
CHSHORT 6 digits - Right(CHVIN,6) which pulls the last 6 digits from CHVIN

CHSHORT works fine in original DB
but
as a linked table it comes up as #invalid.

???

 

[pwicr]

I had closed the databases...just opened the one that has the linked table

"Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5

*To ensure that your database or project works properly, you must fix this reference."

under help...

"
The application you are attempting to use has a reference that it cannot resolve to an object, type library, DLL, or external database. Either the object, type library, DLL, or database was deleted or renamed. Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required. If you did not create this application, contact the programmer or administrator of the system.
If the reference listed in the Available references list is preceded with "MISSING:" clear the check box to remove the reference if it is no longer required. If you still need to use the reference, clear the check box entry for "MISSING: <referencename>" in the Available references list, and then create a new reference to the file using the Browse... button. If this is an installed database application, you may need to reinstall or repair the application."

 

[Cronk]

Google it to get instructions on how to how to re-register it.

I got lost on your first post. Are you saying your FE has a link to a table in your BE that is a link to a table actually residing in another database file?