MS Access Multiuser - A question on back-end

Author

A question on back-end

Alp Bekisoglu

2006-01-26, 5:01 pm

Hi Experts,

This might be a weird question but I'll ask anyway: is it possible to
connect the front-end to a back-end placed under a website? i.e. will
Access2000 accept a link as http://someweb.com/somedir/somefilename_be.mdb
into the Database entry of MSysObjects via code?

Thanks in advance,

Alp

Rick Brandt

2006-01-26, 5:01 pm

Alp Bekisoglu wrote:
> Hi Experts,
>
> This might be a weird question but I'll ask anyway: is it possible to
> connect the front-end to a back-end placed under a website? i.e. will
> Access2000 accept a link as
> http://someweb.com/somedir/somefilename_be.mdb into the Database
> entry of MSysObjects via code?
> Thanks in advance,
>
> Alp

No.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Alp Bekisoglu

2006-01-26, 5:01 pm

Thanks Rick, thought so but asked to make sure.

Alp

"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:Rk4Cf.16003$Jd.14424@newssvr25.news.prodigy.net...
> Alp Bekisoglu wrote:
>
> No.
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>

2006-01-28, 7:24 am

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)

"Alp Bekisoglu" <alp@access_ng.com> wrote in message
news:uaNSgWmIGHA.3000@TK2MSFTNGP14.phx.gbl...
> Hi Experts,
>
> This might be a weird question but I'll ask anyway: is it possible to
> connect the front-end to a back-end placed under a website? i.e. will
> Access2000 accept a link as http://someweb.com/somedir/somefilename_be.mdb
> into the Database entry of MSysObjects via code?
>
> Thanks in advance,
>
> Alp
>
>

Alp Bekisoglu

2006-01-29, 7:23 am

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

< david@epsomdotcomdot
au> wrote in message
news:eouOHT$IGHA.3816@TK2MSFTNGP12.phx.gbl...
> 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)
>
>
> "Alp Bekisoglu" <alp@access_ng.com> wrote in message
> news:uaNSgWmIGHA.3000@TK2MSFTNGP14.phx.gbl...
>
>

Ian Davies

2006-01-30, 8:25 pm

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

"Alp Bekisoglu" <alp@access_ng.com> wrote in message
news:%23vGBZrMJGHA.604@TK2MSFTNGP14.phx.gbl...
> 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
>
> < david@epsomdotcomdot
au> wrote in message
> news:eouOHT$IGHA.3816@TK2MSFTNGP12.phx.gbl...
server.[color=darkred]
server[color=darkred
]
server.[color=darkred]
at[color=darkred]
Microsoft[color=dark
red]
security[color=darkr
ed]
>
>

Alp Bekisoglu

2006-02-06, 7:24 am

Thanks Ian, I'll give it a try.

Alp

"Ian Davies" <iandan.dav@virgin.net> wrote in message
news:8owDf.2259$494.2045@newsfe2-gui.ntli.net...
> 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
>
> "Alp Bekisoglu" <alp@access_ng.com> wrote in message
> news:%23vGBZrMJGHA.604@TK2MSFTNGP14.phx.gbl...
> think
> the
> server.
> server
> server.
> at
> Microsoft
> security
>
>

Sponsored Links