How to hand over Access DB to "client"?

[SueBwork]

I have been working on an Access Db for awhile and am very close to being ready to hand it over to the person who requested it. There will be one user and the db will reside on a desktop PC.

Here's my dillemma? How do I insure that the user will not have access to the tables? I'd hate for her to get curious and go in and "muck around" with the data. I have the db split and have logic to disable the "shiftkey bypass" on open. I plan to, also, convert the front-end mdb to a front-end mde. However, what do I do with the back-end (tables)? Is there a way to protect them?

I would like to keep the db split (front-end/back-end) so if modifications are required in the future (to the screens/reports/processing), I can just send her a new front-end (I have the 'relink' logic in place on initial launching of application).

Any ideas for protecting the tables?

Thank you.

Regards,
SueB

 

[Pat Hartman]

Your only alternative is to use Access security. Securing the be is a little more complex than just securing the fe. There is a book that is devoted to Access security (search Amazon.com). It might be worth seeing if it offers a suggestion.

 

[Oldsoftboss]

Is this http://www.amazon.com/exec/obidos/t...104-6011248-0276701?v=glance&s=books&n=507846 the one you are referring to Pat?

Dave

 

[richary]

Obviously I don't know the details between you and your client, but don't forget that in the final analysis they have paid you for your efforts in setting the db up and it is presumably their data that is stored, so to restrict the clients access to their own data seems to be overly restrictive.

Perhaps putting in enough security to prevent casual users would be sufficient?

 

[Oldsoftboss]

Just remind them you are available for ongoing updates (read hacking repairs) for an hourly rate

 

[Pat Hartman]

Yes Dave, that was it.

 

[Oldsoftboss]

Traced it to an Australian distributor, want about $130.00 for it. :-(

Dave

 

[Pat Hartman]

Will Amazon ship it to you? If they won't, let me know and I'll find out what shipping actually costs from the US and even send it to you if you want.

 

[Oldsoftboss]

Thanks Pat, will let you know.