TripleDES with Hexadecimal Key

I am working with a web service which requires enryption of some XML
fields. It will be symmetric encryption - TripleDES.
The vendor has given me the Key that we will share. With the exception
that there are 48 characters in the actual Key that he gave me, here
is an example of what he gave me: 0E329232EA6D0D73 (The vendor has
told me to use all zeros for the IV.)
How can I use this with the .Key property of
TripleDESCryptoServicerProvider? I realize that what he is giving me
is hexadecimal, but how do I convert it a .Key that I can use with
the .NET framework. The only way that I can see to set the .Key
property is: Dim objDES.Key as Byte() = {48, 3, 17, 131, 202, ....and
so on}
How do I either convert the .Key that the vendor has given me to the
VB.NET language above - or is there another to set the .Key property
that I am overlooking?
Any help anyone could give would be hugely appreciated - thanks!It 0E329232EA6D0D73 is hexadecimal notation of 14, 50, ... in decimal
where did 48, 3, 17, 131, 202, came from?
Use calc.exe to convert it to decimal and write correct values
Dim objDES.Key as Byte() = {14, 50, }
Or you can use
Int32.Parse("0E", NumberStyles.HexNumber )
Int32.Parse("32", NumberStyles.HexNumber )
...
George
"Celia" <c.oblinger@.gmail.com> wrote in message
news:0dcd82f2-3eaa-480d-81cf-749e6158fbd1@.s8g2000prg.googlegroups.com...
>I am working with a web service which requires enryption of some XML
> fields. It will be symmetric encryption - TripleDES.
> The vendor has given me the Key that we will share. With the exception
> that there are 48 characters in the actual Key that he gave me, here
> is an example of what he gave me: 0E329232EA6D0D73 (The vendor has
> told me to use all zeros for the IV.)
> How can I use this with the .Key property of
> TripleDESCryptoServicerProvider? I realize that what he is giving me
> is hexadecimal, but how do I convert it a .Key that I can use with
> the .NET framework. The only way that I can see to set the .Key
> property is: Dim objDES.Key as Byte() = {48, 3, 17, 131, 202, ....and
> so on}
> How do I either convert the .Key that the vendor has given me to the
> VB.NET language above - or is there another to set the .Key property
> that I am overlooking?
> Any help anyone could give would be hugely appreciated - thanks!

trouble creating a zodiac sign web service...

I would like to create a web service that returns the zodiac sign of a given date.

The problem I am having is that I have no idea how to do the following:

I receive a DateTime object with the date as a ShortDateFormat (e.g. 3/1/2005), and I would like to compare this to make sure it falls within a range of dates (compare it to a date range of February 20- March 20 for example) and it returns true. At which point I return the String "Pisces."

Any help on how to do this is greatly appreciated. The problem I don't understand is how to compare a date to a date range and see if it falls within it or not!

Thanks in advance
~nK~

p.s. sorry if this is in the wrong section but I posted in XML Web Services as well :)Hi,
As far as I know there is no scalar to range comparison. Use simple search algorithm to locate relevant range. You can sort your zodiac date ranges by starting date, compare your input date to starting date, until you find first starting date greater then input date, use previous range.
yea or convert all the days to a numeric day of the year (0-364(5) or 1-365(6)), then set numeric ranges for all the zodiac signs (100-131 = pices for example), then you can convert the entered date to a number and tell where it "fits in" to the zodiac ranges.
I created the service using a select statement on the month part alone.

Then each case is for each month, and then it has an if to say whether it is less than or equal to a specific day at which point it returns the correct zodiac sign.

For example, if I put in the date 3/1/05 it should return Pisces.

Select Month(dateObj)
Case 3
If Day(dateObj) <=21 Then
return "Pisces"
Else: Return "Aries"

and so on...

Of course the dateObj is the date that is returned.

Now I am trying to make the date not be cultural specific. Any ideas how this is done?
Basically, in some parts of the world they enter the date as dd/mm/yy but in other parts its mm/dd/yy. So that's what I meant by not cultural specific.

Thanks.
~nK~

Trouble deploying an ASP.NET project that uses a SERVICE

Hi Group,
Please help ending my Nightmare! There's a Windows Service written in
VC++ and I have an ASP.NET project that uses this sevice as a COM
library. It just works fine in VS Internal Web Server and also in my
IIS. I can publish it on my computer easily, But CAN'T publish or
deploy it on other machines with almost same configuration. The Service
in working on all other machines too.
I've tried several ways to set all permissions and security rights to
all users and tried to put that service within the BIN directory but it
doesn't help. The Error message that I get in all situatuions is:
Retrieving the COM class factory for component with CLSID
{3304F12E-4A78-4F49-AF4E-C6E92617249E} failed due to the following
error: 80070005.
Please Help!
AfsharAre you sure the said Windows Service was installed and running (if set to
Automatically Start), either somehow by your publishing/deploying, or
someone did it manually, on the target web server computer? How did you get
the Windows Service installed and running?
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1149922296.293862.140600@.m38g2000cwc.googlegroups.com...
> Hi Group,
> Please help ending my Nightmare! There's a Windows Service written in
> VC++ and I have an ASP.NET project that uses this sevice as a COM
> library. It just works fine in VS Internal Web Server and also in my
> IIS. I can publish it on my computer easily, But CAN'T publish or
> deploy it on other machines with almost same configuration. The Service
> in working on all other machines too.
> I've tried several ways to set all permissions and security rights to
> all users and tried to put that service within the BIN directory but it
> doesn't help. The Error message that I get in all situatuions is:
> Retrieving the COM class factory for component with CLSID
> {3304F12E-4A78-4F49-AF4E-C6E92617249E} failed due to the following
> error: 80070005.
> Please Help!
> Afshar
>
Dear Norman,
I've found the problem, that Service wasn't the problem It was working
and configured fine.
I enabled anonymous access in IIS and set an ASPNET user for it.
Granted administrative rights to ASPNET user and everything went OK!
Thanks for your help,
Afshar
If the project is not used only for test purpose, I strongly suggest you to
consider the security risk of that practice: just having to use that Windows
service, you have lift a web user's priviledge to Administator, that is
definitely not a good way.
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150006633.536650.156090@.h76g2000cwa.googlegroups.com...
> Dear Norman,
> I've found the problem, that Service wasn't the problem It was working
> and configured fine.
> I enabled anonymous access in IIS and set an ASPNET user for it.
> Granted administrative rights to ASPNET user and everything went OK!
> Thanks for your help,
> Afshar
>
But I don't know what rights to grant the anonymous user.
Norman Yuan wrote:
> If the project is not used only for test purpose, I strongly suggest you t
o
> consider the security risk of that practice: just having to use that Windo
ws
> service, you have lift a web user's priviledge to Administator, that is
> definitely not a good way.
>
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150006633.536650.156090@.h76g2000cwa.googlegroups.com...
re:
> But I don't know what rights to grant the anonymous user.
Please review this article :
http://msdn.microsoft.com/library/d... />
000009.asp
for instructions on how to create a service account for ASP.NET
and this article :
http://msdn.microsoft.com/library/d.../>
netht01.asp
for the list of directories to which the ASP.NET service account needs permi
ssions.
This last article is written for 1.1, but the directories haven't changed fo
r 2.0
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150372901.156090.26710@.y41g2000cwy.googlegroups.com...
> But I don't know what rights to grant the anonymous user.
>
> Norman Yuan wrote:
>
Dear Juan
The first article is compeltely about Windows 2003 and the Second seems
to not be very realted with Services problem. I'm using Windows XP Pro,
ASP.NET 2.
Thanks:
Afshar Mohebbi
Juan T. Llibre wrote:
> re:
> Please review this article :
> http://msdn.microsoft.com/library/d...y/en-us/dnpag2=
/html/paght000009.asp
> for instructions on how to create a service account for ASP.NET
> and this article :
> http://msdn.microsoft.com/library/d...y/en-us/dnnets=
ec/html/secnetht01.asp
> for the list of directories to which the ASP.NET service account needs pe=
rmissions.
> This last article is written for 1.1, but the directories haven't changed=
for 2.0
>
> Juan T. Llibre, asp.net MVP
> aspnetfaq.com : http://www.aspnetfaq.com/
> asp.net faq : http://asp.net.do/faq/
> foros de asp.net, en espa=F1ol : http://asp.net.do/foros/
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D[color=
darkred]
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150372901.156090.26710@.y41g2000cwy.googlegroups.com...
ou to
indows
ng
re:
> The first article is compeltely about Windows 2003
Actually, it's about ASP.NET 2.0 running under Windows 2003 Server.
The only difference you'll find is in the Application Pool info.
You can ignore that. The rest is quite accurate for IIS 5.1.
re:
> the Second seems to not be very realted with Services problem.
The first article deals with ASP.NET 2.0 and the second one with ASP.NET 1.1
.
You can ignore the second one, but it has the correct list of directories to
which
you need to assign permissions to whichever account ASP.NET runs as.
The first article doesn't have them, because ASP.NET 2.0 has a nifty
command to assign permissions to all necessary directories :
aspnet_regiis -GA machinename\accountname
or
aspnet_regiis -GA domainname\accountname
re:
> I'm using Windows XP Pro, ASP.NET 2.
> I enabled anonymous access in IIS and set an ASPNET user for it.
OK...
re:
> Granted administrative rights to ASPNET user and everything went OK!
That may bite you in the future.
The ASPNET account should *not* have administrative rights.
What you should do is to *only* assign the rights the account needs.
The list of directories and the type of permissions the ASP.NET
account needs are listed in the second article I sent to you.
If you still have doubts, review this list of ACLS which ASP.NET (all versio
ns) requires :
http://msdn2.microsoft.com/en-us/library/kwzs111e.aspx
If you assign those permissions to *any* account which ASP.NET is running as
,
ASP.NET will run just fine, including Web Services.
Don't expose your machine by giving administrative rights to the ASP.NET acc
ount.
That is easy to do, and does solve the problem, but it may bring you headach
es later on.
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150622522.679335.249860@.r2g2000cwb.googlegroups.com...
Dear Juan
The first article is compeltely about Windows 2003 and the Second seems
to not be very realted with Services problem. I'm using Windows XP Pro,
ASP.NET 2.
Thanks:
Afshar Mohebbi
Juan T. Llibre wrote:
> re:
> Please review this article :
> http://msdn.microsoft.com/library/d...>
ht000009.asp
> for instructions on how to create a service account for ASP.NET
> and this article :
> http://msdn.microsoft.com/library/d...
ecnetht01.asp
> for the list of directories to which the ASP.NET service account needs per
missions.
> This last article is written for 1.1, but the directories haven't changed
for 2.0
>
> Juan T. Llibre, asp.net MVP
> aspnetfaq.com : http://www.aspnetfaq.com/
> asp.net faq : http://asp.net.do/faq/
> foros de asp.net, en espaol : http://asp.net.do/foros/
> ===================================
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150372901.156090.26710@.y41g2000cwy.googlegroups.com...
Dear Juan,
You're right: ASPNET user shouldn't be Administrator...

> If you still have doubts, review this list of ACLS which ASP.NET (all vers
ions) requires :
> http://msdn2.microsoft.com/en-us/library/kwzs111e.aspx
This list is very helpfull and I've found many things that I didn't
know about it.
Thanks for your attention once again!
Afshar Mohebbi

Trouble deploying an ASP.NET project that uses a SERVICE

Hi Group,

Please help ending my Nightmare! There's a Windows Service written in
VC++ and I have an ASP.NET project that uses this sevice as a COM
library. It just works fine in VS Internal Web Server and also in my
IIS. I can publish it on my computer easily, But CAN'T publish or
deploy it on other machines with almost same configuration. The Service
in working on all other machines too.
I've tried several ways to set all permissions and security rights to
all users and tried to put that service within the BIN directory but it
doesn't help. The Error message that I get in all situatuions is:
Retrieving the COM class factory for component with CLSID
{3304F12E-4A78-4F49-AF4E-C6E92617249E} failed due to the following
error: 80070005.

Please Help!
AfsharAre you sure the said Windows Service was installed and running (if set to
Automatically Start), either somehow by your publishing/deploying, or
someone did it manually, on the target web server computer? How did you get
the Windows Service installed and running?

"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1149922296.293862.140600@.m38g2000cwc.googlegr oups.com...
> Hi Group,
> Please help ending my Nightmare! There's a Windows Service written in
> VC++ and I have an ASP.NET project that uses this sevice as a COM
> library. It just works fine in VS Internal Web Server and also in my
> IIS. I can publish it on my computer easily, But CAN'T publish or
> deploy it on other machines with almost same configuration. The Service
> in working on all other machines too.
> I've tried several ways to set all permissions and security rights to
> all users and tried to put that service within the BIN directory but it
> doesn't help. The Error message that I get in all situatuions is:
> Retrieving the COM class factory for component with CLSID
> {3304F12E-4A78-4F49-AF4E-C6E92617249E} failed due to the following
> error: 80070005.
> Please Help!
> Afshar
Dear Norman,
I've found the problem, that Service wasn't the problem It was working
and configured fine.

I enabled anonymous access in IIS and set an ASPNET user for it.
Granted administrative rights to ASPNET user and everything went OK!

Thanks for your help,
Afshar
If the project is not used only for test purpose, I strongly suggest you to
consider the security risk of that practice: just having to use that Windows
service, you have lift a web user's priviledge to Administator, that is
definitely not a good way.

"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150006633.536650.156090@.h76g2000cwa.googlegr oups.com...
> Dear Norman,
> I've found the problem, that Service wasn't the problem It was working
> and configured fine.
> I enabled anonymous access in IIS and set an ASPNET user for it.
> Granted administrative rights to ASPNET user and everything went OK!
> Thanks for your help,
> Afshar
But I don't know what rights to grant the anonymous user.

Norman Yuan wrote:
> If the project is not used only for test purpose, I strongly suggest you to
> consider the security risk of that practice: just having to use that Windows
> service, you have lift a web user's priviledge to Administator, that is
> definitely not a good way.
>
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150006633.536650.156090@.h76g2000cwa.googlegr oups.com...
> > Dear Norman,
> > I've found the problem, that Service wasn't the problem It was working
> > and configured fine.
> > I enabled anonymous access in IIS and set an ASPNET user for it.
> > Granted administrative rights to ASPNET user and everything went OK!
> > Thanks for your help,
> > Afshar
re:
> But I don't know what rights to grant the anonymous user.

Please review this article :

http://msdn.microsoft.com/library/d...paght000009.asp
for instructions on how to create a service account for ASP.NET

and this article :
http://msdn.microsoft.com/library/d.../secnetht01.asp
for the list of directories to which the ASP.NET service account needs permissions.

This last article is written for 1.1, but the directories haven't changed for 2.0

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150372901.156090.26710@.y41g2000cwy.googlegro ups.com...
> But I don't know what rights to grant the anonymous user.
>
> Norman Yuan wrote:
>> If the project is not used only for test purpose, I strongly suggest you to
>> consider the security risk of that practice: just having to use that Windows
>> service, you have lift a web user's priviledge to Administator, that is
>> definitely not a good way.
>>
>>
>> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
>> news:1150006633.536650.156090@.h76g2000cwa.googlegr oups.com...
>> > Dear Norman,
>> > I've found the problem, that Service wasn't the problem It was working
>> > and configured fine.
>>> > I enabled anonymous access in IIS and set an ASPNET user for it.
>> > Granted administrative rights to ASPNET user and everything went OK!
>>> > Thanks for your help,
>> > Afshar
>
Dear Juan
The first article is compeltely about Windows 2003 and the Second seems
to not be very realted with Services problem. I'm using Windows XP Pro,
ASP.NET 2.

Thanks:
Afshar Mohebbi

Juan T. Llibre wrote:
> re:
> > But I don't know what rights to grant the anonymous user.
> Please review this article :
> http://msdn.microsoft.com/library/d...paght000009.asp
> for instructions on how to create a service account for ASP.NET
> and this article :
> http://msdn.microsoft.com/library/d.../secnetht01.asp
> for the list of directories to which the ASP.NET service account needs permissions.
> This last article is written for 1.1, but the directories haven't changedfor 2.0
>
> Juan T. Llibre, asp.net MVP
> aspnetfaq.com : http://www.aspnetfaq.com/
> asp.net faq : http://asp.net.do/faq/
> foros de asp.net, en espaol : http://asp.net.do/foros/
> ===================================
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150372901.156090.26710@.y41g2000cwy.googlegro ups.com...
> > But I don't know what rights to grant the anonymous user.
> > Norman Yuan wrote:
> >> If the project is not used only for test purpose, I strongly suggest you to
> >> consider the security risk of that practice: just having to use that Windows
> >> service, you have lift a web user's priviledge to Administator, that is
> >> definitely not a good way.
> >>
> >>
> >> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> >> news:1150006633.536650.156090@.h76g2000cwa.googlegr oups.com...
> >> > Dear Norman,
> >> > I've found the problem, that Service wasn't the problem It was working
> >> > and configured fine.
> >> >> > I enabled anonymous access in IIS and set an ASPNET user for it.
> >> > Granted administrative rights to ASPNET user and everything went OK!
> >> >> > Thanks for your help,
> >> > Afshar
> >
re:
> The first article is compeltely about Windows 2003

Actually, it's about ASP.NET 2.0 running under Windows 2003 Server.

The only difference you'll find is in the Application Pool info.
You can ignore that. The rest is quite accurate for IIS 5.1.

re:
> the Second seems to not be very realted with Services problem.

The first article deals with ASP.NET 2.0 and the second one with ASP.NET 1.1.

You can ignore the second one, but it has the correct list of directories to which
you need to assign permissions to whichever account ASP.NET runs as.

The first article doesn't have them, because ASP.NET 2.0 has a nifty
command to assign permissions to all necessary directories :

aspnet_regiis -GA machinename\accountname
or
aspnet_regiis -GA domainname\accountname

re:
> I'm using Windows XP Pro, ASP.NET 2.
> I enabled anonymous access in IIS and set an ASPNET user for it.

OK...

re:
> Granted administrative rights to ASPNET user and everything went OK!

That may bite you in the future.
The ASPNET account should *not* have administrative rights.

What you should do is to *only* assign the rights the account needs.

The list of directories and the type of permissions the ASP.NET
account needs are listed in the second article I sent to you.

If you still have doubts, review this list of ACLS which ASP.NET (all versions) requires :
http://msdn2.microsoft.com/en-us/library/kwzs111e.aspx

If you assign those permissions to *any* account which ASP.NET is running as,
ASP.NET will run just fine, including Web Services.

Don't expose your machine by giving administrative rights to the ASP.NET account.
That is easy to do, and does solve the problem, but it may bring you headaches later on.

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Afshar" <afshar.mohebbi@.gmail.com> wrote in message
news:1150622522.679335.249860@.r2g2000cwb.googlegro ups.com...
Dear Juan
The first article is compeltely about Windows 2003 and the Second seems
to not be very realted with Services problem. I'm using Windows XP Pro,
ASP.NET 2.

Thanks:
Afshar Mohebbi

Juan T. Llibre wrote:
> re:
> > But I don't know what rights to grant the anonymous user.
> Please review this article :
> http://msdn.microsoft.com/library/d...paght000009.asp
> for instructions on how to create a service account for ASP.NET
> and this article :
> http://msdn.microsoft.com/library/d.../secnetht01.asp
> for the list of directories to which the ASP.NET service account needs permissions.
> This last article is written for 1.1, but the directories haven't changed for 2.0
>
> Juan T. Llibre, asp.net MVP
> aspnetfaq.com : http://www.aspnetfaq.com/
> asp.net faq : http://asp.net.do/faq/
> foros de asp.net, en espaol : http://asp.net.do/foros/
> ===================================
> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> news:1150372901.156090.26710@.y41g2000cwy.googlegro ups.com...
> > But I don't know what rights to grant the anonymous user.
> > Norman Yuan wrote:
> >> If the project is not used only for test purpose, I strongly suggest you to
> >> consider the security risk of that practice: just having to use that Windows
> >> service, you have lift a web user's priviledge to Administator, that is
> >> definitely not a good way.
> >>
> >>
> >> "Afshar" <afshar.mohebbi@.gmail.com> wrote in message
> >> news:1150006633.536650.156090@.h76g2000cwa.googlegr oups.com...
> >> > Dear Norman,
> >> > I've found the problem, that Service wasn't the problem It was working
> >> > and configured fine.
> >> >> > I enabled anonymous access in IIS and set an ASPNET user for it.
> >> > Granted administrative rights to ASPNET user and everything went OK!
> >> >> > Thanks for your help,
> >> > Afshar
> >
Dear Juan,

You're right: ASPNET user shouldn't be Administrator...

> If you still have doubts, review this list of ACLS which ASP.NET (all versions) requires :
> http://msdn2.microsoft.com/en-us/library/kwzs111e.aspx
This list is very helpfull and I've found many things that I didn't
know about it.

Thanks for your attention once again!
Afshar Mohebbi

Trouble Ticket Design (SQL + ASP.NET)

Hi All,

My company is a nationwide field service org. We have subcontractors across the US to service our customers things like: extending digital/analog circuits, break & fix POS system, troubleshoot in-house wiring related to telecom equipments such as csu/dsu, routers, etc..

Our trouble ticket system is currently both back and front end based in MS Access. My project is to migrate MS Access into MS SQL and write a front-end in ASP.NET (using Visual Studio .NET 2003). I've experienced with SQL and ASP only 6 months and moving to ASP.NET and handle this kind of big project is quite a challenge for me.

Anyways, my questions to all experts out there are: Can you direct me to any useful resources out there in order to help me to get a good start on this? I'm looking for more like architecture design of trouble ticket in enterprise enviroment. What sort of things do I need to watch out when coding in ASP.NET while multi-update accessing to the same ticket. I'm sure there's millions more things that I need to watch out, but can't think anymore for now.

Please help.

Any response would be greatly appreciated.

ThanhUnfortunately your question is just way too open ended. We could sit here and talk about 1,000,000 possible pitfalls for your application. I would suggest that you Google the heck out of: ASP.NET, .NET, VB.NET, C# and check out the starter kits here:

Starter Kits

Several applications that provide excellent samples of .NET code, architecture and so on. Try and get your arms around .NET a little bit and then come back with some more specific questions.

BTW- One of the starter kits is an issue tracker and might be similar to what you're faced with.
Thank you very much for quick reply, FrankWhite!
You're right, I need to get my arms around .NET much more.

Thanh
I just wanted to add that although it seems like a tall order - it can be done. I work for an Office equipment service shop. We do local service calls on equipment. I built a system ( first in Access, then ASP, and now .Net) that allows us to enter a trouble ticket, assign a tech, and track the call progress. I'm using .Net and SQL 2000. There is an Issue tracker starter kit - this should give you a good starting point to draw ideas from, along with the time tracker starter kit. Since you already hace the Access version - you should start with that. Import your tables into SQL and build the web based front end using the acces forms as a guide. Then you can tweak it to what you need.
You can do it...
HTH
Thanks for your post, UncleB.
Yeah... I was gonna code in ASP for front-end because I felt comfortable, but ASP.NET is so attractive even though I'm just .NET beginner. I'm more confident now that "can be done" with ASP.NET.