Securing Access 2007 Frontend

I have a fairly complex Access 2007 frontend the links back to Microsoft SQL Server Express. I want to release this frontend to one of our satellite offices so that they can update some of the information rather than have them e-mail the information to Head Office where it is rekeyed.

I have tried to secure the database by using the "Make ACCDE". However this fails. The message suggest this is because the Frontend is too complex. Is there any other way I can prevent Users from getting into the background? All I want to do is to prevent an "intelligent" user from access to the underlying data tables.

Thanks

Chris C
CMChalcraftFinance DirectorAsked:
Who is Participating?
 
daveamourConnect With a Mentor Commented:
Did you google that error message?
0
 
daveamourCommented:
Can you copy and paste the message?
0
 
CMChalcraftFinance DirectorAuthor Commented:
Not easily. The message says "Microsoft Office Access was unable to create the.sccde, .mde or .ade file"
0
 
CMChalcraftFinance DirectorAuthor Commented:
That was a good tip.

In short this was a misleading message. You have to elimiante the errors in the Modules and it will then create an ACCDE file. Which I have done.

Thanks for your help.

Regards

ChrisC
0
 
daveamourCommented:
Yes I saw that too, you must have read my mind!

Thanks for the points anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.