Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Securing Access 2007 Frontend

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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

580 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