>I'm not sure if this will help, but what happens if you make a view as >SELECT * FROM table? Do you get an error as well?

It says: "The data source for this object must be a variable reference (Error 1742)"

I get the sql SELECT * FROM when I do an ADD ALL from the remote view->modify->fields. If I manually select them, i of course get the other error when I try to add the 5_percent_n field.

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 ;)

>Another try might be to make a SQL-PT connection and use SQLCOLUMNS() on >the affected table. I wonder, what will be returned as the field name for >the "numeric" field name.

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?

matt