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
Post a Comment