Database appears "hidden" upon using internet link.

[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
__________________________________________

 

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

 

[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

 

[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