How to admin a remote hosted Access db

S

steve

Pardon me, as I am an Access newbie.

How do I admin a hosted Access db? Is there something like Enterprise
Manager or phpmyadmin that I can use for this purpose.

Thanks in advance.
 
L

Larry Linson

There is no "adminstration" as a separate feature; you simply use Access
itself. Unfortunately, using Access on a remote machine that hosts your DB
is not possible, unless you use Microsoft Terminal Services to execute
Access on that machine, or on another linked to it in the website's LAN.

One techinique is to FTP the database down to your machine, do whatever you
need with Access, then FTP the database back to the site.

An alternative is to use a Microsoft SQL Server database, if the host
supports that, or, if the load is light, install the free MSDE (aka SQL
Server Desktop) on the server. Unfortunately, MSDE does not include an
Enterprise Manager.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP

steve said:
Pardon me, as I am an Access newbie.

How do I admin a hosted Access db? Is there something like Enterprise
Manager or phpmyadmin that I can use for this purpose.

Thanks in advance.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/MS-Access-admin-remote-hosted-db-ftopict175263.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
Click to expand...
http://www.dbForumz.com/eform.php?p=588486
 
S

steve

Larry Linson1 said:
There is no "adminstration" as a separate feature; you simply use
Access
itself. Unfortunately, using Access on a remote machine that hosts
your DB
is not possible, unless you use Microsoft Terminal Services to execute
Access on that machine, or on another linked to it in the
website’s LAN.

One techinique is to FTP the database down to your machine, do
whatever you
need with Access, then FTP the database back to the site.

An alternative is to use a Microsoft SQL Server database, if the host
supports that, or, if the load is light, install the free MSDE (aka
SQL
Server Desktop) on the server. Unfortunately, MSDE does not include an
Enterprise Manager.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
Click to expand...


Thanks Larry,
I am using Access to archive historic data (as opposed to live data
that is sitting in SQL Server db). I was afraid I needed to do ftp
back and forth... I guess that is the way to go, since it is only one
table.

I don’t think my host has MSDE, and I most likely cannot ask them to
install it. So I think I will make do with ftp...

steve
 
S

Steve Huff

Actually there is a way to do it. If your hosting it on a site that is ASP
based there are ASP driven tools for Administrating you database via web
pages. If you are intereted let me know and I'll see if I can find it.

--Steve Huff
 
S

steve

stevehuff said:
Actually there is a way to do it. If your hosting it on a site that
is ASP
based there are ASP driven tools for Administrating you database via
web
pages. If you are intereted let me know and I’ll see if I can
find it.

--Steve Huff


abuse: http://www.dbForumz.com/eform.php?p=588486
Click to expand...

steve, yes, the host does have asp. Would appreciate if you find
some, and post here.
 
Top