Access and the web

[cory]

WHile I have found alot of info on Access itself, I have yet to find any
quality info on how to make an Access database work within a website. I
realize asp is probably the way to go but I cant find good info and quality
reading on this specific subject.

Can someone help or point me to where I can?

much thanks

 

[Gary Miller]

You are right. ASP, Cold Fusion or PHP are the usual web
interfaces.

For ASP try www.4guysfromrolla.com


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[cory]

Thanks for the reply.
Are you saying that a database could be built in MSAccess, and then use PHP
to make it work on the web??
To clarify, I am building a database in Access2003 and I want to publish it
on the web where clients can go to view their info, and so the data needs to
be dynamic, if you will. I want the dbase to work exactly the same way it
would if just using Access itself on your local harddrive. I am familiar
with Data Access PAges but they only work with MS Internet Explorer 5.x or
greater so I need the site to accommodate all browsers. In access 2003,
though I have not got this far yet, there is an export feature to .asp from
a databse table, form , or report. WOuld this feature fully work or is
hardcoding necessary?

Thanks again.

Cory

 

[Gary Miller]

I do not use php myself, but yes, it is a dynamic language
as are ASP and ColdFusion that I do use. The general concept
is to have the tables and queries in an mdb on the web
server and then set it up with a DSN on the server that your
appropriate database drivers talk to. There is no real way
to 'export' a viable working web page from Access.
Macromedia Dreamweaver and MS Front Page are probably the
most commonly used tools for building these type pages
unless you go the full .NET path which is a major jump.
These programs can do a lot of the coding through wizards
for you.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[cory]

Thank you. That was very helpful!

 

[Gary Miller]

In addition to the 4guysfromrolla.com link that I gave you,
you may want to go to macromedia.com. There is a lot info
there as well as they now own Cold Fusion.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[cory]

How much work is it to use asp to publish to the web? I may have found
software that can do this.....is it worth it to buy it?
In all honesty, I am still very unclear as to how much work it is to publish
access to the web....I would have thought being Microsoft it would be alot
easier!

Thanks

 

[Gary Miller]

You would think that MS would make it truly easy, but they
haven't solved that hurdle yet. The solution that they are
trying to steer people to is the 'Net' framework, but that
is a killer for newbies.

Front Page is their solution for beginners < laugh> to
advanced folks. Comments reserved.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[cory]

You would think that MS would make it truly easy, but they
haven't solved that hurdle yet. The solution that they are
trying to steer people to is the 'Net' framework, but that
is a killer for newbies.

Front Page is their solution for beginners < laugh> to
advanced folks. Comments reserved.

I have found ASP.Net and will probably use it. From what I can see a VB
programmer should be able to use it with ease....would you agree?

 

[Gary Miller]

Yes, very similar language.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________