HighTechTalks DotNet Forums  

Access vs vb.net/ado.net

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet


Discuss Access vs vb.net/ado.net in the Dotnet Framework (ADO.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old   
sloan
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-25-2007 , 10:27 AM







I think calling it "Access Database" or "Jet database" may be a little
picky, esp for the original poster who we're trying to help, and not pick at
exact syntaxes.
I'm not going to argue whether you're right or wrong, because ... you are
"right".

And yes, you are right that you don't have to have the program installed to
work with a Jet database. But it makes it much more complicated.
You can create tables through code, and relationships, but my guess is that
most people who are considering using a Jet database, are still at the level
of creating Tables via the GUI of the program, and not via code.

So for the OP, I apologize miscueing on a few of my syntaxes, but I hope my
posts have tried to help your situation.

...

Access...I'm sorry....Jet databases ... are NOT true RDBMS, like Sql Server
or Oracle or etc, etc.

But sometimes they make sense. Or if you plan correctly, you can start
there, but still move up to another database.




"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote

Quote:
"Scott M." <s-mar (AT) nospam (DOT) nospam> schrieb

Access is two things at the same time. So you gotta distinquish.

Well, actually no, it's not - so you don't.

I think it is important to distinguish. Some people think, using the Jet
requires Access being installed.

There's the database, Access. This is when you put tables in
there, like Employee
Department
JobTitles

No, that's actually a JET database. There is actually no such real
thing as an "Access database". Sure, people call it that, but it's
really a JET database.

An MDB file has always been called an "Access database". I'd still call an
MDB file being in Access database format.


Armin



Reply With Quote
  #12  
Old   
John
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-25-2007 , 12:15 PM






Thanks sloan.

Regards

"sloan" <sloan (AT) ipass (DOT) net> wrote

Quote:
I think calling it "Access Database" or "Jet database" may be a little
picky, esp for the original poster who we're trying to help, and not pick
at exact syntaxes.
I'm not going to argue whether you're right or wrong, because ... you are
"right".

And yes, you are right that you don't have to have the program installed
to work with a Jet database. But it makes it much more complicated.
You can create tables through code, and relationships, but my guess is
that most people who are considering using a Jet database, are still at
the level of creating Tables via the GUI of the program, and not via code.

So for the OP, I apologize miscueing on a few of my syntaxes, but I hope
my posts have tried to help your situation.

..

Access...I'm sorry....Jet databases ... are NOT true RDBMS, like Sql
Server or Oracle or etc, etc.

But sometimes they make sense. Or if you plan correctly, you can start
there, but still move up to another database.




"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote in message
news:O1zFjCwFIHA.700 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
"Scott M." <s-mar (AT) nospam (DOT) nospam> schrieb

Access is two things at the same time. So you gotta distinquish.

Well, actually no, it's not - so you don't.

I think it is important to distinguish. Some people think, using the Jet
requires Access being installed.

There's the database, Access. This is when you put tables in
there, like Employee
Department
JobTitles

No, that's actually a JET database. There is actually no such real
thing as an "Access database". Sure, people call it that, but it's
really a JET database.

An MDB file has always been called an "Access database". I'd still call
an MDB file being in Access database format.


Armin





Reply With Quote
  #13  
Old   
sloan
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-25-2007 , 03:49 PM




The biggest thing is
"Cost of maintenance".

If you plan out a new application decently, the future costs of adding a
feature, making it support more users will be less, then by keep on hacking
onto an existing Access application.

People think software costs are the development costs. WRONG.
The costs are the maintenance costs.

..Net is the now and future of MS development. You don't want to do a VB6
app (from start) ... and you don't want to create an Access Application.

There is much more wealth of knowledge on the internet about .Net
development. This alone is a benefit. When you need to get something to
work, eventually you will find it on the internet with a dotnet application.

If they outvote you, find another job.




"John" <John (AT) nospam (DOT) infovis.co.uk> wrote

Quote:
Hi

What are the advantages of writing an app in vb.net/ado.net as opposed to
MS Access? I need this to sell the idea to the management.

Many Thanks

Regards




Reply With Quote
  #14  
Old   
Jim Rand
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-25-2007 , 04:44 PM



This is not meant as a slight, but if you don't already know the answer to
this question, you are not ready to sell the idea to management.

Moving to .NET is not trivial. The learning curve is incredibly steep. I
must say, however, the results are well worth the journey.

"John" <John (AT) nospam (DOT) infovis.co.uk> wrote

Quote:
Hi

What are the advantages of writing an app in vb.net/ado.net as opposed to
MS Access? I need this to sell the idea to the management.

Many Thanks

Regards




Reply With Quote
  #15  
Old   
Cor Ligthert[MVP]
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-26-2007 , 08:10 AM



Quote:
An MDB file has always been called an "Access database". I'd still call an
MDB file being in Access database format.


However that was not in the thread before you wrote it. There was written
"there is a database, Access" which was nearest to your reply.

Scott is in my idea very correct with his answer. Using Access is more than
using a database, it is a complete enviroment for endusers and developpers
while databases can pretend to be that, however seldom are. Therefore is in
my idea the question not to answer. It relies on what the company wants with
development.

Cor



Reply With Quote
  #16  
Old   
Armin Zingler
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-26-2007 , 09:17 AM



"Cor Ligthert[MVP]" <notmyfirstname (AT) planet (DOT) nl> schrieb
Quote:
An MDB file has always been called an "Access database". I'd still
call an MDB file being in Access database format.


However that was not in the thread before you wrote it. There was
written "there is a database, Access" which was nearest to your
reply.

Scott is in my idea very correct with his answer. Using Access is
more than using a database, it is a complete enviroment for endusers
and developpers while databases can pretend to be that, however
seldom are. Therefore is in my idea the question not to answer. It
relies on what the company wants with development.

I don't understand what you wanna say. It was only about the term "jet
database" vs "access database". Call it whatever you want. And I agreed with
"sloan" because he distinguishes between the database file (mdb) and the
database application (Access). That's all I said.


Armin



Reply With Quote
  #17  
Old   
Cor Ligthert[MVP]
 
Posts: n/a

Default Re: Access vs vb.net/ado.net - 10-26-2007 , 01:54 PM



Quote:
I don't understand what you wanna say. It was only about the term "jet
database" vs "access database". Call it whatever you want. And I agreed
with "sloan" because he distinguishes between the database file (mdb) and
the database application (Access). That's all I said.

And all I said is that Scott M is in my idea very correct in his response.

Cor



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.