Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / February 2006

Tip: Looking for answers? Try searching our database.

A question on back-end

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alp Bekisoglu - 26 Jan 2006 10:45 GMT
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 - 26 Jan 2006 13:42 GMT
> 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.
david@epsomdotcomdotau - 28 Jan 2006 10:22 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.