Can I get the field names of a table in an external access file through VBA as strings?
When I need to store some data for VBA only (user doesnt need to know about it), and don't want to use external files. Is it most appropriate to store that data in tables and read it using sql the next time i need that data. If so, is there a way to prevent this table from being altered/deleted. (I will separate by back and front end eventually anyway)
If I want users to be able to simultaneously edit the database (down to record level), is there anything I need to do? Or just place it in a networked folder?
This post has been edited by Mylo: 13 July 2012 - 08:19 AM