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



@ Amy,
your solution worked. By accident I had a D:/ volume on my computer as
well...

Thank you very much for the hint!

@ Tim Ferguson
Thank you very much for your script, too. I am happy that it works now.


Am 22.11.2005 18:24 Uhr schrieb "Amy Blankenship" unter
<Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> in
#jOyVm47FHA.3592@xxxxxxxxxxxxxxxxxxxx:

> I think what you'll have to do is throw an ASP page on the server that does
> Response.Write Server.MapPath("somefile")
>
> Use that to figure out what directory structure you'll need, then duplicate
> that on your local machine. Now, open the database in that new directory
> and relink all the files.
>
> When you upload the files, everything should work.
>
> I think it's silly myself that they don't make relative linking easier, but
> what do I know.
>
> HTH;
>
> Amy
>
> "Hyko" <none@xxxxxxxxxxxxxxxxx> wrote in message
> news:BFA90D5C.7C8E%none@xxxxxxxxxxxxxxxxxxxx
>> Hello.
>>
>> 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.
>>
>> How can I change the path of the connected table so that it is relative
>> (both DBs are in the same directory)? Or how can I change the path at all
>> before I upload it to the server where I cannot influence it anymore?
>>
>> Or is there any other possibility to link this table e.g. by System-DSN?
>> As
>> far as I tried it now it is not possible that way.
>>
>> Thanks in advance for any hints or suggestions,
>>
>> Heiko
>>
>
>


.



Relevant Pages

  • Re: PHP, Md5, and password retreival forms..
    ... I hired a guy to help me setup the database. ... random string in the "reset" column of the same row perhaps, ... and a hint which can be stored in a new "hint" column ...
    (comp.lang.php)
  • RE: 2003 to 97
    ... Thanks a lot Amy -- that sounds exactly like what I would ... >Database Utilities, Convert Database, to Access 97 File ... >respond back to this posting. ... confers no rights. ...
    (microsoft.public.access.conversion)
  • Re: How to display Proper Case in Access 2.0
    ... >Hi Amy, ... >application, in the Database window, click the Modules ... the conversion can ... >> character should ...
    (microsoft.public.access.reports)
  • Re: performance questions and help!
    ... and try to learn and understanding the concepts. ... If you can just give me a hint or just help me to find out ...  You determine that it is a single SQL statement that is slow, ... your user for how to identify how the database is processing the SQL ...
    (comp.databases.oracle.server)
  • Re: MySql +DBI problem
    ... $query=new CGI; ... undef $ln; ... # Disconnect from the database. ... 141 (hint, hint). ...
    (comp.lang.perl.misc)