How to link access tables to back end copy through VBA

[rahul2310]

i already know the path of back end database and want to link tables in front end with back end through VBA.
Which will occur in start up form

[zmbd]

rahul2310
There are a ton of these scripts out there, just search using ms access relink backend

Here one such code: http://bytes.com/topic/access/insigh...-access-2003-a

I have one that checks for the backend, versions, relinks, offers a dialog box if the backend can't be found that I honestly cobbled a bunch of different versions from the net togeither to do what I wanted.

If you will post your work with a specfic question/issue we can go from there.