I have split my database using "database spiltter" and I have
then put my backend on my ftpserver.

I then try to connect to the backend using "Linked Table Manager",
click on the mdb-file on my ftpserver but then I get the message
"Invalid filename".

What can be wrong ??

--
My PhotoGallery
www.photo.activewebsite.dk

How are you trying to designate the path? Access doesn't recognize the ftp
protocol (nor the http protocol), if that's how you've tried to link.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"SpookiePower" <(E-Mail Removed)> wrote in message
news:O%23bP$(E-Mail Removed)...
> I have split my database using "database spiltter" and I have
> then put my backend on my ftpserver.
>
> I then try to connect to the backend using "Linked Table Manager",
> click on the mdb-file on my ftpserver but then I get the message
> "Invalid filename".
>
> What can be wrong ??
>
> --
> My PhotoGallery
> www.photo.activewebsite.dk
>
>

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> skrev i en meddelelse news:(E-Mail Removed)...
> How are you trying to designate the path? Access doesn't recognize the ftp
> protocol (nor the http protocol), if that's how you've tried to link.

Yes I'm using the ftp protocl.
How should I else get connected to the backend ?

I have a webhotel where I have uploaded the backend
and then trying to connect using ftp.

Won't work. The only way is if you can connect to the actual UNC.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"SpookiePower" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a webhotel where I have uploaded the backend
> and then trying to connect using ftp.
>
>

Unfortunately, FTP is a system in which you TRANSFER a WHOLE file.

Thus, you can grab a word, or excel file via ftp, but in fact the WHOLE file
is transferred to the pc, changes are made, and then you can ftp it back.


The problem with ms-access, is that you can also do this, but it means that
the whole FILE is transfer to your pc, edits done, and then you would have
to transfer the whole file back to the ftp site (this would thus only allow
one user at a time, and of course the risk of one user updating, or
overwriting the file would make this not really workable).


So, FTP lets you transfer a file, but does not let you "OPEN" a file for
read, and writing PARTS OF THE file, which ms-access needs to be able to do.
So, you need a to be able to open the mdb file, and thus you need a network
system (protocol) that allows you to browse, and then open the file like any
regular
windows file. FTP supports none of the windows file system ability to read,
and
write a file (there is NO read/write or networking with FTP).

So, FTP is JUST a file transfer system. You can't
read, or write data using FTP..but ONLY transfer a file.

You can most certainly place the data part in a server on your lan, and then
place the front ends (application part) on each workstation,a and link to
that back end. This works, and is normally how you setup ms-access to work
in multi-user situations.

However, if you are talking about a server, and a wan, or the internet,
then I give some solutions here

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

In the above I explain why you can't spilt over the internet.

pay careful attention to notes in the above as to WHY a mdb file will
corrupt...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal

"SpookiePower" <(E-Mail Removed)> wrote in message
news:Ok$(E-Mail Removed)...
> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> skrev i en
> meddelelse news:(E-Mail Removed)...

>> How are you trying to designate the path? Access doesn't recognize the
>> ftp
>> protocol (nor the http protocol), if that's how you've tried to link.
>
> Yes I'm using the ftp protocl.
> How should I else get connected to the backend ?

You need to run networking. Are both computers on the same local access
network?

"Homer J Simpson" <(E-Mail Removed)> skrev i en meddelelse news:stlOf.14446$vC4.13906@clgrps12...
> You need to run networking. Are both computers on the same local access network?


Yes, on my work they are.
But I was wondering if it was possible to put the backend on a
ftpserver, so that I could reach the backend from my home computer.
I do not have access to the network at my work, from my home.

I can understand that using a ftp server for my
backend wil not work at all, and I dont want my
own computer to be on 24/7 acting like a real server.

But on my webhotel I can run MySql, but I dont know
if MySql can run together with access ?

>
> But on my webhotel I can run MySql, but I dont know
> if MySql can run together with access ?

Sure....but then mysql has absolute nothing to do with FTP. This is a
complete different question and issue. You are now talking about connecting
to database server...and not FTP of a file....

So, sure....MySql works on the tc/ip network protocol.

And, ms-access makes a fine client to Oracle, Sql server, or in your case
mysql.

So, yes you can do this as long as the web provider allows clients to
connect to the sql server. Some web space providers certainly offer some
type of sql server for use with the web site, but they DO NOT allow external
clients outside of the web site to connect to the sql server. So, the sql
server engine is for use with the web server...and that web server can dish
out pages to the public internet. However, just because the web server can
connect to the sql server does NOT mean that Joe public can connect to the
sql server (in most cases...you cannot). So, check with your provider if
they allow connections to the sql (or mysql) server. In most cases, internet
providers do not have the sql server open the wild internet where any public
client on the internet can connect and play with the sql server. (and, when
they do allow connections, you likely have to setup a SSH (secure tunnel).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal



>