Hello all,
So this may be entirely my lack of understanding, but I can't figure out the following.
I am using Access 2007. I have developed a database that will be used in a workgroup environment by 3-4 computers. I will have no access to this network. All the PCs on this network uses Access 2007. The database will be placed in a shared folder on one of the PCs. I will need to split the database. But because I am not on this network and can not connect to this shared folder, how can I split the database on my computer with the proper Network Path of the shared folder and then give them a copy of the backend and front end instead of giving them the database as is and then guide them to split it?
Also, the users will have to have Read/Write access to this folder in order to used the backend of the database. I can convert the frontend to ACCDE, but not the backend. If the users can connect to this folder with Read/Write access, they will have access to an unsecured backend. Unless I don't know any better, how does this splitting provide and security for the data?
I have someone can help me understand this better.
Thanks