Alison Balter has written a book titled (see subject).

Does anyone know whether this book is going to come out in print, and if so,
when?

I've found it on-line as an ebook, but not as a hard copy. Unfortunately,
the software control policy at work prevents me from downloading the viewer
required to view the ebook.

--
Dale


email address is invalid
Please reply to newsgroup only.

On Mon, 25 Aug 2008 05:02:01 -0700, Dale Fye <dale.fye@nospam.com>
wrote:

Best ask the publisher Que/InformIT:
http://www.informit.com/about/contact_us/index.aspx

-Tom.
Microsoft Access MVP


>Alison Balter has written a book titled (see subject).
>
>Does anyone know whether this book is going to come out in print, and if so,
>when?
>
>I've found it on-line as an ebook, but not as a hard copy. Unfortunately,
>the software control policy at work prevents me from downloading the viewer
>required to view the ebook.

Did you try Safari books online. They have an option to download it
as a PDF. The URL for the book is: http://techbus.safaribooksonline.com/9780768668513

Lee Allen
http://Iam.LeeAllen.org/blog


On Aug 25, 5:02*am, Dale Fye <dale....@nospam.com> wrote:
> Alison Balter has written a book titled (see subject).
>
> Does anyone know whether this book is going to come out in print, and if so,
> when?
>
> I've found it on-line as an ebook, but not as a hard copy. *Unfortunately,
> the *software control policy at work prevents me from downloading the viewer
> required to view the ebook.
>
> --
> Dale
>
> email address is invalid
> Please reply to newsgroup only.

I finally got some details. It's only 53 pages, so it is not going to be
offered except as an ebook.

I downloaded it, and although I've always been a fan of Alison's, was
disappointed that I paid $10 for 53 pages, most of which is screen shots.
Unfortunately, I've not found even this level of detail in any of the other
Access 2007 or Sharepoint 2007 books.

Dale

"Lee Allen" <afamily@gmail.com> wrote in message
news:c230b09a-bfea-42fd-b013-1771eb360a70@2g2000hsn.googlegroups.com...
Did you try Safari books online. They have an option to download it
as a PDF. The URL for the book is:
http://techbus.safaribooksonline.com/9780768668513

Lee Allen
http://Iam.LeeAllen.org/blog


On Aug 25, 5:02 am, Dale Fye <dale....@nospam.com> wrote:
> Alison Balter has written a book titled (see subject).
>
> Does anyone know whether this book is going to come out in print, and if
> so,
> when?
>
> I've found it on-line as an ebook, but not as a hard copy. Unfortunately,
> the software control policy at work prevents me from downloading the
> viewer
> required to view the ebook.
>
> --
> Dale
>
> email address is invalid
> Please reply to newsgroup only.

Thanks for that.

I list it on my web page of SharePoint 2007 books (specifically at
http://wss.asaris.de/sites/walsh/Lis...m.aspx?ID=1352)
and the only info I had was the size of the file not the number of pages.

I'll add that info ...

Mike Walsh
WSS FAQ http://www.wssfaq.com / wss.collutions.com
I regret that private e-mail questions will not be answered


Dale Fye wrote:
> I finally got some details. It's only 53 pages, so it is not going to be
> offered except as an ebook.
>
> I downloaded it, and although I've always been a fan of Alison's, was
> disappointed that I paid $10 for 53 pages, most of which is screen shots.
> Unfortunately, I've not found even this level of detail in any of the other
> Access 2007 or Sharepoint 2007 books.
>
> Dale
>
> "Lee Allen" <afamily@gmail.com> wrote in message
> news:c230b09a-bfea-42fd-b013-1771eb360a70@2g2000hsn.googlegroups.com...
> Did you try Safari books online. They have an option to download it
> as a PDF. The URL for the book is:
> http://techbus.safaribooksonline.com/9780768668513
>
> Lee Allen
> http://Iam.LeeAllen.org/blog
>
>
> On Aug 25, 5:02 am, Dale Fye <dale....@nospam.com> wrote:
>> Alison Balter has written a book titled (see subject).
>>
>> Does anyone know whether this book is going to come out in print, and if
>> so,
>> when?
>>
>> I've found it on-line as an ebook, but not as a hard copy. Unfortunately,
>> the software control policy at work prevents me from downloading the
>> viewer
>> required to view the ebook.
>>
>> --
>> Dale
>>
>> email address is invalid
>> Please reply to newsgroup only.
>
>

Mike,

I finally found an office within my organization that has MOSS 2007 setup on
a development server, and was able to test some of the information in
Alison's book. I published an application that consists of 39 tables, 45
forms, well over 100 queries, and about a dozen reports. When I was done,
the application was available in a document library on the portal. Clicking
on the app opened the file with all of the links. Although the application
functioned properly (for the most part), I was disappointed with the time it
took for forms to load. Additionally, because of the ID issues discussed
below at least one of the forms that contained a treeview to display a
heirarchy did not display properly. This was remedied by updating the
Parent_ID field.

While the steps she lays out in the document are accurate, I found a number
of problems with the lists (not mentioned in her article) that were imported
when I published the application to MOSS. Errors I received include:

1. Issue:Field values will not be auto-generated.
Reason: SharePoint only supports autonumber for their ID field.
Discussion: During the import of my tables, the wizard took my primary
key fields ( as an example I'll use [Lab_ID]), relabeled it as [_ID] and gave
it an integer data type (all the data in this field was properly retained).
Then it created it's own Autonumber field, and gave it the [Lab_ID] field
name. Unfortunately, it generated a sequential list for this field, and I
have not had a chance to check whether it changed the FK values in the tables
that it was related to or not. The down side of this is that one of my
tables is setup with an ID, Parent_ID heirarchy, and the parent ID values
were no longer valid. So to get my application to work properly, I had to
update all of the parent ID values.

2. Issue: Referential Integrity will not be enforced.
Reason: SharePoint does not support referential integrity.
Discussion: There were actually three issues listed that all relate to
referential integrity, cascading updates and cascading deletes. Obviously if
MOSS does not support referential integrity, then it cannot support either
of the other two items. This also means that you have to write your code to
handle the deletion of records or values when a PK is deleted.

3. Issue:Default value property will not be moved.
Reason: The Default Value property was set to an expression that will
not be specified on the SharePoint column. Specifically, it was neither a
static value nor =Date(), which only applies to Date fields.
Discussion:I had a couple of date/time fields with default value
=Now(). Apparantly, MOSS only recognizes a static value or the Date()
function, not Now().

4. Issue:SharePoint does not support unique indexes on any column other
than ID.
Reason:Unique Index will not be enforced.
Discussion: Obviously requires additional coding to check for
duplicates before inserting a record.


--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Mike Walsh" wrote:

> Thanks for that.
>
> I list it on my web page of SharePoint 2007 books (specifically at
> http://wss.asaris.de/sites/walsh/Lis...m.aspx?ID=1352)
> and the only info I had was the size of the file not the number of pages.
>
> I'll add that info ...
>
> Mike Walsh
> WSS FAQ http://www.wssfaq.com / wss.collutions.com
> I regret that private e-mail questions will not be answered
>
>
> Dale Fye wrote:
> > I finally got some details. It's only 53 pages, so it is not going to be
> > offered except as an ebook.
> >
> > I downloaded it, and although I've always been a fan of Alison's, was
> > disappointed that I paid $10 for 53 pages, most of which is screen shots.
> > Unfortunately, I've not found even this level of detail in any of the other
> > Access 2007 or Sharepoint 2007 books.
> >
> > Dale
> >
> > "Lee Allen" <afamily@gmail.com> wrote in message
> > news:c230b09a-bfea-42fd-b013-1771eb360a70@2g2000hsn.googlegroups.com...
> > Did you try Safari books online. They have an option to download it
> > as a PDF. The URL for the book is:
> > http://techbus.safaribooksonline.com/9780768668513
> >
> > Lee Allen
> > http://Iam.LeeAllen.org/blog
> >
> >
> > On Aug 25, 5:02 am, Dale Fye <dale....@nospam.com> wrote:
> >> Alison Balter has written a book titled (see subject).
> >>
> >> Does anyone know whether this book is going to come out in print, and if
> >> so,
> >> when?
> >>
> >> I've found it on-line as an ebook, but not as a hard copy. Unfortunately,
> >> the software control policy at work prevents me from downloading the
> >> viewer
> >> required to view the ebook.
> >>
> >> --
> >> Dale
> >>
> >> email address is invalid
> >> Please reply to newsgroup only.
> >
> >
>