Welcome to SPN

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

Sign Up Now!

Database appears "hidden" upon using internet link.

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

  1. Brent

    Brent
    Expand Collapse
    Guest

    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

  3. Brent

    Brent
    Expand Collapse
    Guest

    Tom,

    Thanks for the reply. To give you a bit of background I was able to create
    the file already split into BE and FE versions. Both are located on the
    company's shared drive, in different locations. Unfortunately the way that I
    have the employees access the database is a necessity as the employees do not
    have access to their hard drives on the computers for security reasons. We
    have multiple shared drives, with access severely limited to only individuals
    who are given access to a given drive. Our employees all have access to the
    same shared drive. Also, they do not have desktop access so the intranet
    link was the best option we had.

    I hope this clears things up,
    Thanks


    "Tom Wickerath" wrote:

    > 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
    > browser.
    >
    > Implementing a Successful Multiuser Access/JET Application
    > http://www.access.qbuilt.com/html/multiuser_applications.html
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "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....
     

Share This Page