[AccessD] Access 2007 Again

Hewson, Jim JHewson at nciinc.com
Tue Mar 10 12:53:52 CDT 2009


I started using A2007 because of the free download of the runtime.  I
needed the runtime for a non-profit that's budget is next to nil.
Anyway there are a few things that I like.  Each date field has a date
picker (a little calendar) that is easy to use.  Another thing, is each
form has search capability that the user can search by a specific field
or by the record set behind the form.

I also needed to be able to have an Access database shared by several
geographically separated (three different states) users.  I was able to
convert the database to 2007 from 2003 and migrate it to SharePoint.  I
also work as a SharePoint Administrator.  The process was for the user
to download the Access database from the SharePoint site to their
machine.  Once downloaded, Access used SharePoint as the data
repository.  Updating records from the various locations is "real"
time... that is it is quick but not as quick as if on a network.  But,
it is usable.

There a few subtle differences in the VB code but not much.  One
difference is the connecting to the backend to create and modify tables.
If coding in A2003, then open A2007 you get an error... but if you open
the code in the VB edit in A2007 it will tell you what changes need to
be made for A2007.  OBTW... the changes work in A2003 - go figure. 

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys
Sent: Tuesday, March 10, 2009 12:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 Again

Max,

I think there's a bunch of Interop stuff you can do with .Net that
Access 
2007 handles 'better.'
Not sure 'cause I haven't tried - nor have I used SharePoint for which I
see 
a DoCmd.RunCommands ...

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, March 10, 2009 1:14 PM
Subject: Re: [AccessD] Access 2007 Again


> Thanks Rocky.
>
> Anybody got any other thoughts please?
>
> Max
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
Smolin at
> Beach Access Software
> Sent: 10 March 2009 16:33
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Access 2007 Again
>
> I don't think you'll find any 2007 fans on this list.  I still develop
in
> 2003 for the same reason.  Can't figure out how 2007 works - don't
have a
> compelling reason to use it. I have 2007 loaded on another machine
just 
> for
> testing.  But all the 03 stuff works on 07 just dandy.
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Tuesday, March 10, 2009 9:27 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Access 2007 Again
>
> Hi List,
> I am about to throw in the towel with Access 2007. I find it so
incredibly
> hard to work with - as I have often mentioned before.
> Before I actually do that, can I ask this questions...
>
> Is there anything that is a real improvement over 2003?  Either that I
can
> bring to the development for the end-user that I cannot do in 2003 or
that
> makes the development easier than 2003 (I think I know the answer to
that
> one!).
>
> I don't want to shoot myself in the foot here.  If, beneath the skin,
the
> development side is not basically the same (not talking about cosmetic
> stuff, but has real substantially improved dev stuff) then I will need
to
> take that on board.
>
> I am not looking for a List of differences - just your gut reactions 
> please.
>
> Thank you
>
> Max
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################




More information about the AccessD mailing list