Re: Can I set relative paths for linked tables instead of absolute path?
- From: "Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 11:24:19 -0600
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
>
.
- Follow-Ups:
- References:
- Prev by Date: Can I set relative paths for linked tables instead of absolute path?
- Next by Date: Re: How to biuld a coursescheduling database
- Previous by thread: Can I set relative paths for linked tables instead of absolute path?
- Next by thread: Re: Can I set relative paths for linked tables instead of absolute path?
- Index(es):
Relevant Pages
|
