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..,

[622 byte] By [AndyRogers] at [2008-3-7]
# 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-10-8 > top of Msdn Tech,Visual Basic,Visual Basic Interop and Upgrade...
# 2
Thanks Paul for reply.
AndyRogers at 2007-10-8 > top of Msdn Tech,Visual Basic,Visual Basic Interop and Upgrade...