Re: Access 2010 article

"Bob Alston" <bobalston9@xxxxxxxxx> wrote in message
news:z74Jm.4562$Zu5.3629@xxxxxxxxxxxxxxx


Great Input. Keep it coming.

Are there other articles or documentation that you can now pass along,
perhaps things that were provided to you by Microsoft?


Hum, I have to check...I still under a NDA for things, but the embargo
on speaking about the new server features was lifted (It was lifted for
me during the SharePoint conference in las Vegas last week).

I got the idea that the new data triggors would work both in browser mode
as well as local mode. Can you clarify a bit?

Yes, they work for both desktop and web.

If you build a 100% desktop application that is based on VBA. Those new
table level
triggers will fire even if you open up a table using a dao reocrdset.

In fact, you can open up the accDB database file without access and use JET
(now
called ACE) and those table triggers and procedures will again run for you.
So
these data macros are true engine level triggers and code. This feature is
VERY
useful for desktop only applications.

This means we now have table level procedure code that runs at the table
level. This means we have stored procedures just like server based system
but in fact we don't have any server. I don't think there's any desktop
database system that has this procedural code type feature? (anyone???).

This also means that if you're running a standard split database on a
network with several users, the triggers + macro code will run!

Also, if you do decide to build a web based application, then again those
table level
procedures and triggers will publish (move) up to the web server
(SharePoint). They will thus then run if you use web forms to edit the data,
or client forms on the desktop that is linked to the SharePoint lists.

These data macros will thus run without you having to modify the
syntax. hence, the development process rather nice. You get to
develop local on your desktop. No need to worry about all that
server side junk. But, this stuff makes it way up to the sever
side when you publish the application.


Tell me more about the VBA limitations. I tend to have bits of vba code
on many of my forms to do specific things. Are you saying that none of
that runs in a browser-enabled form?

correct no VBA in web forms. However, you still have forms with code and
events.

If you watch my video, you saw a few continuous forms with an edit button.
The event code behind those buttons is now going to be macro code. If you
look at that article/response of mine on stack overflow, you can see that
macros have been significantly improved.

Here is screen shot of the actual code used for on of those buttons on a
form:
http://cpedvw.bay.livefilestore.com/y1pAirBgik0Ioy7UJGFyb4GK4OvbuNDD13zWrUYgs8GJ-eRMEWVxXs79esjWeQHr7pKYj_gzsGAKLVMmjkXCCy_8sHp06jkx0ia/macro1.png

if the above link don't work, then try:
http://cid-b18a57cb5f6af0fa.skydrive.live.com/self.aspx/.Public/AccessHelp/macro1.png

With the above...click on it again to zoom..it should display correctly..


Are there other public sources of detailed information on Access 2010 and
the Access Services that you can point us to?

Best source in the last while is been the access blog here:

http://blogs.msdn.com/access/

Some recent articles:
My room booking application:
http://blogs.msdn.com/access/archive/2009/11/03/demo-of-access-2010-room-bookings-database.aspx

Access Web Databases and The Access Show
http://blogs.msdn.com/access/archive/2009/10/19/access-web-databases-and-the-access-show.aspx

There is even more...the access blog is a great place to find out about new
stuff....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages

  • Re: Wanted: Linux newsreader similar to Forte Agent
    ... I use it because my peers either do not carry binary groups, or their peers don't, meaning they aren't fed the articles, therefore they are not available to feed to me. ... I would guess that Suck could be used with any news server (INN, Diablo, Highwinds), or programs like Leafnode, although I suspect Leafnode has the "sucking" ability built in. ...
    (news.software.readers)
  • Re: Moving to SharePoint - Advice?
    ... I have in many cases taken an Access application and moved the backend to SQL server. ... However far more use of use of store procedures, far more use of views, and far more application optimization must occur when your connection is going to be over standard Internet - That type of connection is a good 100 times slower than what you have with your typical office LAN. ... Keep in mind for access 2010 we now have a stored procedures and table triggers and these new features at the database engine level. ...
    (comp.databases.ms-access)
  • WSS FAQ additions and changes - 4th - 10th December 2006
    ... Non-MS Articles below were valid at the time I added them to the WSS FAQ ... Microsoft Forefront Security for SharePoint ... Microsoft Forefront Security for SharePoint 10.0 MOM 2005 Management Pack ... Planning and architecture for Office SharePoint Server 2007 for Search ...
    (microsoft.public.sharepoint.windowsservices)
  • WSS FAQ additions and corrections - 4th - 10th May 2008
    ... Non-MS Articles below were valid at the time I added them to the WSS FAQ ... NOTE: Amendment to KB articles: Microsoft are not not amending the date of a KB article if the change made is marked as a version point change. ... You are prompted multiple times for authentication when you try to access Central Administration, or you receive an error message when you try to configure the Office SharePoint Server Search service in SharePoint Server 2007 ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: leafnode help please !
    ... news server at the slow speeds but if you wanna see what other people ... of quoted text and the start of what you are typing. ... do not see the articles displayed in the way that Google does it. ... The bits of Unix that you have on your Mac are only those parts needed to ...
    (news.software.readers)