Access 2007 ADP and SQL

We created an Access ADP project in Access 2003 connected to a SQL2000
backend which was working fine.

If we open it in Access 2007 its extremely slow on startup and opening forms
etc.

We did a sql trace and discovered when using ACCESS 2007 that the following
TSQL instruction is being executed

(

SELECT *, sql_variant_property(value, 'basetype') AS type FROM
::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)

)

for what seems to be every object in the database. In ACCESS 2003 none of
these commands are being executed. I've noticed in other forums that other
people have experienced the same issues - but with no solution offered

Anybody get any suggestions?


--
Simon lomax

Someone has suggested that this problem of slowness might be diminished
after starting from a blank ADP project; so maybe you could give it a try
and inform us.

Personnally, I didn't have the occasion of testing this theory by myself yet
because I still don't have installed Access 2007 precisely because I had
this exact same problem with the Beta version.

With this problem, A2007 is totally useless to me as none of my clients will
accept this situation.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
> We created an Access ADP project in Access 2003 connected to a SQL2000
> backend which was working fine.
>
> If we open it in Access 2007 its extremely slow on startup and opening
> forms
> etc.
>
> We did a sql trace and discovered when using ACCESS 2007 that the
> following
> TSQL instruction is being executed
>
> (
>
> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
>
> )
>
> for what seems to be every object in the database. In ACCESS 2003 none of
> these commands are being executed. I've noticed in other forums that other
> people have experienced the same issues - but with no solution offered
>
> Anybody get any suggestions?
>
>
> --
> Simon lomax

Does anyone know if this problem also occurs with Access 2007 and SQL Server
2005?

Thanks,

Adrian

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
> Someone has suggested that this problem of slowness might be diminished
> after starting from a blank ADP project; so maybe you could give it a try
> and inform us.
>
> Personnally, I didn't have the occasion of testing this theory by myself
> yet because I still don't have installed Access 2007 precisely because I
> had this exact same problem with the Beta version.
>
> With this problem, A2007 is totally useless to me as none of my clients
> will accept this situation.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
>> We created an Access ADP project in Access 2003 connected to a SQL2000
>> backend which was working fine.
>>
>> If we open it in Access 2007 its extremely slow on startup and opening
>> forms
>> etc.
>>
>> We did a sql trace and discovered when using ACCESS 2007 that the
>> following
>> TSQL instruction is being executed
>>
>> (
>>
>> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
>> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
>>
>> )
>>
>> for what seems to be every object in the database. In ACCESS 2003 none of
>> these commands are being executed. I've noticed in other forums that
>> other
>> people have experienced the same issues - but with no solution offered
>>
>> Anybody get any suggestions?
>>
>>
>> --
>> Simon lomax
>
>

I've only noticed it being really really slow when you've got hundreds
of tables or something

I just swear; if they made a hash index and stored the csname for
objects; I thnk that would take care of it

I just swear; when it has to scan sysobjects and sysobjects has 2,000
objects in it is when i see this slowness

-Aaron



Adrian wrote:
> Does anyone know if this problem also occurs with Access 2007 and SQL Server
> 2005?
>
> Thanks,
>
> Adrian
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
> > Someone has suggested that this problem of slowness might be diminished
> > after starting from a blank ADP project; so maybe you could give it a try
> > and inform us.
> >
> > Personnally, I didn't have the occasion of testing this theory by myself
> > yet because I still don't have installed Access 2007 precisely because I
> > had this exact same problem with the Beta version.
> >
> > With this problem, A2007 is totally useless to me as none of my clients
> > will accept this situation.
> >
> > --
> > Sylvain Lafontaine, ing.
> > MVP - Technologies Virtual-PC
> > E-mail: sylvain aei ca (fill the blanks, no spam please)
> >
> >
> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> > news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
> >> We created an Access ADP project in Access 2003 connected to a SQL2000
> >> backend which was working fine.
> >>
> >> If we open it in Access 2007 its extremely slow on startup and opening
> >> forms
> >> etc.
> >>
> >> We did a sql trace and discovered when using ACCESS 2007 that the
> >> following
> >> TSQL instruction is being executed
> >>
> >> (
> >>
> >> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
> >> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
> >>
> >> )
> >>
> >> for what seems to be every object in the database. In ACCESS 2003 none of
> >> these commands are being executed. I've noticed in other forums that
> >> other
> >> people have experienced the same issues - but with no solution offered
> >>
> >> Anybody get any suggestions?
> >>
> >>
> >> --
> >> Simon lomax
> >
> >

Yes its the same with SQL 2005. I backed up my database up and restored it to
SQL2005 and repointed the ADP to the SQL2005 version, still the same.

--
Simon lomax


"Adrian" wrote:

> Does anyone know if this problem also occurs with Access 2007 and SQL Server
> 2005?
>
> Thanks,
>
> Adrian
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
> > Someone has suggested that this problem of slowness might be diminished
> > after starting from a blank ADP project; so maybe you could give it a try
> > and inform us.
> >
> > Personnally, I didn't have the occasion of testing this theory by myself
> > yet because I still don't have installed Access 2007 precisely because I
> > had this exact same problem with the Beta version.
> >
> > With this problem, A2007 is totally useless to me as none of my clients
> > will accept this situation.
> >
> > --
> > Sylvain Lafontaine, ing.
> > MVP - Technologies Virtual-PC
> > E-mail: sylvain aei ca (fill the blanks, no spam please)
> >
> >
> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> > news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
> >> We created an Access ADP project in Access 2003 connected to a SQL2000
> >> backend which was working fine.
> >>
> >> If we open it in Access 2007 its extremely slow on startup and opening
> >> forms
> >> etc.
> >>
> >> We did a sql trace and discovered when using ACCESS 2007 that the
> >> following
> >> TSQL instruction is being executed
> >>
> >> (
> >>
> >> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
> >> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
> >>
> >> )
> >>
> >> for what seems to be every object in the database. In ACCESS 2003 none of
> >> these commands are being executed. I've noticed in other forums that
> >> other
> >> people have experienced the same issues - but with no solution offered
> >>
> >> Anybody get any suggestions?
> >>
> >>
> >> --
> >> Simon lomax
> >
> >
>
>
>

I can't even get Office 2007 to _OPEN_

it keeps on throwing some error about how I can't run it on a terminal
server. Yes, I have tried it locally-- at home instead of across a
terminal.

I just find it humorous.. I'm not using a terminal session why does
Office give a **** if I have terminal enabled?

-Aaron

And do you know what happens with the new format for ADP, the one with the
extension .accdp?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
news:6C89FC4C-B0CE-42F4-9C96-47D7AD72132E@microsoft.com...
> Yes its the same with SQL 2005. I backed up my database up and restored it
> to
> SQL2005 and repointed the ADP to the SQL2005 version, still the same.
>
> --
> Simon lomax
>
>
> "Adrian" wrote:
>
>> Does anyone know if this problem also occurs with Access 2007 and SQL
>> Server
>> 2005?
>>
>> Thanks,
>>
>> Adrian
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
>> > Someone has suggested that this problem of slowness might be diminished
>> > after starting from a blank ADP project; so maybe you could give it a
>> > try
>> > and inform us.
>> >
>> > Personnally, I didn't have the occasion of testing this theory by
>> > myself
>> > yet because I still don't have installed Access 2007 precisely because
>> > I
>> > had this exact same problem with the Beta version.
>> >
>> > With this problem, A2007 is totally useless to me as none of my clients
>> > will accept this situation.
>> >
>> > --
>> > Sylvain Lafontaine, ing.
>> > MVP - Technologies Virtual-PC
>> > E-mail: sylvain aei ca (fill the blanks, no spam please)
>> >
>> >
>> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
>> > news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
>> >> We created an Access ADP project in Access 2003 connected to a SQL2000
>> >> backend which was working fine.
>> >>
>> >> If we open it in Access 2007 its extremely slow on startup and opening
>> >> forms
>> >> etc.
>> >>
>> >> We did a sql trace and discovered when using ACCESS 2007 that the
>> >> following
>> >> TSQL instruction is being executed
>> >>
>> >> (
>> >>
>> >> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
>> >> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
>> >>
>> >> )
>> >>
>> >> for what seems to be every object in the database. In ACCESS 2003 none
>> >> of
>> >> these commands are being executed. I've noticed in other forums that
>> >> other
>> >> people have experienced the same issues - but with no solution offered
>> >>
>> >> Anybody get any suggestions?
>> >>
>> >>
>> >> --
>> >> Simon lomax
>> >
>> >
>>
>>
>>

*.accdp? Searched my Access2007, did not find such a file type in
Access2007's open/new file dialog box. No subject/index found in
Access2007'e help either.

Besides native *.accdb format, Access2007 also support

*.accdt - template
*.accdc - singed package
*.accda - add-in


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIaujJdRHHA.2212@TK2MSFTNGP02.phx.gbl...
> And do you know what happens with the new format for ADP, the one with the
> extension .accdp?
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> news:6C89FC4C-B0CE-42F4-9C96-47D7AD72132E@microsoft.com...
>> Yes its the same with SQL 2005. I backed up my database up and restored
>> it to
>> SQL2005 and repointed the ADP to the SQL2005 version, still the same.
>>
>> --
>> Simon lomax
>>
>>
>> "Adrian" wrote:
>>
>>> Does anyone know if this problem also occurs with Access 2007 and SQL
>>> Server
>>> 2005?
>>>
>>> Thanks,
>>>
>>> Adrian
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
>>> > Someone has suggested that this problem of slowness might be
>>> > diminished
>>> > after starting from a blank ADP project; so maybe you could give it a
>>> > try
>>> > and inform us.
>>> >
>>> > Personnally, I didn't have the occasion of testing this theory by
>>> > myself
>>> > yet because I still don't have installed Access 2007 precisely because
>>> > I
>>> > had this exact same problem with the Beta version.
>>> >
>>> > With this problem, A2007 is totally useless to me as none of my
>>> > clients
>>> > will accept this situation.
>>> >
>>> > --
>>> > Sylvain Lafontaine, ing.
>>> > MVP - Technologies Virtual-PC
>>> > E-mail: sylvain aei ca (fill the blanks, no spam please)
>>> >
>>> >
>>> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
>>> > news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
>>> >> We created an Access ADP project in Access 2003 connected to a
>>> >> SQL2000
>>> >> backend which was working fine.
>>> >>
>>> >> If we open it in Access 2007 its extremely slow on startup and
>>> >> opening
>>> >> forms
>>> >> etc.
>>> >>
>>> >> We did a sql trace and discovered when using ACCESS 2007 that the
>>> >> following
>>> >> TSQL instruction is being executed
>>> >>
>>> >> (
>>> >>
>>> >> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
>>> >> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
>>> >>
>>> >> )
>>> >>
>>> >> for what seems to be every object in the database. In ACCESS 2003
>>> >> none of
>>> >> these commands are being executed. I've noticed in other forums that
>>> >> other
>>> >> people have experienced the same issues - but with no solution
>>> >> offered
>>> >>
>>> >> Anybody get any suggestions?
>>> >>
>>> >>
>>> >> --
>>> >> Simon lomax
>>> >
>>> >
>>>
>>>
>>>
>
>

I can't get office to open; it complains about being run on a terminal
server

I mean; SERIOUSLY here guys

is UNNECESSARY COMPLEXITY either simple or necessary?

-Aaron


Norman Yuan wrote:
> *.accdp? Searched my Access2007, did not find such a file type in
> Access2007's open/new file dialog box. No subject/index found in
> Access2007'e help either.
>
> Besides native *.accdb format, Access2007 also support
>
> *.accdt - template
> *.accdc - singed package
> *.accda - add-in
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:OIaujJdRHHA.2212@TK2MSFTNGP02.phx.gbl...
> > And do you know what happens with the new format for ADP, the one with the
> > extension .accdp?
> >
> > --
> > Sylvain Lafontaine, ing.
> > MVP - Technologies Virtual-PC
> > E-mail: sylvain aei ca (fill the blanks, no spam please)
> >
> >
> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> > news:6C89FC4C-B0CE-42F4-9C96-47D7AD72132E@microsoft.com...
> >> Yes its the same with SQL 2005. I backed up my database up and restored
> >> it to
> >> SQL2005 and repointed the ADP to the SQL2005 version, still the same.
> >>
> >> --
> >> Simon lomax
> >>
> >>
> >> "Adrian" wrote:
> >>
> >>> Does anyone know if this problem also occurs with Access 2007 and SQL
> >>> Server
> >>> 2005?
> >>>
> >>> Thanks,
> >>>
> >>> Adrian
> >>>
> >>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> >>> wrote in message news:uPAen2URHHA.3412@TK2MSFTNGP02.phx.gbl...
> >>> > Someone has suggested that this problem of slowness might be
> >>> > diminished
> >>> > after starting from a blank ADP project; so maybe you could give it a
> >>> > try
> >>> > and inform us.
> >>> >
> >>> > Personnally, I didn't have the occasion of testing this theory by
> >>> > myself
> >>> > yet because I still don't have installed Access 2007 precisely because
> >>> > I
> >>> > had this exact same problem with the Beta version.
> >>> >
> >>> > With this problem, A2007 is totally useless to me as none of my
> >>> > clients
> >>> > will accept this situation.
> >>> >
> >>> > --
> >>> > Sylvain Lafontaine, ing.
> >>> > MVP - Technologies Virtual-PC
> >>> > E-mail: sylvain aei ca (fill the blanks, no spam please)
> >>> >
> >>> >
> >>> > "Simon Lomax" <SimonLomax@discussions.microsoft.com> wrote in message
> >>> > news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@microsoft.com...
> >>> >> We created an Access ADP project in Access 2003 connected to a
> >>> >> SQL2000
> >>> >> backend which was working fine.
> >>> >>
> >>> >> If we open it in Access 2007 its extremely slow on startup and
> >>> >> opening
> >>> >> forms
> >>> >> etc.
> >>> >>
> >>> >> We did a sql trace and discovered when using ACCESS 2007 that the
> >>> >> following
> >>> >> TSQL instruction is being executed
> >>> >>
> >>> >> (
> >>> >>
> >>> >> SELECT *, sql_variant_property(value, 'basetype') AS type FROM
> >>> >> ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'function',N'qryMarketingTransactions',NULL,NULL)
> >>> >>
> >>> >> )
> >>> >>
> >>> >> for what seems to be every object in the database. In ACCESS 2003
> >>> >> none of
> >>> >> these commands are being executed. I've noticed in other forums that
> >>> >> other
> >>> >> people have experienced the same issues - but with no solution
> >>> >> offered
> >>> >>
> >>> >> Anybody get any suggestions?
> >>> >>
> >>> >>
> >>> >> --
> >>> >> Simon lomax
> >>> >
> >>> >
> >>>
> >>>
> >>>
> >
> >

It is still slow. Even after SP1 installed.

When you open siple form with Server Filter by Form property set to YES, form doesn't work.

Crashes, hangs, crashes, hangs...

I have 28 hangs and crashes with MSO Access 2007 ADP. Same app works fine in MS Access 2003 SP3.

I am reporting to Microsoft about problems regulary, but, they don't have solution for MSO Access 2007 ADP still...

MSO Access 2007 ADP looks to me unusable. Even after SP1 installed.

Is there any solution for MSO Access 2007 ADP connected to MS SQL Server 2005 Express?