Problem - absolute path to linked tables

I hope someone can help with this.

I have a website using Access and ASP developed on my own PC (using PWS) and
hosted on a commercial site.

I decided that splitting the dbase up would be a good management tactic; it
si easy to link from the main database and it works fine - on my own
machine.

Trouble is when I upload to the commercial host, it takes with it the
ABSOLUTE path of the linked database -which of course is different on the
website machine. If it used relative refs it would be fine but....

Does anyone know how to overcome this?

John Lewis

re: Problem - absolute path to linked tables

"John Lewis" <john@cocreation.co.uk> wrote in message
news:bnjhkr$dmk$1@news6.svr.pol.co.uk...[color=blue]
> I hope someone can help with this.
>
> I have a website using Access and ASP developed on my own PC (using PWS)[/color]
and[color=blue]
> hosted on a commercial site.
>
> I decided that splitting the dbase up would be a good management tactic;[/color]
it[color=blue]
> si easy to link from the main database and it works fine - on my own
> machine.
>
> Trouble is when I upload to the commercial host, it takes with it the
> ABSOLUTE path of the linked database -which of course is different on the
> website machine. If it used relative refs it would be fine but....
>
> Does anyone know how to overcome this?
>
> John Lewis[/color]


I don't understand. Normally, in this newsgroup, "splitting" an Access
database means making two parts to the database: the back end contains the
data (tables only) and the front end contains everything else (forms,
reports, modules, etc). This is to keep the user interface separate from
the data. However, if you have developed an ASP site - the ASP pages are
the user interface - or do you mean you have more than one interface to
access the same data?

It looks like more of a simple ASP question not really for this newsgroup -
but your answer could lie in specifying
Server.MapPath("MyDb.mdb")
rather than "C:\MyData\MyDb.mdb")

Fletcher

re: Problem - absolute path to linked tables

Thanks Flectcher; you are quite right, splitting does have a specific
meaning -my apologies for sloppy language.

What I should have said is that I am using linked tables as a means to,
errm, separate a single database into smaller chunks. This is for management
reasons - downloading a file of 10 MB is a drag!

I never refer to the path in ASP; the linking is transparent, entirely
inside Access.

So I'm still stuck for an answer.

John


"Fletcher Arnold" <fletch@home.com> wrote in message
news:bnjj5u$ltj$1@titan.btinternet.com...[color=blue]
> "John Lewis" <john@cocreation.co.uk> wrote in message
> news:bnjhkr$dmk$1@news6.svr.pol.co.uk...[color=green]
> > I hope someone can help with this.
> >
> > I have a website using Access and ASP developed on my own PC (using PWS)[/color]
> and[color=green]
> > hosted on a commercial site.
> >
> > I decided that splitting the dbase up would be a good management tactic;[/color]
> it[color=green]
> > si easy to link from the main database and it works fine - on my own
> > machine.
> >
> > Trouble is when I upload to the commercial host, it takes with it the
> > ABSOLUTE path of the linked database -which of course is different on[/color][/color]
the[color=blue][color=green]
> > website machine. If it used relative refs it would be fine but....
> >
> > Does anyone know how to overcome this?
> >
> > John Lewis[/color]
>
>
> I don't understand. Normally, in this newsgroup, "splitting" an Access
> database means making two parts to the database: the back end contains[/color]
the[color=blue]
> data (tables only) and the front end contains everything else (forms,
> reports, modules, etc). This is to keep the user interface separate from
> the data. However, if you have developed an ASP site - the ASP pages are
> the user interface - or do you mean you have more than one interface to
> access the same data?
>
> It looks like more of a simple ASP question not really for this[/color]
newsgroup -[color=blue]
> but your answer could lie in specifying
> Server.MapPath("MyDb.mdb")
> rather than "C:\MyData\MyDb.mdb")
>
> Fletcher
>
>[/color]

re: Problem - absolute path to linked tables

"John Lewis" <john@cocreation.co.uk> wrote in message
news:bnjmae$h5d$1@news6.svr.pol.co.uk...[color=blue]
> Thanks Flectcher; you are quite right, splitting does have a specific
> meaning -my apologies for sloppy language.
>
> What I should have said is that I am using linked tables as a means to,
> errm, separate a single database into smaller chunks. This is for[/color]
management[color=blue]
> reasons - downloading a file of 10 MB is a drag!
>
> I never refer to the path in ASP; the linking is transparent, entirely
> inside Access.
>
> So I'm still stuck for an answer.
>
> John[/color]

Hi John
Sorry I'm still not clear. What do you mean 'linked tables'? You mean you
have several .mdb files each with a number of tables? Do you understand the
use of Server.MapPath? Perhaps you could, for the puposes of de-bugging,
change your code so it prints the connection string to your browser without
trying to connect.

Fletcher