security troubleshooting

[Joan Wild]

I finally got it to work with the login prompting my other
co-workers. Down to the last questions. The frontend is on the
server (which you all have advised against doing so I will
re-evaluate). Now the original, backend, and frontend are on the
server. I have my team that can make edits and others that can read
only. My question is when my team is making changes should they
update the original database (and will that update the frontend)? Or
should they update the frontend (and will that update the original)?

Neither of those will happen. I would just delete the original (back it up
if you like). Any changes they make in the frontend can be saved in the
frontend. However, you will find that in order to make design changes,
they'll need exclusive access to the frontend (yet another reason to split).

If you are referring to data changes (rather than design changes), any
editting they do via the frontend will be saved in the backend.

 

[Guest]

Isn't the front end the shortcut to the original that is linked to the
backend? So I couldn't delete the original b/c my target wouldn't be right.
My target is below and works fine - the DATABASE.mdb is the original database
with the backend linked or am I still missing something? I truly am sorry
for my lack of knowledge on this.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\Corp.global.level3.com\dfs01\ssidata\ssiamfile1\data\DeptShares\Contracts\DATABASE.mdb"
/WRKGRP
"\\Corp.global.level3.com\dfs01\ssidata\ssiamfile1\data\DeptShares\Contracts\Security Wrkgrp File.mdw"

 

[Joan Wild]

Isn't the front end the shortcut to the original that is linked to the
backend? So I couldn't delete the original b/c my target wouldn't be
right.

The original I assume to be the original mdb before you split it. The
frontend contains everything except the tables/relationships. The backend
contains just the tables/relationships. The frontend shows 'linked tables'
on the tables tab, meaning there are links to the tables in the backend.

Your shortcut should point to the frontend (which when opened will have
links to the tables in the backend).