Disconnect and connect table backend

[Vulcan1500]

Due to a modification I need to add a column to a table of the backend of my database with code in the frontend. After distributing the frontend and on opening it will modify the table by the users who all work stand-alone. The name of the backend is with all users the same. Due to the backend being linked I need to disconnect the specific table first, add the column and connect the table again. Can one of you help me with the code to disconnect and connect a table of a backend?

 

[Banana]

Is that a one time go?

If so, you can just ask your users to log off to make edits.

If you will need to do it again in future, look up "kicking off users" in this forum using the Search on navigation bar near to the top. You would have to quit each copy of Front-End anyway because AFAICT, Access will cache the connection for the linked tables, and will behave weirdly if you try to close that connection created by Access.