Accessing Access from Explorer by Kim

[kpalazzi]

I have an Access database with forms saved as web pages.&nbsp;&nbsp;I have an intranet.&nbsp;&nbsp;I saved these forms in Frontpage and use hyperlinks from my intranet to access forms.&nbsp;&nbsp;I use a workgroup file with my database.&nbsp;&nbsp;This worked fine for a while.&nbsp;&nbsp;Today I tried to go to Employee Directory which is an Access web page and could not connect or initialize access.&nbsp;&nbsp;The error says my workgroup file is missing or opened exclusively by someone else.&nbsp;&nbsp;Help!!<br><br>I tried replacing with a back-up.<br><br>Kim

 

[Amiel]

<br>Kim,<br><br>It has been my experience that Jet(*.mdb) files can be a nuisance in a web delivery situation! Several things to consider: <br><br>1)Users must have read/write access to the folder where the mdb resides. This is the likely cause of your problem.<br><br>2) Users can't use DAO to manipulate the contents of the .mdb safely under IIS. If you use .asp's, using <b> Server.CreateObject</b>.&nbsp;&nbsp;... server, will corrupt the mdb file in no time! Hope this <i>isn't</i> the nature of your problem.<br><br>Check the permissions on the folder where the mdb resides. Delete the .ldb file (you may have to pause the site for this) and hopefully you'll be ok.<br><br>Remember to use ADO to manipulate your Jet (*.mdb) data files !<br><br>Have fun . <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>