Creating views in access???

[Guest_imported]

I'm having troubles creating views in access...it keeps giving me an error message "Syntax error in create table statement" Is there any way to create a view in access?
Thanks in advance

 

[JimHorton]

Tig,
A view is simply a sql statement over an existing table(s). Just create a query and use that as the view.
--Jim

 

[Guest_imported]

I wish what you say would work....
lets use
CREATE VIEW view_1 AS
SELECT *
FROM tablename;
as an example of a typical view.......syntax is corrent but when I try to run it, I get the create table syntax error.
Any ideas why I can't create a view?

 

[Maquis]

Tiggress, it sounds like you are used to working in SQL server or some other database system. To my knowledge, Access doesn't have "views" as you're used to using them.

All you need to do is create a select query in Access in order to get a different "view" of the data. Maq B-)
<insert witty signature here>

 

[binky]

Why not try using the make table query? It is quite easy to use. When I used it to create a table with all fields from the Clients table I was given the following code.

SELECT Clients.* INTO [New Test] FROM Clients;

I hope this helps

Ken :

 

[Guest_imported]

ROFL......I never thought that it wouldn't be possible to use views with access......I guess that will teach me to keep my db's separate! Thanks alot guys

 

[BNPMike]

Tiggress

You realise from this you can use views? (And views on views etc). It's just that Access doesn't see them in that way and so doesn't call them views. Otherwise it's exactly the same and you should not be put off using them. mike.stephens@bnpparibas.com