Updating Report Links in MS-Access database.

Hi,

I am a new bee to .NET.

I have a Ms-Acess Database which is protected by password. This table contains tables, queries and reports. One more database contains links(references to the first database). If any table structure is changed in the first table, in order to update links I need to manually open database and Tools->Database Utilities -> Link Table Manager from the second database.

I want a solution which automatically updates all these links by using either VC#.NET or VB.NET or VB6.0

Please help me, it is urgent.

Thank you..,

[637 byte] By [AndyRogers] at [2008-3-6]

«« Wish to use text box to only allow numeric Data entry
»» Accessing work itens via web (license question)

# 1

You still need to use ADO/ADOX (or DAO) to refresh table links. See the following:

How To Use ADO to Refresh/Create Linked Table for Password Secured Jet 4.0 Database

PaulPClementIV at 2007-8-31 >