Visitor registry with signatures in access ?

[June7]

Excel macros (actually VBA code) would not transfer easily to Access. Processing logic may be same but references will be completely different.

Signatures would be an image file. Images can be saved in Attachment type field. However, saving images into file (whether Excel or Access) increases file size and can slow performance. Depends how many records will accumulate. Access has a 2GB file size limit. Alternative is to save signature file in folder and save filepath to text field.

Locking stuff would be an issue in Excel or Access but maybe easier in Access to restrict user privileges.

I am not certain about sharing file on OneDrive. Will multiple users interact simultaneously? OneDrive is not feasible for that scenario. A multi-user database should be split design with each user running frontend on their local machine linking to backend which should be on a file server.

Data management is easier in Access.

Device must run Windows.

Review https://www.youtube.com/watch?v=m3IMLn11j90