Solved

Securing Access 2007 Frontend

Posted on 2011-03-11
5
299 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:CMChalcraft
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:daveamour
ID: 35109279
Can you copy and paste the message?
0
 

Author Comment

by:CMChalcraft
ID: 35110232
Not easily. The message says "Microsoft Office Access was unable to create the.sccde, .mde or .ade file"
0
 
LVL 19

Accepted Solution

by:
daveamour earned 500 total points
ID: 35114718
Did you google that error message?
0
 

Author Closing Comment

by:CMChalcraft
ID: 35128601
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
 
LVL 19

Expert Comment

by:daveamour
ID: 35128993
Yes I saw that too, you must have read my mind!

Thanks for the points anyway.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question