db_owner 1

[paulcarey]

I've got an access project linked to SQL Server.

My problem is that when someone opens the project the views have a (dbo) suffix "vuWhatever (dbo)" which throws an error ie doesnt exist as I'm calling "vuWhatever".

I've added db_owner to the user as I thought this would solve the problem but it doesn't.

Any ideas?

Paul

 

[JohnDTampaBay]

Add dbo. to the object reference: dbo.vuWhatever


--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)