Connections with the Excel and Access Database are preventing me from getting exclusive database -


i have access database users connecting excel files. have way of managing people logged on using access. however, not have way manage people connected database using excel. front in not worried data want able edit forms , add features.

splitting database help...https://support.office.com/en-ca/article/split-an-access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

but can making fe release users mde or accde file. these compile vba code , not allow users enter design mode change these files smaller , more secure.

then can make changes regular fe mdb or accdb files have, test changes , when ready release new version, publish them mde or accde files , copy on old version (or make ups first, , replace).


Comments

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

c# - "Newtonsoft.Json.JsonSerializationException unable to find constructor to use for types" error when deserializing class -