471,073 Members | 1,279 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Create Views via Access ADP

have an MS Access ADP project linked to a SQL Server database.
When a particular user tries to create a view she gets an error saying
'ADO error 'create view' does not allow specifying the database name as
a prefix to the object name'
Username = Jenny.Taggart
I ran a profiler trace to see what the error was.
The SQL that is called
CREATE VIEW Jenny.Taggart.JENNYTEST AS SELECT * From dbo.Accident
Correct syntax would be
CREATE VIEW [Jenny.Taggart].JENNYTEST AS SELECT * From dbo.Accident
Is there anyway to force access to put the square brackets around the
username?
Thanks
Dermot French

Jul 23 '05 #1
0 1941

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Mike N. | last post: by
224 posts views Thread by VB6 User | last post: by
2 posts views Thread by Shirley | last post: by
2 posts views Thread by umair.cheema | last post: by
3 posts views Thread by hsalort | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.