How to admin a remote hosted Access db

[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.

--
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-ad...ict175263.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=588486

[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" <Us************@dbForumz.com> wrote in message
news:41**********@alt.athenanews.com...

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-ad...ict175263.html Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=588486

[steve]

"Larry Linson1" wrote:

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" <Us************@dbForumz.com> wrote in message
news:41ad43f5

[e-mail]...

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.

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

--
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-ad...ict175263.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=588619