Re: Access 2007 ADP and SQL

Tech-Archive recommends: Speed Up your PC by fixing your registry

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C89FC4C-B0CE-42F4-9C96-47D7AD72132E@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE8EEEE2-8A0E-49AE-A66A-A0DEBE60B7F1@xxxxxxxxxxxxxxxx
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







.

Relevant Pages