Ms Access and .Net?

[marslee]

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

[Tom van Stiphout]

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

[Salad]

Tom van Stiphout wrote:

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.
Hi Tom,

In the movies Every Which Way But Loose and Any Which Way You Can, Philo
Beddoe (Clint Eastwood) is harrassed by a degenerate group of losers;
the Black Widows Motorcycle club..."known and feared across the land".
In one instance, as the members plot their revenge against Philo, the
leader of the group realizes he is surrounded by dolts and exclaims "Oh
Lord, why have you given me this burden!?!?"

Which reminds me of yesterday. My friend had someone at his office and
was demonstrating our program. This person has been working with
another company and their program is written in FoxPro and is currently
being ported to the .Net environment. When the person discovered our
program was written in Access, the person exhibited some concern that it
was written in Access. I'm not sure what the concern was...perhaps that
the person considers Access is a weak database mgt program and is not a
..Net app. Is .Net to be known and feared by Access developers or is the
person my friend demo'd the program to a dolt that gives us burdens?

I ask since the reaction surprised me. This person was shown a very
powerful and flexible program. At this point, I think my friend should
have told the person intitially it was written in VB simply to calm the
nerves instead of Access. I view it irrelevant regarding what language
was used to produce an application, it is how useful the application is
to the user. As a developer, I might be interested in the environment
used to create an app but not much more beyond that. IOW, if an app was
created in C++ and another in VB and they both performed the functions I
wanted, I really wouldn't care which environment was used to create the app.

For these reasons, I really don't don't put much stock in the person's
concerns. Our program is not targetted, and never will be, for
companies where 100s of users will be accessing it. It is targetted for
small companies of 20 persons or less.

So...am I wrong? Should I be concerned about an Access app vs a .Net
app? If so, why?

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

[Rich P]

You can interface with Access from a .Net app using ADO.Net the same as
interfacing with Sql Server. For Access you use the OLEDB data objects.
For Sql Server you use the Sql data objects. You can also interface
with Access using Com Automation - make the reference to the Access
library (for your version of Access) and use CreateObject, GetObject.

I have several .Net apps in VB.Net and C# that interface with Access and
Sql Server very nicely. For refined datasets (smaller than 50,000
records) there is just no substition for the ease of use that Access
provides for processing data. Much easier than having to write fancy
stored procedures in Sql Server to invoke through your .Net app. You
can retrieve the query results from Access using an OLEDBdataAdapter and
dataset from the .Net app, read that into a Dataview Object, display the
data in a datagrid. You get the same flexibility with the datagrid that
you would get from an Access form. So why even bother with .Net? If
you have to run multiple procedures at the same time - multi-threading -
this is where .Net rules. Like if you have to retrieve data from
several Access databases at the same time (or Sql Server DB's), you can
achieve this with multi-threading. Access is another component (vital
component) in the machinery.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Trevor Best]

ma*****@hotmail.com wrote:

One of the my professor gave final question like this

I wish I had the internet when I had homework instead of actually having
to do some bloody work for my exams.

--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d

[David W. Fenton]

Tom van Stiphout <no*************@cox.net> wrote in
news:m5********************************@4ax.com:

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of
data?"

I have no idea what it is about since he never taught about .NET
in the lecture.
Does anyone know the answer?

Your driving instructor never had you drive through that
particular street near the ballpark. Yet after you got your
license, and you came upon that street, you knew how to navigate
it.

Well, seems to me it's a trick question, as .NET *can't* use an
"Access" database.

It can certainly use a *Jet* database, though.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Tom van Stiphout]

On Wed, 18 May 2005 17:05:23 GMT, Salad <oi*@vinegar.com> wrote:

Hi Salad,
I mostly agree with you, and it appears Access (better: Jet) is a good
database for your application. Test your app with realistic work
loads, and if it performs well, be happy you wrote it in the best RAD
tool on the planet.
I can understand that .Net - centric people shy away from Access: MSFT
hasn't really made Access an equal player when promoting .Net. Rather
they focussed mostly on enterprise applications with a SQL Server
backend. Also they focussed mostly on web apps, where admittedly Jet
is a minor player, and not designed to handle higher user loads.

-Tom.

Tom van Stiphout wrote:

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.

Hi Tom,

In the movies Every Which Way But Loose and Any Which Way You Can, Philo
Beddoe (Clint Eastwood) is harrassed by a degenerate group of losers;
the Black Widows Motorcycle club..."known and feared across the land".
In one instance, as the members plot their revenge against Philo, the
leader of the group realizes he is surrounded by dolts and exclaims "Oh
Lord, why have you given me this burden!?!?"

Which reminds me of yesterday. My friend had someone at his office and
was demonstrating our program. This person has been working with
another company and their program is written in FoxPro and is currently
being ported to the .Net environment. When the person discovered our
program was written in Access, the person exhibited some concern that it
was written in Access. I'm not sure what the concern was...perhaps that
the person considers Access is a weak database mgt program and is not a
.Net app. Is .Net to be known and feared by Access developers or is the
person my friend demo'd the program to a dolt that gives us burdens?

I ask since the reaction surprised me. This person was shown a very
powerful and flexible program. At this point, I think my friend should
have told the person intitially it was written in VB simply to calm the
nerves instead of Access. I view it irrelevant regarding what language
was used to produce an application, it is how useful the application is
to the user. As a developer, I might be interested in the environment
used to create an app but not much more beyond that. IOW, if an app was
created in C++ and another in VB and they both performed the functions I
wanted, I really wouldn't care which environment was used to create the app.

For these reasons, I really don't don't put much stock in the person's
concerns. Our program is not targetted, and never will be, for
companies where 100s of users will be accessing it. It is targetted for
small companies of 20 persons or less.

So...am I wrong? Should I be concerned about an Access app vs a .Net
app? If so, why?

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

[Salad]

Tom van Stiphout wrote:

On Wed, 18 May 2005 17:05:23 GMT, Salad <oi*@vinegar.com> wrote:

Hi Salad,
I mostly agree with you, and it appears Access (better: Jet) is a good
database for your application. Test your app with realistic work
loads, and if it performs well, be happy you wrote it in the best RAD
tool on the planet.
Yup.
I can understand that .Net - centric people shy away from Access: MSFT
hasn't really made Access an equal player when promoting .Net. Rather
they focussed mostly on enterprise applications with a SQL Server
backend. Also they focussed mostly on web apps, where admittedly Jet
is a minor player, and not designed to handle higher user loads.
In my case, I see a need in the future to porting the app to SQL server.
...the SQL server to hold data entered from the office and using the
data contained in the server for fetching data in a wireless app using
the web for field workers but not for data entry...IOW separate components.

I appreciate your opinion.

-Tom.

Tom van Stiphout wrote:

On 18 May 2005 03:10:15 -0700, ma*****@hotmail.com wrote:

Your driving instructor never had you drive through that particular
street near the ballpark. Yet after you got your license, and you came
upon that street, you knew how to navigate it.

-Tom.

Hi Tom,

In the movies Every Which Way But Loose and Any Which Way You Can, Philo
Beddoe (Clint Eastwood) is harrassed by a degenerate group of losers;
the Black Widows Motorcycle club..."known and feared across the land".
In one instance, as the members plot their revenge against Philo, the
leader of the group realizes he is surrounded by dolts and exclaims "Oh
Lord, why have you given me this burden!?!?"

Which reminds me of yesterday. My friend had someone at his office and
was demonstrating our program. This person has been working with
another company and their program is written in FoxPro and is currently
being ported to the .Net environment. When the person discovered our
program was written in Access, the person exhibited some concern that it
was written in Access. I'm not sure what the concern was...perhaps that
the person considers Access is a weak database mgt program and is not a
.Net app. Is .Net to be known and feared by Access developers or is the
person my friend demo'd the program to a dolt that gives us burdens?

I ask since the reaction surprised me. This person was shown a very
powerful and flexible program. At this point, I think my friend should
have told the person intitially it was written in VB simply to calm the
nerves instead of Access. I view it irrelevant regarding what language
was used to produce an application, it is how useful the application is
to the user. As a developer, I might be interested in the environment
used to create an app but not much more beyond that. IOW, if an app was
created in C++ and another in VB and they both performed the functions I
wanted, I really wouldn't care which environment was used to create the app.

For these reasons, I really don't don't put much stock in the person's
concerns. Our program is not targetted, and never will be, for
companies where 100s of users will be accessing it. It is targetted for
small companies of 20 persons or less.

So...am I wrong? Should I be concerned about an Access app vs a .Net
app? If so, why?

One of the my professor gave final question like this

"How to use Access database in .Net enivronment to keep track of data?"

I have no idea what it is about since he never taught about .NET in the
lecture.
Does anyone know the answer?

[David Schofield]

On Wed, 18 May 2005 17:38:05 GMT, Rich P <rp*****@aol.com> wrote:

(snip) You get the same flexibility with the datagrid that
you would get from an Access form. ......

Hi
Really? Maybe I should look into this.
David

[David Schofield]

Hi
VB programmers always looked down on Access programmers and C
programmers looked down on VB programmers. I'm old enough to remember
when assembly progarmmers looked down on C programmers. Its just one
of those things you had to get used to.
David

[Bob Alston]

David Schofield wrote:

On Wed, 18 May 2005 17:38:05 GMT, Rich P <rp*****@aol.com> wrote:

(snip) You get the same flexibility with the datagrid that
you would get from an Access form. ......

Hi
Really? Maybe I should look into this.
David

The statement that "You get the same flexibility with the datagrid that
you would get from an Access form" is not correct. Datagrids are nice
but have a fixed layout. Forms allow you much more control over data
presentation.

Also, there are several programs out there to convert Access databases
to .NET (and some that are just asp and not .NET). Take a look:

http://members.cox.net/tulsaalstons/...20Internet.htm

http://members.cox.net/tulsaalstons/...onSoftware.htm

Bob

[David Schofield]

On Thu, 19 May 2005 13:41:42 -0500, Bob Alston
<tu****************@cox.net> wrote:

David Schofield wrote:

On Wed, 18 May 2005 17:38:05 GMT, Rich P <rp*****@aol.com> wrote:

(snip) You get the same flexibility with the datagrid that
you would get from an Access form. ......

Hi
Really? Maybe I should look into this.
David

The statement that "You get the same flexibility with the datagrid that
you would get from an Access form" is not correct. Datagrids are nice
but have a fixed layout. Forms allow you much more control over data
presentation.

Also, there are several programs out there to convert Access databases
to .NET (and some that are just asp and not .NET). Take a look:

http://members.cox.net/tulsaalstons/...20Internet.htm

http://members.cox.net/tulsaalstons/...onSoftware.htm

Bob

Hi
Yes, I was being part sarcastic and part hopeful - I am no doubt out
of date on grid capabilities.
Thanks for the references
David

[Trevor Best]

David Schofield wrote:

Hi
VB programmers always looked down on Access programmers and C
programmers looked down on VB programmers. I'm old enough to remember
when assembly progarmmers looked down on C programmers. Its just one
of those things you had to get used to.
David

Pah! to them all I say:

c:\>copy con program.exe

--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d

[Salad]

Trevor Best wrote:

1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d

I think I will. Thanks.