Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Database appears "hidden" upon using internet link.

Discussion in 'Information Technology' started by Tom Wickerath, Jul 28, 2006.

  1. Tom Wickerath

    Tom Wickerath
    Expand Collapse

    Hi Brent,

    It is never a good idea to share an entire Access application. Microsoft
    personnel on the Access team have previously identified sharing an entire
    database as the number one cause of JET database corruption. The application
    should be split into two .mdb files: a front-end (FE) and back-end (BE) file.
    A copy of the FE file should be placed on each users local hard drive. The BE
    file, which contains the tables with the shared data, is placed on the file
    server. With this type of arrangement, there is no need to involve a web

    Implementing a Successful Multiuser Access/JET Application

    Tom Wickerath
    Microsoft Access MVP


    "Brent" wrote:

    > I have an Access Database in which I have just added a hidden form that will
    > be opened upon entering the database. I did this via an AutoExec macro. For
    > employees to access the database they click on a link via our intranet. The
    > link is extremely simple, it is just the path to the database file via our
    > shared drive. Here is where it gets strange: when I access the database
    > through windows everything works perfectly. When the link is used the
    > database appears to be open but nothing can be seen. It almost appears as if
    > the entire database becomes "hidden" for some reason when the link is used.
    > Does anyone know why this would be happening?
    > PS. Beware I am a novice Access user. I have been figuring everything out
    > on my own and may not be able to answer some of your more technical questions
    > you may have in your reply.
    > Thanks for any help you can give....
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004
    UK Surrey Man Appears on 'Regis and Kelly' with Longest Beard Breaking News Sep 21, 2011

Share This Page