Solved Create table by VBA in accde

[JohnPapa]

People with no experience read these replies. I hope none will make the mistake of sharing the FE because you are advising them to put shared data in an FE rather than in the BE where it belongs.

Thanks for the participation so far. I don't believe I can add anything else to the discussion.

I apologize for being unable to explain a simple thing.

1) In the FE you can have data common to all clients. You can have this data stored in the BE, but since it is not specific to a specific client and does not change, the FE is preferable to the BE. As an example, you can store all the graphics/pictures used by all clients.
2) You can also have in the FE temporary tables that can be used by each client to easily manipulate and create forms and reports. Usually when you use a temporary table it is cleared and then filled in with the client's data during the process of creating a form or report.