How to split Front end/Back end

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Ive read that what i need to do to my DB is split the front end and back end.
But no one really explains HOW to do it. I hope it doesnt have to be done
before you design the database as i already have A LOT of time and energy
into this one. I know the "back end" has to be stored on the shared drive
and the front end is copied onto each computer but how do you go about
actually splitting the database?
 
It isnt secured yet, but probably will be before it is finished. But seeing
as users wont have access to the tables is there a need for it to be secured?
It is a simple database but it is FDA required so it MUST be stable. I dont
want complete open access for most people. I want the ability to create a
new entry to be open, but the ability to modify current records secured to a
set list of people.
 
Gary said:
But seeing
as users wont have access to the tables is there a need for it to be
secured?
Click to expand...

If it's not secured then how are you denying your users access to the
tables? If you've set start-up options to hide the db window then a savvy
user can hold down the shift key on opening or press F11 to unhide it.

Keith.
www.keithwilby.co.uk
 
Right now this is in the complete design phase. No one is using it right
now. And I know the shift key method, but as I need a group of people to
have access rights to previously entered records to modify and update them to
be the only people who have that ability, and “all users†to have the ability
to create a new record…. I was just trying to get the multi-users aspect
worked out and all of the little kinks/quarks that the database has before I
go further with the security aspect of it.

I did test the splitting of the database and it worked perfectly.
Thank you very much.
 
Gary said:
Right now this is in the complete design phase. No one is using it right
now. And I know the shift key method, but as I need a group of people to
have access rights to previously entered records to modify and update them
to
be the only people who have that ability, and “all users†to have the
ability
to create a new record…. I was just trying to get the multi-users aspect
worked out and all of the little kinks/quarks that the database has before
I
go further with the security aspect of it.
Click to expand...

OK post back when you're ready for security. It's a pretty complex topic.
My web site has a couple of links to get you started.
I did test the splitting of the database and it worked perfectly.
Thank you very much.
Click to expand...

Splitting's pretty straightforward, security can bite you if you're not
careful! :)

Keith.
www.keithwilby.co.uk
 
Its not a matter of viewing the data, this data is fairly generic, but its a
matter of changing what has been entered. I need any user to be able to
create but only a few to be able to edit.
 
I appreciate everyone's help. I doubt that anyone here has the "know how" or
the desire to actually tamper with the info. I just wanted it safer in case
of accidents.
 
Gary said:
I appreciate everyone's help. I doubt that anyone here has the "know how"
or
the desire to actually tamper with the info. I just wanted it safer in
case
of accidents.
Click to expand...

Then ULS will serve your purpose mightily. To crack security you'd need to
be a hacker. In my organisation that would be a sacking offence so ULS is
perfectly adequate. I suspect that ULS is used in such scenarios all over
the place.

Keith.
www.keithwilby.co.uk
 
Back
Top