Hey guys, I’m in a unique situation.
I want to develop a new access db program for my work. I have some random limitations and concerns. Not sure which is best and was hoping for some feedback.
We have a all Dept shared folder that everyone has access to, and each Dept has their own shared folder only people from that Dept has access to.
I want to save and access file attachments, some of which can be sensitive and don’t want anyone to them.
A. If I have the be saved on the all Dept shared drive and the folders for each attachment with a link to the file path, anyone can open them. I don’t want someone to surf the folder and circumnavigate any viewing controls I build in. Is there a way to encrypt the file so only access can open them? So they are saved externally but only access can open it?
B. If I store them in the db, I can control viewing permission. I can keep them safe and put a password on the be so no one can surf attachments in the all Dept shared folder. I know it would then run slower and I’m worried if in a few years, it may get too big. I was thinking of saving each large attachment in its own password protected be db, if the file does not need to be accessed, would the fe run fast as if it wasn’t connected to the be? Would it only slow down when trying to open one of the be db (or run a query)? Or would it run just as slow as one large db when connected to 5-6 be db.
C. if I have a query built on side going to multiple be, will it run if no open form needs the info?
random question I always wondered that may affect this, when you have the queries built Are they running in the background or do they only run when called or opened?
For example I have two fe db. Both connected to the same be. One has 50 queries, one has 1 query. Will they both perform at same speed to open the same form? I was thinking of only using the vba run sql to fill forms. Is it worth the effort? Would it make the db faster or would I only be able to brag about coding all the queries? Cuz I don’t need to brag, and noone would understand cuz noone knows how to code hahaha.
I want to develop a new access db program for my work. I have some random limitations and concerns. Not sure which is best and was hoping for some feedback.
We have a all Dept shared folder that everyone has access to, and each Dept has their own shared folder only people from that Dept has access to.
I want to save and access file attachments, some of which can be sensitive and don’t want anyone to them.
A. If I have the be saved on the all Dept shared drive and the folders for each attachment with a link to the file path, anyone can open them. I don’t want someone to surf the folder and circumnavigate any viewing controls I build in. Is there a way to encrypt the file so only access can open them? So they are saved externally but only access can open it?
B. If I store them in the db, I can control viewing permission. I can keep them safe and put a password on the be so no one can surf attachments in the all Dept shared folder. I know it would then run slower and I’m worried if in a few years, it may get too big. I was thinking of saving each large attachment in its own password protected be db, if the file does not need to be accessed, would the fe run fast as if it wasn’t connected to the be? Would it only slow down when trying to open one of the be db (or run a query)? Or would it run just as slow as one large db when connected to 5-6 be db.
C. if I have a query built on side going to multiple be, will it run if no open form needs the info?
random question I always wondered that may affect this, when you have the queries built Are they running in the background or do they only run when called or opened?
For example I have two fe db. Both connected to the same be. One has 50 queries, one has 1 query. Will they both perform at same speed to open the same form? I was thinking of only using the vba run sql to fill forms. Is it worth the effort? Would it make the db faster or would I only be able to brag about coding all the queries? Cuz I don’t need to brag, and noone would understand cuz noone knows how to code hahaha.