Link tables programatically

[Tsango]

Is it possible to unlink and link to tables in a back end using VBA in the front end?

I need to do this or something similar because when I send updates of the front end out I may have added an extra table and thus want to be able to get the user to run an update module to link any new tables.

Not sure if this is at all possible???

Any ideas???

 

[KeithG]

Are you saying when you create a new table in the back end you want to make a procedure to link it to the front ends? Are you familar with the tableDef object?

 

[Kelemit]

DoCmd.TransferDatabase acLink, "Microsoft Access", "PathToDB\Name.mdb", acTable, "NameofTableinBE", "NameofTableinFE"

 

[Tsango]

Are you saying when you create a new table in the back end you want to make a procedure to link it to the front ends? Are you familar with the tableDef object?

Thanks for the reply.

What I will need to do is maybe create a table in the backend programatically from the frontend. That table will then need linking.

This is purely so I can send out updates to clients allowing them to run an update routine from the frontend so they need not get involved with linking ect.

 

[Tsango]

DoCmd.TransferDatabase acLink, "Microsoft Access", "PathToDB\Name.mdb", acTable, "NameofTableinBE", "NameofTableinFE"

Superb!! Thank very much...

 

[andysgirl8800]

that's a great bit of code, but where would you put it? what if you have more than one table you want to update at the same time?