Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    Guest

    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....
     
  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

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page