Create query in adp

[Guest]

Using access 2003 with SQL Server backend. I am trying to create a query in
access 2003 and saved as view2. After I run the query and click the design
view I get a message - "Invalid object. Extended properties are not permitted
on loginid.view2 or the object does not exist.

Any Ideas? Thanks

 

[Sylvain Lafontaine]

ADP has a lot of problems creating or using Views when you are not dbo for
the database. Instead of Views, you should use stored procedures when
working with ADP and even then, I would recommend to create them with dbo as
the owner and to always specify dbo when you call them. For Forms, I would
set the RecordSourceQualifier property to dbo, too; to make that there is no
problem.

In theory, you could use anything other then dbo as the owner (or schema) of
your objects but with ADP, this is calling for trouble.

The newsgroup for ADP is m.p.a.adp.sqlserver .

 

[Guest]

Thanks. I created stored procedure and it worked. Though I am not sure I got
the right discussion grp for ADP that you gave - m.p.a.adp.sqlserver

 

[aaron.kempf]

SQL Server _2000_ or SQL Server _2005_?

it sounds to me like you're using Access 2003 against SQL 2005.. which
isn't supported.

For the record; those idiots in Redmond even made Access _2000_ not
compatable with SQL _2000_.

Bunch of drunk retards in Redmond should be shown the door for
ineptitude