>It says: "The data source for this object must be a variable reference (Error 1742)"
>Is ther another way to make the view as SELECT * FROM table? I don't think that there is, but I'm not master on views ;)
I'm usually use SQL-Pass-Through, so I'm not a master on views as well <g>, but a CREATE VIEW AS SELECT * ... should be possible. But a SELECT * ... doesn't solve the problems you have, as I figured out in the meantime.
Ok, I reproduced your errors using SQL-Server. What worked was the following (SQL-PT):
? SQLEXEC(x, "select [5_test] AS xxx from test")
If I remember it correctly, this syntax should also work with Access. I would recommend that you check a SELECT like this via SQL-PT (just connect like you already did and call this command (replace the variable for the connection handle and field/table name first). If it works, you could try to programmatically create a view with CREATE VIEW and use this syntax. The view builder might be able to do that as well ... but as I said, I'm not a master on views and absolutely no master concerning the view designer <vbg>.
>it returns 5_percent_n...what else can I do with sql-pt? I'm not sure what sql-pt is, but i used sqlconnect() to connect to by access db, whcih i assumed was what you were talking about?
Yeah, that was exactly I was talking about. SQL-PT gives you the possibility to communicate with a remote database without views.
HTH,
Armin