ADO Error: Property cannot be added when saving functions

[SpiritBelgium]

Hello,

I removed my MSQL Server 2000 and installed a MSQL 2005 Developer Edition 32 bit on my computer.

Since I use an Access 2003 adp application I had to upgrade to Access 2007 to be able to modifie my designs (access 2003 can work only read only with MSQL 2005).

So far everything ok, I can work perfectly with my adp project in office 2007, alter froms, ....

But now I ran into a problem and can't find a solution:
When I want to modify a query (based on a function in this case) and save it I get some ADO errors like these:
- ADO error: Property cannot be added. Property 'AllowZeroLength' already exists for 'dbo.QRY_Test.Datum'
- ADO error: Property cannot be added. Property 'MS_AggregateType' already exists for ....

I allready tried to create a brand new adp with access 2007 to see if it had anything to do with an previous access file version... but again, the same problem, even when I create a new DB in MSQL 2005 using Access 2007.

So I'm a bit stuck here.

Would appreciate some help here ;-)

Bonusquestion: On one pc I don't get the popups for the variables when running the functions in accesss

Thanks on advance,

Geert
Belgium

 

[sparkbyte]

I had a simular problem and ended having to go into SSMS and remove the function from the SQL Database.



Thanks

John Fuhrman
faq329-6766
thread329-1334328
thread329-1424438