Link Table

[Guest]

Hi,
I linked a table to my access database from another access database. I went
to File menu->Get external data-> Link Table and then I showed the path of
table and then Access created an icon of linked table on my database.
Everything is ok up to now but when new records added to the linked table my
access database doesnt update my linked table so new records doesnt show up
on my database which cause missing information on my database. Souldnt it
happen automatically?? What can cause that problem?

 

[Guest]

Have you made any design changes (ie. add fields, set primary key,
add/remove/change indexes, etc.) to the linked table? If so, delete the table
link in your front-end database, compact the database, and then re-create the
link from scratch.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks for everything but I fixed the problem. I used link table manager and
checked the Always prompt for new location option and it worked.
Anyway..thanks again