check, create and link a table in BE?

[Frits1969]

Hello all,



I am using MS Access 2016.
I have a BE and FE. So all the tables are in the BE and the forms are in the FE.

I want from a form with VBA check if exists a table.
If it does not exist, I want to create it with VBA and then link it to the FE.

However, I have no idea how I can do this.

I like to hear it from more experienced Access users.

Thank you very much in advance,
Frits van Leeuwen

[CJ_London]

you need to open a copy of the backend in vba, create your new table, then add a linked table in the current database


to open a copy of the backend - see this link https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

to create the new table, see this link https://msdn.microsoft.com/en-us/lib...or=-2147217396

to create a link to the new table see this link https://msdn.microsoft.com/en-us/lib.../ff196455.aspx