Greetings–

I am having problems exporting data into an Access Database from OI.  At the beginning of this project I had some data from AREV 3.1 and had to get it into Access somehow.  We purchased OI and I took the data from AREV 3.1 and brought it into OI (I think successfully)  I can run reports so it does have data in the tables.  What im having trouble with now is the exporting of the new OI data into an Access Database where there is currently no data.  I went through the creation of a Warehouse setup and when I try to Manage it to export the data into Access I get errors such as 'Error Processing 01' and so on and so forth.  Im wondering if somehow I am doing something incorrectly or im not moving the data correctly.  Ive tried moving different tables and I get the same errors everytime unless I choose the selection box for create tables for me then I get an error that basically says 'Cannot create SQL tables'.  Any help would be appreciated.

Thanks,

-Karl (you can email directly if you wish [email protected])

Karl,

1. Have you set up a connection to your Access database?

(Client/Server Workspace, File, New, Connection)

2. Have you verified that the connection works?

(Client/Server Workspace, Tools, Query Window)

3. Have you taken the table creation scripts from the warehouse procedure and pasted them into the Query Window to make sure the syntax works?

(System Editor, File, Open Stored Procedure, "WP_"…)

Each database and driver has a slightly different syntax for creating tables. That appears to be your blocking point.

Cameron Purdy

Revelation Software

View this thread on the forum...