Re: Can I set relative paths for linked tables instead of absolute path?

I don't think that would work, because a web application does not have a
"front end" as you are used to thinking of it, and usually the server either
won't have Access installed or you can't get Remote Desktop or other similar
way to run the Access file to get it to connect itself. So you need to make
sure the connection is pointed correctly before you upload.

Hope this clarifies;

Amy

"Tim Ferguson" <FergusonTG@xxxxxxxxxxxx> wrote in message
news:Xns9716C1DC1CF97garbleme4455656@xxxxxxxxxxxxxxxx
> Hyko <none@xxxxxxxxxxxxxxxxx> wrote in
> news:BFA90D5C.7C8E%none@xxxxxxxxxxxxxxxxx:
>
>> If I link a table to my Access DB from another Access DB the absolute
>> path to this DB is used. When I upload the database to the server,
>> where I use the databases as data source for a web application it
>> cannot find this path of course.
>>
>
> As long as the (front end) mdb knows, or can find out, the site of the
> back end file, you can write a short subroutine that will update the
> .connect property of the relevant tabledefs:
>
> strConnect = ";DATABASE=" & strPathToMDBFile
> For p = 0 To db.TableDefs.Count - 1
> Set tdf = db.TableDefs(p)
> If tdf.Attributes And DB_ATTACHEDTABLE Then
> If tdf.Connect <> strConnect Then
> tdf.Connect = strConnect
> tdf.RefreshLink
> End If
> End If
> Next p
>
> Note that this is uses the DAO library: it's probably possible using ADOX
> but I can't imagine why anyone would want to...
>
> All the best
>
>
> Tim F
>


.

Relevant Pages

  • Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
    ... The new Sql Server 2005 is supposed to be great for storing files! ... >> Are you trying to store the file in your Access database? ... >>> In my Web App i have an upload feature and I've discovered that if i ... >>> spent writing to the Access Database.. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Document mangment in .net
    ... user will upload the document form here. ... uploaded from the client to the webserver server over a webservice. ... the user machine and database sitting on the webserver and webservices being ...
    (microsoft.public.dotnet.framework)
  • Re: Updating DB Locally
    ... >> have that update the database that's on the server. ... >> entries before I can import the text file to the server. ... the new version that I would want to upload would ...
    (comp.lang.php)
  • Re: photo popup that changes size depending on pic?
    ... you would have to check the width and height of each image before you upload via FTP to the ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... problem with the server, but the people who "work" at the server do not know anything about it. ... > So, I create a Database results region on the page, insert a picture in there. ...
    (microsoft.public.frontpage.client)
  • Re: Setting up Linked server to MsAccess
    ... SQl Express has linked server X mapped via UNC to Database X.mdb ... Access File as a Linked server, however, it only works for 'some' of the ... group with full permissions to to folder, so the problem does not appear ...
    (microsoft.public.sqlserver.security)
Loading