Create view in project file

[H1004]

When I create a new project (.adp) file, I get my table from SQL Server. However, I
can't seem to create view. It said "You do not have exclusive access to
the database at this time. Your design changes will not be saved"
Is there a way for me to create View in Access Project file or it has
to be created in the SQL Server. Any suggestion is greatly appreciated.

 

[SiJP]

I do believe you need to create the view in sql, then link to it thru your project, with an odbc connection.

------------------------
Hit any User to continue