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

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" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote

"Larry Linson1" wrote:

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