Solved

Compiled accde Access Database Still Showing Access Windows

Posted on 2010-08-30
16
1,237 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 166 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 168 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 166 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 92

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

729 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