Access through web page

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi All,

could someone point me in the direction of any info on how to build a SQL
statement from a web page and then display the returned data on the webpage?

Thanks in advance,

Rob
 
Sorry Rob. It's a little more involved than just a SQL statement.

What web server technology are you using? Active Server Pages (ASP,) ASP.NET, Cold Fusion, CGI scripts, something else?

If you'd like to see what can be done with Access data on the web using IIS and ASP, take a look at
http://www.scobiz.com/ClassSchedule.asp and http://www.scobiz.com/Calendar.asp. Both of these pages are created at the time of
request.

I'd talk to your internet provider to see what they support and suggest.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Hey, I was at the Win 2003 launch at the Adams Mark in October..... Did you
see me?......lol.

G. Vaught


M.L. Sco Scofield said:
Sorry Rob. It's a little more involved than just a SQL statement.

What web server technology are you using? Active Server Pages (ASP,)
Click to expand...
ASP.NET, Cold Fusion, CGI scripts, something else?
If you'd like to see what can be done with Access data on the web using IIS and ASP, take a look at
http://www.scobiz.com/ClassSchedule.asp and
Click to expand...
http://www.scobiz.com/Calendar.asp. Both of these pages are created at the
time of
 
Yup. You were definitely one of the 3,000 people I saw. :-)

You going to be at the Office launch? We can set up a meeting place so I know *which* one of the 2,000 people you are that they're
expecting.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Hi Sco,

thanks for the reply. The company has a database where several people can
enter info regarding output, failures, rework etc. I assumed that doing it
via a web interface would be a good idea since everyone has a browser and
there would only be one database. Maybe my question should have been "what
is the best way to do this". I'm a C++ engineer by trade and I must admit
to finding this database stuff a bit tricky! I have been asked to help due
to the previous employee leaving, any advice you could offer would be most
welcome,

Thanks again,

Rob
 
Rob,

If everyone is on the company network, the way to handle this is with a split database. An mdb file (backend) with just the tables
goes on a server and then everyone gets a copy of an mdb file (front-end) with everything else, the forms, reports, queries, etc.
The front-ends are all linked to the backend. If you have a good solid network, this approach will usually support 10 to 20 users
depending on how heavily the system is used.

The downside of this approach is that everyone must have a copy of Access installed or you will need to create an Access run-time to
install using the Office Developer Edition (ODE.) The ODE gives you the run-time files and more importantly, a license to distribute
them.

If you want to go the browser route, you might look into Data Access Pages (DAPs.) I personally don't like them because they are a
poor substitute for an Access form. I usually bite the bullet and write Active Server Pages (ASPs.) You do need a web server on the
network for ASPs.

To get an idea of the tradeoffs, start searching for the different technologies in the Knowledge Base at
http://support.microsoft.com/default.aspx?scid=FH;EN-US;KBHOWTO and on MSDN at http://msdn.microsoft.com/library/default.asp.

No mater which direction you go, you're going to have a learning curve.

Personally, if everyone is on the network, I'd go the split database route. I've been using it successfully for years. You might
have a few up front $s if you need to get the ODE. However, the learning curve to make run-times will be much shorter than learning
to make DAPs or ASPs, ending up being faster develop and thus less $s in the long run.

I wish you luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top