I have an issue wherein the number of fields(columns) in a table exceed 255 in MS Access.ie(370)
So i decided to split the tables into 2 diferent table each containing 185 fields.
Then before running the QTP script, I join the 2 tables and store them as a view. View is a virtual table
and I am assuming it can hold any number of fields.
I tried the following syntax
create view as select * from table1 INNER JOIN table2 ON table1.ROW_NUMBER=table2.ROW_NUMBER
Where table1 and table2 are tables and row_number is a common field.I am not familiar with MS ACCESS.
Am I on the right track and is the syntax right?
I am getting the following error
"Syntax error in CREATE TABLE"
can u pl help me.Its urgent...
