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

[MasterBash]

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

Alright, I will be reading about references.

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.

If it is saved in the same folder with a link to the filepath (automatically), then that is okay.

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

From what I read, it shouldn't be very hard to lock an Excel file and force it to run full screen/disable shortcut keys. No idea about Access - I will read more about it.

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.

Multiple users will have the file open, but they will rarely interact with it.. Entries will come from the graphical tablet and visitors will fill the information. The only thing we will be doing is entering the "Time of departure" and maybe correcting some mistakes that visitors make while filling the registry. This can be done on the pc (graphic device plugged to a windows pc). I will ask the IT teams what alternative do we have. I know we also use SharePoint...

I wonder if that is one of the reasons why we keep using Excel, even for databases, because it is easy for multiple users to interact with it.

Data management is easier in Access.

Device must run Windows.

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

Agreed and the device will be running Windows.