Create view

G

Guest

MS JET database engine does not support the use of CREATE VIEW statement. Is
there any other way i can do it to create a view? Thanks I appreciate any
help.
 
J

John Vinson

MS JET database engine does not support the use of CREATE VIEW statement. Is
there any other way i can do it to create a view? Thanks I appreciate any
help.
Click to expand...

Create a Query. In JET/Access, you can use Queries in very much the
same manner that you would use Views in SQL; they're even updateable
in most cases.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab query with parameter query 5
CREATE VIEW? 1
Create view statement 2
Can't create a report from my query in Access 1
Upsizing to sql 2003 1
USING PARAMETERS IN A CROSSTAB QUERY 4
I am confused 1
IN clause error 1

Top