Microsoft SQL Server forum - Create Views via Access ADP

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Create Views via Access ADP

dermot

2005-06-23, 1:23 pm

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

Sponsored Links