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

ODBC and Access Database Online

P: n/a
I'm somewhat of a newbie at this, and a bit overwhelmed
at all the information (ODBC, ASP, VB, etc). I'm doing a
little work on Access for a small company, and someone
had the brainstorm that we could put the Access database
on the company's website so that everyone in the company
could use it from different offices/home (there are only about
5 or 6 of us). I called our site host, and they setup a DNS
for us (at least they said they did). I ftp'd the Access file
there, but can't seem to go any further. I've tried to set it
up using the Data Sources shortcut on the Control Panel
to no avail. I've read through a couple tutorials, but apparently
I've missed something. The tutorials only mentioned Win98,
but I see the same shortcuts under ODBC on my WinXP
system. I've also seen it mentioned that I could do this
without a DNS. Would that be better? I tried to use
FrontPage to upload some files to the site, but apparently
the host doesn't have the FrontPage extensions installed
on its server (Is that a problem? I don't really need Front
Page to do what I want, right?).
One other question: Naturally, we don't want every
visitor to our website to have access to this data, so what's
the best way to keep it just to those 5 or 6 people I've
mentioned, if that's possible?
Thanks for any help-

Scott Drane
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Access is a shared-file database, so the file must reside on a filesystem.
FTP can be operated with a bvrowser that is similar to a filesystem browser,
but FTP is not a filesystem, it is a file transfer protocol for uploading and
downloading whole files.

On Sat, 14 Feb 2004 14:35:39 -0600, "Scott Drane" <sd****@rcn.com> wrote:
I'm somewhat of a newbie at this, and a bit overwhelmed
at all the information (ODBC, ASP, VB, etc). I'm doing a
little work on Access for a small company, and someone
had the brainstorm that we could put the Access database
on the company's website so that everyone in the company
could use it from different offices/home (there are only about
5 or 6 of us). I called our site host, and they setup a DNS
for us (at least they said they did). I ftp'd the Access file
there, but can't seem to go any further. I've tried to set it
up using the Data Sources shortcut on the Control Panel
to no avail. I've read through a couple tutorials, but apparently
I've missed something. The tutorials only mentioned Win98,
but I see the same shortcuts under ODBC on my WinXP
system. I've also seen it mentioned that I could do this
without a DNS. Would that be better? I tried to use
FrontPage to upload some files to the site, but apparently
the host doesn't have the FrontPage extensions installed
on its server (Is that a problem? I don't really need Front
Page to do what I want, right?).
One other question: Naturally, we don't want every
visitor to our website to have access to this data, so what's
the best way to keep it just to those 5 or 6 people I've
mentioned, if that's possible?
Thanks for any help-

Scott Drane


Nov 12 '05 #2

P: n/a
> Access is a shared-file database, so the file must reside on a filesystem.
FTP can be operated with a bvrowser that is similar to a filesystem browser, but FTP is not a filesystem, it is a file transfer protocol for uploading and downloading whole files.


Steve,
Thank you for your reply. Yes, I understand this much.
I ftp'ed the database to the website simply to get it on the
web server. Now I'd like to be able to access it from any
of the 5 or 6 computers, preferably using the web pages
that Access itself has, or if not, probably using some type
of ASPs that I will have to write.
The first hump to get over is actually seeing the data
from the website on my computer. Any help?

Scott
Nov 12 '05 #3

P: n/a
On Sat, 14 Feb 2004 19:02:53 -0600, "Scott Drane" <sd****@rcn.com> wrote:
Access is a shared-file database, so the file must reside on a filesystem.
FTP can be operated with a bvrowser that is similar to a filesystem

browser,
but FTP is not a filesystem, it is a file transfer protocol for uploading

and
downloading whole files.


Steve,
Thank you for your reply. Yes, I understand this much.
I ftp'ed the database to the website simply to get it on the
web server. Now I'd like to be able to access it from any
of the 5 or 6 computers, preferably using the web pages
that Access itself has, or if not, probably using some type
of ASPs that I will have to write.
The first hump to get over is actually seeing the data
from the website on my computer. Any help?

Scott


Sorry, then. I didn't understand the gist of your question. Yes, you'll have
to either write a Web app such as ASP or ASP.NET, or I think there is now an
ADO remoting interface you could use - sort of a poor man's database server.
Nov 12 '05 #4

P: n/a
Hi Chuck,
It sounds like you have a long road ahead of you.... Don't worry
though, it's not all that long. 2 or 3 months, perhaps, depending
upon how fast you can learn ASP.


Thanks for your advice on ASP. I've made a note
of the websites you've mentioned (and have actually been
to a couple previously). I'm sure I will be checking them out
soon.
I think those issues are down the line. I'm actually stuck
more at Step 1. For some reason, I can't connect to the
database I have at our website. I have WinXP Pro on
this machine, so I should be able to do this with the Access
wizards, correct? Well, obviously I have more reading to
do, but I thought I could get a shortcut here. Thanks for
your help.
Scott


Nov 12 '05 #5

P: n/a

To get you started converting your Access DB to a web based solution
there are a number of ASP Generators out there. It just depends on
how much you want to spend. I just went throught this problem myself.
There is ASPMaker at http://www.hkvstore.com/ or DB2ASP at
http://www.db2asp.com/ to name a few they are about $40 and $400
respectively. They both have demo versions.

On Sat, 14 Feb 2004 14:35:39 -0600, "Scott Drane" <sd****@rcn.com>
wrotE:
I'm somewhat of a newbie at this, and a bit overwhelmed
at all the information (ODBC, ASP, VB, etc). I'm doing a
little work on Access for a small company, and someone
had the brainstorm that we could put the Access database
on the company's website so that everyone in the company
could use it from different offices/home (there are only about
5 or 6 of us). I called our site host, and they setup a DNS
for us (at least they said they did). I ftp'd the Access file
there, but can't seem to go any further. I've tried to set it
up using the Data Sources shortcut on the Control Panel
to no avail. I've read through a couple tutorials, but apparently
I've missed something. The tutorials only mentioned Win98,
but I see the same shortcuts under ODBC on my WinXP
system. I've also seen it mentioned that I could do this
without a DNS. Would that be better? I tried to use
FrontPage to upload some files to the site, but apparently
the host doesn't have the FrontPage extensions installed
on its server (Is that a problem? I don't really need Front
Page to do what I want, right?).
One other question: Naturally, we don't want every
visitor to our website to have access to this data, so what's
the best way to keep it just to those 5 or 6 people I've
mentioned, if that's possible?
Thanks for any help-

Scott Drane


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.