Database appears "hidden" upon using internet link.

#1 (**permalink**) 28-Jul-2006, 08:09 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10061-database-appears-hidden-upon-using-internet.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10061
you may have in your reply.

Thanks for any help you can give....

#2 (**permalink**) 28-Jul-2006, 08:10 AM

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/mu...lications.html
>
>
> Tom Wickerath
> Microsoft Access MVP
>
> http://www.access.qbuilt.com/html/ex...tributors.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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10061
> > employees to access the database they click on a link via our intranet. The
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10061
> > 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....