By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,259 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,259 IT Pros & Developers. It's quick & easy.

How to admin a remote hosted Access db

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
"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

_5@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.

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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.