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

 

[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

 

[Oldsoftboss]

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

Dave

 

[Oldsoftboss]

Thanks Pat, will let you know.