Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Securing Access 2007 Frontend

Posted on 2011-03-11
5
Medium Priority
?
314 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

972 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