Solved

Securing Access 2007 Frontend

Posted on 2011-03-11
5
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
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 …

728 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