Problem in Switching Import table to Link table

[kelvin24]

i am using pervasive database. first i imported the tables to test my query and it worked out ok. But now i want to use link table instead to have the updated data. so i delete the imported table and create a link table with the same name, but it is not showing anything now in the query.
please help me find out thank you.

kelvin

 

[Steve101]

Sounds strange indeed. When you open a linked table from the Access tables window, do you see the table's data? Do the field definitions conform with the data types you would expect to see. Doing these simple tests might help troubleshoot the problem.
Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[Darrylles]

Hi,

What's a pervasive database?

Have you opened the 'link' table and records exist in there?
If so, create a simple query that uses the link to pull out all records - does it work ok?

Are you sure that you haven't deleted the actual table records along the way?

Regards,

Darrylle







"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[DukeofEarl]

You have to delete all the tables in your client database, then import all the tables from the server. You can then use the tools->Add-ins->Linked Table Manager to update the server database.

DukeofEarl

 

[kelvin24]

I did a simple test by just selection few fields from the tables and it works out alright. Then i try to join them, it just kinda freeze. No sure if that is the problem. I am trying to do BillOfMaterial repot. here is a copy of my query code.
SELECT BMPRDSTR.PARENT_ITEM_NO AS Level1Parent, BMPRDSTR.COMPONENT_ITEM_NO AS Level1Component, BMPRDSTR.QTY_PER_PARENT AS Level1QTY_PER_PARENT, BMPRDSTR.SEQUENCE_NO AS Level1SEQ, BMPRDSTR_1.PARENT_ITEM_NO AS Level2Parent, BMPRDSTR_1.COMPONENT_ITEM_NO AS Level2Component, BMPRDSTR_1.QTY_PER_PARENT AS Level2QTY_PER_PARENT, BMPRDSTR_1.SEQUENCE_NO AS Level2SEQ, BMPRDSTR_2.PARENT_ITEM_NO AS Level3Parent, BMPRDSTR_2.COMPONENT_ITEM_NO AS Level3Component, BMPRDSTR_2.QTY_PER_PARENT AS Level3QTY_PER_PARENT, BMPRDSTR_2.SEQUENCE_NO AS Level3SEQ, BMPRDSTR_3.PARENT_ITEM_NO AS Level4Parent, BMPRDSTR_3.COMPONENT_ITEM_NO AS Level4Component, BMPRDSTR_3.QTY_PER_PARENT AS Level4QTY_PER_PARENT, BMPRDSTR_3.SEQUENCE_NO AS Level4SEQ, BMPRDSTR_4.PARENT_ITEM_NO AS Level5Parent, BMPRDSTR_4.COMPONENT_ITEM_NO AS Level5Component, BMPRDSTR_4.QTY_PER_PARENT AS Level5QTY_PER_PARENT, BMPRDSTR_4.SEQUENCE_NO AS Level5SEQ
FROM (((BMPRDSTR LEFT JOIN BMPRDSTR AS BMPRDSTR_1 ON BMPRDSTR.COMPONENT_ITEM_NO = BMPRDSTR_1.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_2 ON BMPRDSTR_1.COMPONENT_ITEM_NO = BMPRDSTR_2.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_3 ON BMPRDSTR_2.COMPONENT_ITEM_NO = BMPRDSTR_3.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_4 ON BMPRDSTR_3.COMPONENT_ITEM_NO = BMPRDSTR_4.PARENT_ITEM_NO
WHERE (((BMPRDSTR.PARENT_ITEM_NO) Like "br*&quot)
ORDER BY BMPRDSTR.PARENT_ITEM_NO;