?
Solved

Compiled accde Access Database Still Showing Access Windows

Posted on 2010-08-30
16
Medium Priority
?
1,286 Views
Last Modified: 2013-11-29
I have an access 2007 database. I have split the front end and back end. I want to compile the front end. To do this I created an ACCDE file. However, when I open it, I still see Access in the background and the list of linked tables. What's going on here? Isn't there a way to have it open without seeing Access or at least not see the list of tables?
0
Comment
Question by:GoCubs
[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
16 Comments
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 664 total points
ID: 33563216
If you go into Access Options (from top left icon), and then go to current database, have a look at the options in there like navigation, ribbon etc
0
 
LVL 58
ID: 33563322
<<What's going on here? Isn't there a way to have it open without seeing Access or at least not see the list of tables? >>
"Compiling" into a MDE format doesn't do anything other then strip out the source code from your DB.  That's it.  The interface and what appears is totaly up to you.
JimD.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33564052
"Hiding" the Access application is a common question here.
There were many "workarounds" in the pre WinXP/Office 2007 days.

Unfortunately, I have not heard of any of these techniques working satisfactorily in Win XP and/or Office 2007.
(And I don't know if I would even try)

But if you are feeling dare-devilish, see here:
http://www.mvps.org/access/api/api0019.htm
(note: From the notes, it looks like this code was written around the time of Win 95/NT, so be warned...
;-)

A common suggestion by Expert LSMConsulting is to create your Front End with one of the newer Programing platforms, like VB.net.

There may be some "Wrapper" technology available though...

;-)

JeffCoachman
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33564540
<or at least not see the list of tables?>
You can do as rockiroads states to hide the "Navigation Pane"

But remember, you must consider what you are trying to protect against.

Are you trying to stop a casual user from seeing/accessing the tables?
If so, then hiding the Nav Pane will be fine.

However, for a "malicious" user, they can simply press the F11 Function key and re-open the Nav pane.
:-O
(Most casual users know this also)

Then you will need code to disable the F11 Function key.
Just be careful here, as the more you "Lock Down" the DB, the more you increase the chances of you locking yourself out of your own DB.

You would have more options regarding Security if your Database was in the 2003 format(.mdb), as User Level Security would still be available.
If your database is in the 2007 format (.accdb) then this is not available.

;-)

JeffCoachman
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 672 total points
ID: 33566284
<<But if you are feeling dare-devilish, see here:>>
The attached code seems to be a little less of a risk.  I've tested it and it seems to work well, but I have not used it in production as yet.
Don't know if it uses the same API calls that the code Jeff posted does or not.
This code was written by Drew Wukta from the Access-D list of the databaseadvisors.com
JimD.

HiddenAccess2k.zip
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 664 total points
ID: 33568149
Jim,

Yes, I also converted it to Access 2007/XP and it seemed to work OK.
(I can't vouch for Vista of Win7)

The only issue is that when you close the main form, then the Access application still becomes visible.
Also the well know technique of holding down shift while openig the DB still disables it.
That is what I meant by:
  "I have not heard of any of these techniques working satisfactorily"

I haven't seen anything that totally/reliably "Hides" the Access application...
And if you futz with it enough, you can still get it to go a little "Wonky"
(See screenshot)
And, for me at lease, I just get a little weary loading code in my apps that I don't totally understand, and still has drawbacks...

This may not be an issue for the asker though...

In any even, JIS looks like a good investment, .. I think I'll send them a check for a cool Mill...
;-)

Jeff
untitled.JPG
0
 
LVL 58
ID: 33568498
Jeff,
<<The only issue is that when you close the main form, then the Access application still becomes visible.>>
  That's because there is code in the unload event to make it so.  If you comment that out, the main access window is still hidden.
<<Also the well know technique of holding down shift while openig the DB still disables it.>>
  True, but if your locking down your app, your going to disable the shift key bypass anyway.
  I don't look at this as a security measure, but one of how to present an Access based app to a user.
Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33569311
OK,

Again, always, your insights are above reproach...
;-)

Jeff
0
 
LVL 58
ID: 33569428
<<
Again, always, your insights are above reproach...
>>
 
 Oh, I don't know if I'd go that far LOL, but thanks for the kind words anyway<g>
JimD.
0
 
LVL 58
ID: 33976874
I'd hate to see this one not make it into the PAQ.  I'd make it a 3 way split.
JimD.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33977478
Points to Jim as he posted a fully functioning sample that proves that this technique can be made to work in Acc2007
0
 
LVL 58
ID: 33977944
Jeff,
<<Yes, I also converted it to Access 2007/XP and it seemed to work OK.
(I can't vouch for Vista of Win7)
>>
  Yes, but your the one that tested it<g>.  And Rocki brought up the options.
 Every one of us brought something to the table.
 3 way split please.
JimD.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33978801
I'm feeling the love...

;-)

Jeff
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 34118845
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

718 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