Connecting Tech Pros Worldwide Help | Site Map

Ms Access and .Net?

  #1  
Old November 13th, 2005, 11:03 AM
marslee@hotmail.com
Guest
 
Posts: n/a
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?

  #2  
Old November 13th, 2005, 11:04 AM
Tom van Stiphout
Guest
 
Posts: n/a

re: Ms Access and .Net?


On 18 May 2005 03:10:15 -0700, marslee@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.

[color=blue]
>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?[/color]

  #3  
Old November 13th, 2005, 11:04 AM
Salad
Guest
 
Posts: n/a

re: Ms Access and .Net?


Tom van Stiphout wrote:[color=blue]
> On 18 May 2005 03:10:15 -0700, marslee@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.[/color]

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?
[color=blue]
>
>
>[color=green]
>>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?[/color]
>
>[/color]
  #4  
Old November 13th, 2005, 11:04 AM
Rich P
Guest
 
Posts: n/a

re: Ms Access and .Net?


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 ***
  #5  
Old November 13th, 2005, 11:04 AM
Trevor Best
Guest
 
Posts: n/a

re: Ms Access and .Net?


marslee@hotmail.com wrote:[color=blue]
> One of the my professor gave final question like this[/color]

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

  #6  
Old November 13th, 2005, 11:05 AM
David W. Fenton
Guest
 
Posts: n/a

re: Ms Access and .Net?


Tom van Stiphout <no.spam.tom7744@cox.net> wrote in
news:m5hm815gbbo54g13mo3rclfspji671i4o4@4ax.com:
[color=blue]
> On 18 May 2005 03:10:15 -0700, marslee@hotmail.com wrote:[/color]
[color=blue][color=green]
>>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?[/color]
>
> 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.[/color]

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
  #7  
Old November 13th, 2005, 11:05 AM
Tom van Stiphout
Guest
 
Posts: n/a

re: Ms Access and .Net?


On Wed, 18 May 2005 17:05:23 GMT, Salad <oil@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.

[color=blue]
>Tom van Stiphout wrote:[color=green]
>> On 18 May 2005 03:10:15 -0700, marslee@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.[/color]
>
>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?
>[color=green]
>>
>>
>>[color=darkred]
>>>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?[/color]
>>
>>[/color][/color]

  #8  
Old November 13th, 2005, 11:06 AM
Salad
Guest
 
Posts: n/a

re: Ms Access and .Net?


Tom van Stiphout wrote:[color=blue]
> On Wed, 18 May 2005 17:05:23 GMT, Salad <oil@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.[/color]

Yup.
[color=blue]
> 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.[/color]

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.
[color=blue]
>
> -Tom.
>
>
>[color=green]
>>Tom van Stiphout wrote:
>>[color=darkred]
>>>On 18 May 2005 03:10:15 -0700, marslee@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.[/color]
>>
>>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?
>>
>>[color=darkred]
>>>
>>>
>>>>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?
>>>
>>>[/color][/color]
>[/color]
  #9  
Old November 13th, 2005, 11:07 AM
David Schofield
Guest
 
Posts: n/a

re: Ms Access and .Net?


On Wed, 18 May 2005 17:38:05 GMT, Rich P <rpng123@aol.com> wrote:
[color=blue]
>(snip) You get the same flexibility with the datagrid that
>you would get from an Access form. ......[/color]

Hi
Really? Maybe I should look into this.
David

  #10  
Old November 13th, 2005, 11:07 AM
David Schofield
Guest
 
Posts: n/a

re: Ms Access and .Net?


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

  #11  
Old November 13th, 2005, 11:07 AM
Bob Alston
Guest
 
Posts: n/a

re: Ms Access and .Net?


David Schofield wrote:[color=blue]
> On Wed, 18 May 2005 17:38:05 GMT, Rich P <rpng123@aol.com> wrote:
>
>[color=green]
>>(snip) You get the same flexibility with the datagrid that
>>you would get from an Access form. ......[/color]
>
>
> Hi
> Really? Maybe I should look into this.
> David
>[/color]
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
  #12  
Old November 13th, 2005, 11:07 AM
David Schofield
Guest
 
Posts: n/a

re: Ms Access and .Net?


On Thu, 19 May 2005 13:41:42 -0500, Bob Alston
<tulsaalstonsNOSPAM@cox.net> wrote:
[color=blue]
>David Schofield wrote:[color=green]
>> On Wed, 18 May 2005 17:38:05 GMT, Rich P <rpng123@aol.com> wrote:
>>
>>[color=darkred]
>>>(snip) You get the same flexibility with the datagrid that
>>>you would get from an Access form. ......[/color]
>>
>>
>> Hi
>> Really? Maybe I should look into this.
>> David
>>[/color]
>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[/color]
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

  #13  
Old November 13th, 2005, 11:07 AM
Trevor Best
Guest
 
Posts: n/a

re: Ms Access and .Net?


David Schofield wrote:[color=blue]
> 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
>[/color]

Pah! to them all I say:

c:\>copy con program.exe

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

  #14  
Old November 13th, 2005, 11:07 AM
Salad
Guest
 
Posts: n/a

re: Ms Access and .Net?


Trevor Best wrote:

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

I think I will. Thanks.
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
.NET Windows Forms Application VS MS Access client Application Jordan S. answers 22 April 19th, 2006 06:35 AM
Opening a MS Access APP - if the SQL connection is not found... jonefer answers 6 January 19th, 2006 12:45 AM
Linking to an MS Access ADE Supa Hoopsa answers 4 November 20th, 2005 09:36 PM
databases.ms-access ....soft download com answers 1 November 13th, 2005 03:08 PM
Future of MS Access...... Ronnie answers 7 November 12th, 2005 08:16 PM