> Hi Experts,
>
[quoted text clipped - 6 lines]
>
> Alp
No.

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Alp Bekisoglu - 26 Jan 2006 14:18 GMT
Thanks Rick, thought so but asked to make sure.
Alp
>> Hi Experts,
>>
[quoted text clipped - 8 lines]
>
> No.
According to the Access 97 help
"You can import and link (read-only) a data file on an FTP or HTTP server.
In effect, you can copy data through the Internet without a network server
connection"
and
"to import or link from an HTTP server, type the Internet address in the
File Name box. This is the only way to import or link from an HTTP server.
For example, to link the file Jansales.html on the //pubweb HTTP server,
type http://pubweb/jansales.html."
and
"· Microsoft Access copies the entire file to the Microsoft Internet
Explorer cache folder on your local machine. Therefore, this process may
take some time because potentially large amounts of data are being
transferred through the Internet.
· A linked table is a data snapshot of the original, remote data source at
the time you linked. You will not see updates to the data made at the remote
location while the table is open, but the next time you open it, Microsoft
Access refreshes the local copy in the cache folder."
I never got it to work myself, Access 2000 may be different, and security
settings on most computers would surely defeat it anyway.
Let us know how you go!
(david)
> Hi Experts,
>
[quoted text clipped - 6 lines]
>
> Alp
Alp Bekisoglu - 29 Jan 2006 11:55 GMT
Hi David,
Thanks for the info. It looks like it will not be of much use dealing with
it this way since the back-end will be read only. I guess its time to think
PHP/MySQL once again. Which means I will need to find a way to MySQL'ize the
A2K db.
Alp
> According to the Access 97 help
>
[quoted text clipped - 39 lines]
>>
>> Alp
Ian Davies - 30 Jan 2006 22:26 GMT
To transfer Access database to MySql try
www.dbtools.com.br
It offers a free trial period. More than sufficient for a one off task
Ive used it myself and it does the job OK
Ian
> Hi David,
>
[quoted text clipped - 48 lines]
> >>
> >> Alp
Alp Bekisoglu - 06 Feb 2006 09:52 GMT
Thanks Ian, I'll give it a try.
Alp
> To transfer Access database to MySql try
> www.dbtools.com.br
[quoted text clipped - 66 lines]
>> >>
>> >> Alp