Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / September 2006

Tip: Looking for answers? Try searching our database.

Migrating Access apps to Microsoft.NET...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Soddy - 27 Sep 2006 04:07 GMT
Hello!

Hopefully I got the right discussion group here...!

In using the SQL Server Migration Assistant for Access instructions, I have
completed the split Access 2003 database migration to the SQL Server 2005.  
Under the 'Preparing Access Databases for Migration' part of these
instructions, it says "After you migrate databases to SQL Server 2005, you
can continue to use Access by using linked tables (understand this), or you
can manually migrate your applications to Microsoft.NET Framework-based code
that interacts directly with SQL Server".  Not sure I'm understanding this
part...??

Signature

Thanks!
Soddy

Brendan Reynolds - 27 Sep 2006 09:32 GMT
I don't wish to appear to give a 'flip' answer, but the statement does seem
to me to be self-explanatory. I'm not sure what the question is. Could you
perhaps expand a little on what additional information it is that you're
looking for?

Signature

Brendan Reynolds
Access MVP

> Hello!
>
[quoted text clipped - 11 lines]
> that interacts directly with SQL Server".  Not sure I'm understanding this
> part...??
Nikos Yannacopoulos - 27 Sep 2006 11:56 GMT
Soddy,

If I understand your question correctly, what this says is, once you
have migrated your data to SQL server, you can move away from Access
altogether - that is, for the front end also. For the latter, you can
develop a new one using a .Net language such as VB.Net, for example.

There are merits to this (such as higher portability / no need for full
Access or Access runtime, much better protection of your app against the
prying eye, no more FE corruptions or need for compaction etc), but
"migrate" is really the understatement of the year here... it actually
requires you to re-make the front end from scratch, in an environment
that is quite different to Access, and more time-consuming to develop
in, with no re-usability from the existing Access app. If you really
need the advantages of .Net over Access, be prepared to invest serious
time in (a) learning a new programming tool and (b) developing!

HTH,
Nikos
Soddy - 27 Sep 2006 15:34 GMT
Hello!

Brendan...  Sorry for not a more pointed question... But Nikos answered what
I was looking for...  So, thanks alot for the responses!

What is your opinion of, i.e. Visual Basic Express, etc, in this environment?

Signature

Thanks!
Soddy

> Soddy,
>
[quoted text clipped - 15 lines]
> HTH,
> Nikos
Douglas J. Steele - 27 Sep 2006 22:18 GMT
I think you'll find most of us feel Access makes a better front-end than
.Net applications.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hello!
>
[quoted text clipped - 24 lines]
>> HTH,
>> Nikos
Soddy - 27 Sep 2006 23:58 GMT
Hello!

Thanks for the info...!!  And, so I'm interested in 'hearing' opinions on
why people feel that Access makes a better front-end than .NET (and because
I'm a Newbie, also i.e. Visual Basic/Visual C# Express, etc.)
applications...??

Signature

Thanks!
Soddy

> I think you'll find most of us feel Access makes a better front-end than
> ..Net applications.
[quoted text clipped - 27 lines]
> >> HTH,
> >> Nikos
Douglas J. Steele - 28 Sep 2006 01:40 GMT
The controls available for forms in Access are explicitly intended to be
used with data being returned from databases. While there were some bound
controls available in VB, they weren't nearly as good, and so it took a lot
longer to develop applications using VB than Access. While the bound
controls available in .Net (which all the Express languages are) are better,
empirical experience shows that it's significantly faster to develop in
Access.

An additional benefit of Access is that it has very robust reporting
capabilities. Creating reports in .Net is a lot of work.

Hopefully others will pipe in with their experiences.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hello!
>
[quoted text clipped - 37 lines]
>> >> HTH,
>> >> Nikos
Brendan Reynolds - 28 Sep 2006 09:32 GMT
I think it is important to define the type of application we're discussing.
There are types of application for which Access is the best choice, and
there are types of application for which .NET is the best choice. How and by
whom the app will be developed is also a factor.

Access, in my opinion, remains the best choice for the type of application
for which Access has traditionally been used - a front-end Windows desktop
application to a database, running on a LAN, developed by a single
developer. .NET is a good choice for Web apps, for mobile apps, and for
distributed apps, and for development efforts in which the work must be
divided and coordinated among a large group of developers.

I'm not suggesting that Access can *only* be used in the conditions I
describe above. In between those two ends of the spectrum there is, of
course, a wide 'gray area' where the pros and cons have to be carefully
balanced and judgements made.

Whether you use VB.NET or C# or both for .NET development is mostly a matter
of personal preference. I personally prefer C#, but I'd have a hard time
trying to explain why. C# feels more 'elegant' to me, but there isn't
anything I need to do that couldn't be done in VB.NET.

Signature

Brendan Reynolds
Access MVP

> Hello!
>
[quoted text clipped - 37 lines]
>> >> HTH,
>> >> Nikos
Soddy - 28 Sep 2006 16:29 GMT
Hello!

Thanks alot for the info...!  This 'is' very good help for me as I hear/read
a bit and it seems they have preferences but not necessarily for the
development environment!  

I have worked a little bit with Access 97 and now am playing with Access
2003.  If there are 'items' to watch out for (in upgrading to Access 2003
from Access 97), I would like to hear about some.

Signature

Thanks!
Soddy

> Hello!
>
[quoted text clipped - 8 lines]
> that interacts directly with SQL Server".  Not sure I'm understanding this
> part...??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.