Re: Opening mdb from file link

Tech-Archive recommends: Fix windows errors by optimizing your registry

The .mdb file has an associated .ldb (?) file which is not located on the
sharepoint site. I think that's the reason I've seen elswhere as to why you
can't access an .mdb file from a sharepoint site.

Removing .mdb files from the list of banned files only means you can upload
a .mdb file to a sharepoint site. Nothing more.

Manfred

<jwillard@xxxxxxxxxxxxxxxxx> wrote in message
news:#bKVEdqZFHA.3364@xxxxxxxxxxxxxxxxxxxxxxx
> I posted this in the access group as well, but have not gotten a response.
> Any help here?
>
> I have an access database (xxxxx.mbd) located on a file share and
> hyperlinked from a sharepoint team site (2003) with a URL
> "file://servername/share/xxx.mdb. When I click on the link in the IE
window,
> Access (2003) begins to start, gives the unsafe code warning, and then
> stops. I can see and kill the MSACCESS process in task manager. If I cut
> and paste the URL into the run window, the application opens fine. Since
the
> file association is correct, I do not see that KB 162059 applies. I have
> also tried adding the *.mdb extension to the list of permitted file types,
> all to no avail. Finally, there was a space in the access filename, which
I
> eliminated, with no change.
>
> All I can figure now is that the application is opening an "mdb" file that
> runs an autoexec form when the database opens. There is also a linked mde
> and some tables in another access file. Does anyone have any idea whether
> this would stop the file from opening from Sharepoint? Or is there
something
> else inherent in opening an Access database from sharepoint?
>
> Thanks.
> J. Willard
> VA Dept of Transportation
>
>
>


.

Relevant Pages

  • Re: Opening mdb from file link
    ... It is not actually a WSS/SPS limitation but you cannot open a MDB file over ... You should not have a problem with storing a MDB on SharePoint, ... > can't access an .mdb file from a sharepoint site. ... >> and paste the URL into the run window, the application opens fine. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: adding .mdb files to WSS - Is this a no-no?
    ... will adding this .mdb file create problems for my sharepoint site? ... "Ian Morrish" wrote: ... > The reason for blocking them is because Access supports multi user access to ...
    (microsoft.public.sharepoint.windowsservices)
  • Access and Sharepoint
    ... I have an existing Access DB that will have multiple users. ... If I store the. ... mdb file on a Sharepoint site, can multiple users open the .mdb file ...
    (microsoft.public.access.gettingstarted)
  • Re: Problem with modal/popup form
    ... opening the database. ... This combination means that I can no longer get to design mode for the ... Is there any way that I can patch the .mdb file to remove ... Hold the shift key while opening the file. ...
    (microsoft.public.access.modulesdaovba)
  • Thank U !! - Re: Access looks for a particular drive.
    ... The suggestions you offered were of great and instant help. ... > locate the .mdb file in the first place. ... >>A colleague was programming our Access database before I was asked to ... >> few changes on it because we changed PCs. ...
    (microsoft.public.access.forms)