getting Access onto the web

  • Thread starter Thread starter mAx
  • Start date Start date
M

mAx

Hello,

apologies if I am in the 'wrong place' here - but I am
trying to get an MS Access database to run on the internet

(I am hosting my own site on my own server)

I am 99.99% there - I can open it locally on the server
but get an error "Microsoft Office Web components could
not open the database d:\folder_name\test.mdb" when I try
to open it on a client machine's internet explorer

Needless to say - this would be a very long post if I
expalined every step I have tried to get this working
BUT.... could I just ask -

Is it possible to do what I am trying to do? do I need SQL
Server or something? other things I have come across talk
about cold-fusion, .PHP, front-ends, back-ends!

I am sure I can do it with just MS Access and IIS but
how...

can anyone help me out here?

many thanks in advance

mAx
 
An IIS server can certainly host tables, and your web site can use them to
drive your pages and such. I wouldn't advise trying to run a "live"
application from a webserver via an Access db, however ... Access (actually,
Jet) is a file server; and as such is a poor choice for driving a web site.
MySql (which is free) is a much better solution, but it is more difficult to
run.
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "
 
no message Scott... that suppposed to happen or is there
something you want to tell me? please feel free to try
again :)

mAx
 
Thanks for that Scott

Tried all of saturday trying to get it figured out - the
security associations going on are like getting into the
pentagon! Its unbelievablely difficult - I am getting so
close but yet so far

MySQL - I had already downloaded it and installed but to
be honest - had completely forgotten about it as 'nothing'
shows up (icon etc) to start it up

think I will leave this for another day - thought it would
be a relatively complex thing to do - but not this bad!

anyway - thanks again for the help

mAx
 
I run an Access 2000 mdb on my site with an interface with FrontPage 2000.
I use a Windows server that has the front page extensions installed.I
had my "microsoft guru" set up the initial stuff over 2 years ago, now I
just feed the updated FrontPage asp files and the source db when needed.
I use www.Hostway.Com as my webhost and have had very good success there.
So far so good anyway.
You might check on Hostway Windows plan and see what their plans include
for their hosted sites. It might be enlightening regarding all the
"extras" you mentioned in your post.
Maybe this helps?
-Steve
 
Back
Top