Upgrading Access 97 application to dotNet

[kavsak]

Hi. Not sure that this is the right place to ask but here goes.

I have an application based on access97 and VB6 which I need to
upgrade. It has to handle up to 20 concurrent users on a Win2k network
( to be upgraded to XP next year) which has no connection to the
outside world, but normally there are no more than 2. It has
approximately 150 tables with complicated validation rules and a large
amount of calculation. I want to rewrite it in VB net or C# with a
suitable modern database. So I far I have 3 weeks experience of the
..Net world.

I am not permitted to run any form of central database server, but data
tables must (?) be held on the network server to provide the multi user
capability. It must also be possible to transfer the application and
its database to a standalone laptop for use in other locations.

Can I use SQL Server in any form as this seems to be the best match for
VS2005 or do I have to continue to use Access?

Any advice on the best way to proceed would be most welcome.

Thanks in advance.

[raj_pattel]

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot of
playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.

[Paul Clement]

On 1 Dec 2006 12:53:18 -0800, "kavsak" <st**********@b topenworld.comw rote:

¤ Hi. Not sure that this is the right place to ask but here goes.
¤
¤ I have an application based on access97 and VB6 which I need to
¤ upgrade. It has to handle up to 20 concurrent users on a Win2k network
¤ ( to be upgraded to XP next year) which has no connection to the
¤ outside world, but normally there are no more than 2. It has
¤ approximately 150 tables with complicated validation rules and a large
¤ amount of calculation. I want to rewrite it in VB net or C# with a
¤ suitable modern database. So I far I have 3 weeks experience of the
¤ .Net world.
¤
¤ I am not permitted to run any form of central database server, but data
¤ tables must (?) be held on the network server to provide the multi user
¤ capability. It must also be possible to transfer the application and
¤ its database to a standalone laptop for use in other locations.
¤
¤ Can I use SQL Server in any form as this seems to be the best match for
¤ VS2005 or do I have to continue to use Access?

Given the requirements you've stated I would stick with your Microsoft Access database
implementation. Since you can't operate in a server based environment that would eliminate both SQL
Server and SQL Server Express from consideration. Since you're already using Access you may as well
stick with it instead of moving to another file based database.
Paul
~~~~
Microsoft MVP (Visual Basic)

[aaron.kempf]

Ii totally agree.

even the bumbling kids over in redmond couldn't have done this
accidently

vb.net has almost been killed off already

do you know how they delayed sp5 for windows 2000 and then they delayed
sp3 for windows xp and then they delayed sp1 for visual studio 2003 /
2005??

it's because they're discontinuing the product

in ms parlance, delaying a service pack means that they're killing the
program

read it and weep bitches; there will never be windows xp sp3 or vs 2003
sp1 or vs 2005 sp1

they fucked us all on not coming out with sp5 for windows 2000-- they
just dont give a shit about previous versions and obsolete languages;
and according to ms; vb.net is an obsolete language


Master Programmer wrote:

This is true, I also have reliable info that VB will be discontinued in
VS 9.0. They (MS) just included a crappy crippled version of VB
temporarily in the current VS version to try to get all of the VB 6.0
programmers to move across to C#. But most VB programmers can't stand
it and (rightly so) feel cheated.

C# (and VB.NET) were created by a load of acedemic type C++ faggots at
Microsoft. They didn't understand thier user base properly. Now MS are
getting royaly shafted as nearly all VB 6.0 users move away to other
languages - as most hate VB.NET.

Steve Ray Irwin
aa*********@gma il.com wrote:

THEN JUST USE ACCESS DATA PROJECTS

lose the fucking training wheels; and don't bother with .NET

from what I hear; VB.net is going to be discontinued in the next
release
I had a friend from Microsoft that told me about this

VB6 was a 'more complete package' and VB.net can't compete with C#
because those geniuses didn't understand that they could just call it
VB# and everyone would have been 10 times happier

-Aaron


kavsak wrote:

Thanks guys.
>
I need to rewrite it sooner rather than later to maintain my sanity,
because it is expected to last for another 20 years. The front end has
40000 lines of code and and the back end stores 100000 records with a
regular need to import and manipulate external Access databases of up
to 500Mb in size. What runs where is mandated by men in black.
>
Access it has to be then. Best have a look at Office 2007 I suppose.
>
Thanks again.

[Tim Patrick]

That's funny. If you had actually ever read the book, you would know that
there are no "examples" at all. That's one of the main points of the book.
The code presented in the book doesn't depend on short samples. It presents
one large example that is built throughout the entire text.

Just because we disagree on some decisions made by Microsoft, why do you
find it necessary to specifically target my work with lies?

-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot
of playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

>Thanks for the prompt reply, but I really do mean that there can be
no server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation .

[rowe_newsgroups]

I recommend you look around for different books on the subject, I

usualy find Amazon the best place.

Hehe, nice one Master Programmer. Although didn't you say in another
post "I don't read tech books, I don't need to"?

I would steer clear of the VB book by Tim Patrick though

I doubt you even read the book, you're probally just "Tim bashing"
because he constantly demonstrates that you don't have any idea what
your talking about when it comes to VB.Net

I found it over-complex

Maybe it's because you're not a good programmer? Oh, and if you want to
prove me wrong please post your real name, and some of the companies
you've worked for. (Although I doubt you'll go into any verifiable
detail if you even address my question.)

Thanks,

Seth Rowe
Sorry I don't have any aliases :-(
ra********@asia .com wrote:

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot of
playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.

[aaron.kempf]

listen guys

we're bashing VB.net because it's a dead fucking language kids

get a clue renobs

C# is 5 times more popular than VB.net; this is mainly because
Microsoft has given C# 'preferred status' and pretty much ignored
VB.net

the funny thing is that all the schools and universities are still
churning out VB.net poeple.. and nobody offers real training in C#

So yeah.. Microsofts 'programming language of the month' concept is
pretty much working against them

-Aaron
rowe_newsgroups wrote:

I recommend you look around for different books on the subject, I
usualy find Amazon the best place.

Hehe, nice one Master Programmer. Although didn't you say in another
post "I don't read tech books, I don't need to"?

I would steer clear of the VB book by Tim Patrick though

I doubt you even read the book, you're probally just "Tim bashing"
because he constantly demonstrates that you don't have any idea what
your talking about when it comes to VB.Net

I found it over-complex

Maybe it's because you're not a good programmer? Oh, and if you want to
prove me wrong please post your real name, and some of the companies
you've worked for. (Although I doubt you'll go into any verifiable
detail if you even address my question.)

Thanks,

Seth Rowe
Sorry I don't have any aliases :-(
ra********@asia .com wrote:

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot of
playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.

[aaron.kempf]

the bottom line is that I used to be able to use one language-- for all
tasks.. from Excel macros to outlook macros to clientside and server
side.

now i can't do jack shit with the difference between VB.net and
vbScript.

I don't want to 'translate' all of my code and maintain it in 2
different dialects.

and these fuckers are mandating that we now do 3 langauges--
JavaScript; C# and VB.net.. (in additon to VBS / VBA / VB6)

so instead of having ONE CODEBASE; I NEED FOUR

take this language and SHOVE IT

And Tim; if you're writing books in support of VB.net you might as well
be a friggin murderer-- you're placating the devil himself.

Tim Patrick may be one of the few people out here that has the tools
necessary to make VB.net a success.

but that ship has sailed; C# won the war... and Tim MOVEON.org write a
new book on C# fag

-Aaron
rowe_newsgroups wrote:

I recommend you look around for different books on the subject, I
usualy find Amazon the best place.

Hehe, nice one Master Programmer. Although didn't you say in another
post "I don't read tech books, I don't need to"?

I would steer clear of the VB book by Tim Patrick though

I doubt you even read the book, you're probally just "Tim bashing"
because he constantly demonstrates that you don't have any idea what
your talking about when it comes to VB.Net

I found it over-complex

Maybe it's because you're not a good programmer? Oh, and if you want to
prove me wrong please post your real name, and some of the companies
you've worked for. (Although I doubt you'll go into any verifiable
detail if you even address my question.)

Thanks,

Seth Rowe
Sorry I don't have any aliases :-(
ra********@asia .com wrote:

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot of
playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.

[RobinS]

That's pretty entertaining, MasterProgramme r. I doubt you've
even read Mr. Patrick's book. As you know from my postings,
I've found it to be a very good book for people starting out
in VB2005. Through the building of a complete application,
it explains everything from data types to class inheritance,
and shows how (and why) to implement it.

Robin S.
(not to be confused with Robinson or Tim Patrick)
--------------------------------------------------------
<ra********@asi a.comwrote in message
news:11******** *************@l 12g2000cwl.goog legroups.com...

Hi Kavsak

I recommend you look around for different books on the subject, I
usualy find Amazon the best place. I would steer clear of the VB book
by Tim Patrick though, I found it over-complex and not very well
written. Also some of the examples did't work properly without a lot of
playing around with the code.

Good Luck
Steve Ray Irwin
kavsak wrote:

>Thanks for the prompt reply, but I really do mean that there can be no
server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation .

[RobinS]

Hmmm. They delayed Vista, and delayed Vista, and delayed Vista,
and yet they still released it. There appears to be a flaw
in your logic.

Robin S.
-------------------------------
<aa*********@gm ail.comwrote in message
news:11******** **************@ j44g2000cwa.goo glegroups.com.. .

Ii totally agree.

even the bumbling kids over in redmond couldn't have done this
accidently

vb.net has almost been killed off already

do you know how they delayed sp5 for windows 2000 and then they delayed
sp3 for windows xp and then they delayed sp1 for visual studio 2003 /
2005??

it's because they're discontinuing the product

in ms parlance, delaying a service pack means that they're killing the
program

read it and weep bitches; there will never be windows xp sp3 or vs 2003
sp1 or vs 2005 sp1

they fucked us all on not coming out with sp5 for windows 2000-- they
just dont give a shit about previous versions and obsolete languages;
and according to ms; vb.net is an obsolete language


Master Programmer wrote:

>This is true, I also have reliable info that VB will be discontinued in
VS 9.0. They (MS) just included a crappy crippled version of VB
temporarily in the current VS version to try to get all of the VB 6.0
programmers to move across to C#. But most VB programmers can't stand
it and (rightly so) feel cheated.

C# (and VB.NET) were created by a load of acedemic type C++ faggots at
Microsoft. They didn't understand thier user base properly. Now MS are
getting royaly shafted as nearly all VB 6.0 users move away to other
languages - as most hate VB.NET.

Steve Ray Irwin
aa*********@gma il.com wrote:

THEN JUST USE ACCESS DATA PROJECTS

lose the fucking training wheels; and don't bother with .NET

from what I hear; VB.net is going to be discontinued in the next
release
I had a friend from Microsoft that told me about this

VB6 was a 'more complete package' and VB.net can't compete with C#
because those geniuses didn't understand that they could just call it
VB# and everyone would have been 10 times happier

-Aaron


kavsak wrote:
Thanks guys.

I need to rewrite it sooner rather than later to maintain my sanity,
because it is expected to last for another 20 years. The front end
has
40000 lines of code and and the back end stores 100000 records with a
regular need to import and manipulate external Access databases of up
to 500Mb in size. What runs where is mandated by men in black.

Access it has to be then. Best have a look at Office 2007 I suppose.

Thanks again.

[RobinS]

But he should upgrade to the most current version of Access,
not leave it in Access97. (Yikes!)

Robin S.
-------------------------------------
"Paul Clement" <Us************ ***********@sws pectrum.comwrot e in message
news:nt******** *************** *********@4ax.c om...

On 1 Dec 2006 12:53:18 -0800, "kavsak" <st**********@b topenworld.com>
wrote:

¤ Hi. Not sure that this is the right place to ask but here goes.
¤
¤ I have an application based on access97 and VB6 which I need to
¤ upgrade. It has to handle up to 20 concurrent users on a Win2k network
¤ ( to be upgraded to XP next year) which has no connection to the
¤ outside world, but normally there are no more than 2. It has
¤ approximately 150 tables with complicated validation rules and a large
¤ amount of calculation. I want to rewrite it in VB net or C# with a
¤ suitable modern database. So I far I have 3 weeks experience of the
¤ .Net world.
¤
¤ I am not permitted to run any form of central database server, but data
¤ tables must (?) be held on the network server to provide the multi user
¤ capability. It must also be possible to transfer the application and
¤ its database to a standalone laptop for use in other locations.
¤
¤ Can I use SQL Server in any form as this seems to be the best match for
¤ VS2005 or do I have to continue to use Access?

Given the requirements you've stated I would stick with your Microsoft
Access database
implementation. Since you can't operate in a server based environment that
would eliminate both SQL
Server and SQL Server Express from consideration. Since you're already
using Access you may as well
stick with it instead of moving to another file based database.
Paul
~~~~
Microsoft MVP (Visual Basic)