"Today in History" project

  • Thread starter Thread starter junior
  • Start date Start date
J

junior

I would like to implement a "Today in History" application that will
run at startup on a stand-alone machine.

Googling yielded "Today in History V.1.6 ASP .NET" developed by Dexter
Zafra - see www.myasp-net.com and www.Ex-designz.net . This seems
like a good example to follow and once up and running, I will replace
the existing 'history' data with my own data (diary entries).

I initially thought it would be a relatively easy exercise to adapt
the sourcecode (freely available for download) into an Access project,
but after a lot of reading over the last month or so, I still don't
know how or where to start the conversion.

Creating the database itself appears to be a fairly trivial matter to
me (using the Wizard), but creating the required queries seems a lot
more daunting.

I'm a great believer in NOT having to reinvent the wheel, so I ask:

1. Would it be better to start the project from scratch or to convert
the above into an Access(2002) project?

2. If conversion is a practical proposition, where do I start?

Any pointers will be most appreciated. Thank you.
 
Conversion is not practical because ASP and Access are very different
technologies. You should be able to roughly replicate the design, but your
Access forms will have to be created from scratch. You might be able to
lift the odd function or bit of SQL, but even then the VB syntax used in
ASP.Net is so different to Access' VBA that very little, if anything, is
likely to be useable without some tweaking.
 
Thanks - that's what I needed to know.

Conversion is not practical because ASP and Access are very different
technologies. You should be able to roughly replicate the design, but your
Access forms will have to be created from scratch. You might be able to
lift the odd function or bit of SQL, but even then the VB syntax used in
ASP.Net is so different to Access' VBA that very little, if anything, is
likely to be useable without some tweaking.
Click to expand...
 
Just a thought: if you've got a working ASP.Net application that you like,
then, depending on what Windows version you've got, you may be able to run
IIS and use the ASP application locally.

However, this being an Access newsgroup, if you want to pursue that further
you should do so in a more appropriate newsgroup.

Hope it may help.
 
Thanks for the thought, but no, I don't have any other ASP.Net
applications at all. Seems like starting from scratch is the way to
go. It'll be a learning curve for me, but then, that's what this is
all about in the first place!

Thanks again for your help. Much appreciated.
 
What about the one you mentioned in your first post? You even gave the
links for downloading it!
 
As I said, this is an Access newsgroup. I'm sure there are ASP.Net
newsgroups which would help you.
 
Just a thought: if you've got a working ASP.Net application that you like,
then, depending on what Windows version you've got, you may be able to run
IIS and use the ASP application locally.
Click to expand...

What do you mean by "you may be able to run IIS" ?

Thanks
 
IIS = Internet Information Services. It's Microsoft's web server software.
Some Windows desktop versions include this (typically professional editions,
not home editions) which allows you to create and run websites locally.
Even if you don't have it in your Windows version, you might be able to
download and use Apache instead.

You need to find a more suitable newsgroup if you want to pursue this
further.
 
OK, thanks. I'll check out my ISS capability - I'm using XP Pro Sp2.
Havent had much luck finding a ASP newgroup though. Nevermind,
you've been most helpful - thanks again.
 
OK, my last words:

1. I'm pretty sure that XP Pro includes IIS
2. Try here: microsoft.public.inetserver.asp.general
 
Back
Top