473,320 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access -> Visual Studio and the .Net Framework


Over the past several years I have had to deal with an increasing number of
problems involving setting up mdac, isams, service packs and the like on
client machines. Often these are not installed, not installed properly, or
not up-to-date. With 60 notebooks, there may be 30 distinct configurations.
Current Visual Studio (2005?) applications require the presence of the .Net
framework.

Has this lessened or increased the frequency of the problem I mentioned in
paragraph one occurring? Do you have experiences to share?

Further are you aware of any speculation that the requirement of this
framework’s existence is likely to lead to further legal problems for
Microsoft, based on the notion that since the framework is installed with
(or is part of) Windows 2003 Server and Windows Vista, Microsoft
development software will have an unfair advantage over other firm’s
development software?
--
lyle fairfield
Oct 26 '07 #1
10 1668
On Fri, 26 Oct 2007 11:03:39 GMT, lyle fairfield <ly******@yahoo.ca>
wrote:

The dotnet framework simplifies these matters tremendously, if you use
it. This is to say, you can still use ADO from your dotnet component.
Not recommended, but you can. Then of course all the dependencies
still apply.

The dotnet framework is automatically updated with Windows Updates. I
don't think mdac is/was.

ISAMs I don't know. Since afaik it's not built into the framework,
your mileage may vary.

The legal angle: I would not worry about. It will either not happen or
take many years to wind itself through the courts, with some
compromise at the end.

-Tom.
>
Over the past several years I have had to deal with an increasing number of
problems involving setting up mdac, isams, service packs and the like on
client machines. Often these are not installed, not installed properly, or
not up-to-date. With 60 notebooks, there may be 30 distinct configurations.
Current Visual Studio (2005?) applications require the presence of the .Net
framework.

Has this lessened or increased the frequency of the problem I mentioned in
paragraph one occurring? Do you have experiences to share?

Further are you aware of any speculation that the requirement of this
framework’s existence is likely to lead to further legal problems for
Microsoft, based on the notion that since the framework is installed with
(or is part of) Windows 2003 Server and Windows Vista, Microsoft
development software will have an unfair advantage over other firm’s
development software?
Oct 26 '07 #2
On Oct 26, 9:38 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Fri, 26 Oct 2007 11:03:39 GMT, lyle fairfield <lylef...@yahoo.ca>
wrote:

The dotnet framework simplifies these matters tremendously, if you use
it. This is to say, you can still use ADO from your dotnet component.
Not recommended, but you can. Then of course all the dependencies
still apply.

The dotnet framework is automatically updated with Windows Updates. I
don't think mdac is/was.

ISAMs I don't know. Since afaik it's not built into the framework,
your mileage may vary.
Are you able to compare the .Net framework with the Java Runtime
Environment on matters such as size, ease of installation,
capabilities, impact on other resident technologies and the other day-
to-day operations of the computer, integration with COM technologies,
and cross-platform applicability? Are they essentially the same kind
of thing?

Sorry, I see I've asked for a short book, but I find little on the net
about what the .Net Framework actually is and how it actually works.

So comments on any one of those issues might help me understand.

Oct 28 '07 #3
On Sun, 28 Oct 2007 04:03:23 -0700, lyle <ly************@gmail.com>
wrote:

Sorry, I'm stictly a microsofty.

The dotnet framework is essentially a huge class library, providing
the programmer with a very large number of classes to program against.
You name it, and there is a dotnet class encapsulating it. From a
String class or two to File Streams to Encryption to Graphics. Here is
a high-level overview:
http://msdn2.microsoft.com/en-us/library/hfa3fa08.aspx

DotNet also provides for easy memory management (a real problem with
COM) in that you essentially don't have to worry about freeing memory:
the garbage collector will come by and clean up after you. I
understand Java has a similar facility.

-Tom.
>On Oct 26, 9:38 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Fri, 26 Oct 2007 11:03:39 GMT, lyle fairfield <lylef...@yahoo.ca>
wrote:

The dotnet framework simplifies these matters tremendously, if you use
it. This is to say, you can still use ADO from your dotnet component.
Not recommended, but you can. Then of course all the dependencies
still apply.

The dotnet framework is automatically updated with Windows Updates. I
don't think mdac is/was.

ISAMs I don't know. Since afaik it's not built into the framework,
your mileage may vary.

Are you able to compare the .Net framework with the Java Runtime
Environment on matters such as size, ease of installation,
capabilities, impact on other resident technologies and the other day-
to-day operations of the computer, integration with COM technologies,
and cross-platform applicability? Are they essentially the same kind
of thing?

Sorry, I see I've asked for a short book, but I find little on the net
about what the .Net Framework actually is and how it actually works.

So comments on any one of those issues might help me understand.
Oct 29 '07 #4
Tom van Stiphout <no*************@cox.netwrote in
news:jc********************************@4ax.com:
first and foremost I am practical.
That's not how you appear here to me. First and foremost is smart, and
second is capable. Practical may be third.

--
lyle fairfield
Oct 29 '07 #5
Hi Lyle,

You have been such a great help to me that I though perhaps I might
have something to finally offer you in return. I use both Java
and .Net in my work, and I choose the tool dependant on the task and
destination environment.

In my company the possibility of having different 'standard installs'
is very common, same as it seems for yourself. I have to work with
about 60 machines, running mostly Win2K and a variety of apps and
service packs. MDAC is an issue for me as different versions are on
different machines and so I keep my apps to MDAC 2.8SP1 and I make
sure to install it by hand, myself so that I know it is there and
working properly. This of course does not guarantee that someone else
wont come along and murder it, and in my IT environment it is a
regular occurance.

I use the .Net framework, (same manual install as the MDAC problem)
for some simpler applications primarily written in VB.Net 2005 using
the ADO.Net capabilities. I have found that when working with Oracle 8
for example that I still need to install special components to be able
to talk properly with the servers. In short I find that the .Net
framework is very MS specific. So, depending on your target for
development and deployment it can be either a bonus or a curse.
Security settings for running .Net applications can also be a pain,
particularly when dealing with network situations and granting access
to resources - others may disagree with me on this but I find the
security model needlessly complex and convoluted even or the most
simple tasks. In short the sandbox is a little too small and hard to
build your castle in.

On the plus side for .Net, the framework gives you access to just
about everything you could want to do with a windows based machine. It
really is a very comprehensive set of tools to work with. In many
respects MS seem to have copied Java in the overprovision of tools to
meet a task. I think I read somewhere that there were 288,000 methods,
properties and events in the .Net framework. As far as development
goes, as long as you are comfortable with OO programming then you
shouldn't find too many problems building what you want.

With regards to Java, I find it a great tool for many tasks, as long
as you work to a particular runtime environment. Deploying the runtime
is pretty easy and doesnt seem to cause any problems with other apps
or on different platforms. I find Java incredibly flexible to work
with for scaling applications up to larger and larger tasks, and the
ability to create and deploy applets is a real boon, particulary for
network based applications. If you use something like Apache Tomcat or
JBoss as an application server for your applet you can scale very
easily to cater for very large demands.

On the downside for Java, although it is not impossible, it is
oftentimes hard to make a Java application 'Wintuitive', and working
with some of the MS file formats that are in common use can be a pain.
You end up attaching to your project lots of .jar files with the
needed code to talk to this file or that. The big difference here is
that you dont have to install the .jar, like you do with drivers or
MDAC stuff, you can just reference it in your project and ship
the .jar with it -job done.

In short I find each has its place, and that Java is at this stage, in
my opinion, superior to .Net for application development, especially
if you are considering server type applications. Perhaps this will
change with the MS developments of .Net into the future. I also find
that Java has one more little bonus - the ability to scale downwards
to portable devices such as phones and PDA's - which can be a really
nice thing to add to a project to keep the bosses happy and mobile
field staff efficient and productive.

I hope this small comparison is helpful to you. It is not often that I
have the opportunity to offer something to someone as experienced as
yourself, so consider this a small thankyou for all your help. And I
do hope you find it useful.

Cheers

The Frog

Oct 30 '07 #6
The Frog <Mr************@googlemail.comwrote in
news:11**********************@y42g2000hsy.googlegr oups.com:
Hi Lyle,

You have been such a great help to me that I though perhaps I might
have something to finally offer you in return. I use both Java
and .Net in my work, and I choose the tool dependant on the task and
destination environment.

In my company the possibility of having different 'standard installs'
is very common, same as it seems for yourself. I have to work with
about 60 machines, running mostly Win2K and a variety of apps and
service packs. MDAC is an issue for me as different versions are on
different machines and so I keep my apps to MDAC 2.8SP1 and I make
sure to install it by hand, myself so that I know it is there and
working properly. This of course does not guarantee that someone else
wont come along and murder it, and in my IT environment it is a
regular occurance.

I use the .Net framework, (same manual install as the MDAC problem)
for some simpler applications primarily written in VB.Net 2005 using
the ADO.Net capabilities. I have found that when working with Oracle 8
for example that I still need to install special components to be able
to talk properly with the servers. In short I find that the .Net
framework is very MS specific. So, depending on your target for
development and deployment it can be either a bonus or a curse.
Security settings for running .Net applications can also be a pain,
particularly when dealing with network situations and granting access
to resources - others may disagree with me on this but I find the
security model needlessly complex and convoluted even or the most
simple tasks. In short the sandbox is a little too small and hard to
build your castle in.

On the plus side for .Net, the framework gives you access to just
about everything you could want to do with a windows based machine. It
really is a very comprehensive set of tools to work with. In many
respects MS seem to have copied Java in the overprovision of tools to
meet a task. I think I read somewhere that there were 288,000 methods,
properties and events in the .Net framework. As far as development
goes, as long as you are comfortable with OO programming then you
shouldn't find too many problems building what you want.

With regards to Java, I find it a great tool for many tasks, as long
as you work to a particular runtime environment. Deploying the runtime
is pretty easy and doesnt seem to cause any problems with other apps
or on different platforms. I find Java incredibly flexible to work
with for scaling applications up to larger and larger tasks, and the
ability to create and deploy applets is a real boon, particulary for
network based applications. If you use something like Apache Tomcat or
JBoss as an application server for your applet you can scale very
easily to cater for very large demands.

On the downside for Java, although it is not impossible, it is
oftentimes hard to make a Java application 'Wintuitive', and working
with some of the MS file formats that are in common use can be a pain.
You end up attaching to your project lots of .jar files with the
needed code to talk to this file or that. The big difference here is
that you dont have to install the .jar, like you do with drivers or
MDAC stuff, you can just reference it in your project and ship
the .jar with it -job done.

In short I find each has its place, and that Java is at this stage, in
my opinion, superior to .Net for application development, especially
if you are considering server type applications. Perhaps this will
change with the MS developments of .Net into the future. I also find
that Java has one more little bonus - the ability to scale downwards
to portable devices such as phones and PDA's - which can be a really
nice thing to add to a project to keep the bosses happy and mobile
field staff efficient and productive.

I hope this small comparison is helpful to you. It is not often that I
have the opportunity to offer something to someone as experienced as
yourself, so consider this a small thankyou for all your help. And I
do hope you find it useful.

Cheers

The Frog
Hi Mr. Frog

Your response is just the kind of user reflection for which I had hoped.
I found it very thought-provoking, and saved it in my directory of
prrogramming resources and papers.

Thanks!

--
lyle fairfield
Oct 30 '07 #7
Anytime :-)

Oct 30 '07 #8
On Oct 30, 7:27 pm, The Frog <Mr.Frog.to....@googlemail.comwrote:
....
With regards to Java, I find it a great tool for many tasks, ... the
ability to create and deploy applets is a real boon, particulary for
network based applications.
You should check out Java Web Start. It offers 'all'* the benefits
of applets, but with few, if any of the usual head-aches that
applets can cause.

* Except maybe direct interaction with JavaScript, since JWS
apps. are not embedded within a web page, but free floating**.
....
On the downside for Java, although it is not impossible, it is
oftentimes hard to make a Java application 'Wintuitive', and working
with some of the MS file formats that are in common use can be a pain.
You end up attaching to your project lots of .jar files
JWS can help with this also, by allowing the extra jar's to be
deployed
'lazy'***, and downloaded by the client (and cached locally) as
required.

You also mentioned versioning - in some words I trimmed,

JWS is also good at checking for the required Java runtime
versions****.
** E.G.
<http://www.physci.org/jws/#jtest>
*** More an example of the JNLP API's DownloadService, but
uses Jar's that are deployed lazily.
<http://www.physci.org/jws/#ds>
**** More details
<http://www.physci.org/jws/version.html>

Andrew T.

Oct 31 '07 #9
On Oct 30, 5:27 am, The Frog <Mr.Frog.to....@googlemail.comwrote:
And I
do hope you find it useful.

Cheers

The Frog
I found your description enlightening as well. With my forays into
Java and .Net (C# instead of VB) just beginning, the timing of your
"mountaintop" view is particularly apt. I keep coming back to those
tools as the most versatile enablers of technology once a problem goes
beyond the purview of Access.

Thanks,

James A. Fortune
CD********@FortuneJames.com

Nov 1 '07 #10
The Frog <Mr************@googlemail.comwrote:
>Anytime :-)
Whoa, it doesn't get any better than Lyle saying he saved your posting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Nov 3 '07 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dave | last post by:
Hello NG, Regarding access-declarations and member using-declarations as used to change the access level of an inherited base member... Two things need to be considered when determining an...
0
by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
64
by: John | last post by:
Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. ...
0
by: com | last post by:
MS Access 2000 Password Recoverer 4.2 Screenshot - Soft30.com MS Access 2000 Password Recoverer will display the password to a MS Access database (*.mdb). This program works for MS Access files...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.