TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Yes,
There is something fundamentally you are missing. You must map the fields
in Access to corresponding fields in MS SQL, then import using the DTS
Source
rsntclientlog.mdb to rsclientlog.*
The problem you may run into is verifying the database link to the reports..
/mark
At 02:31 PM 9/18/00 +0200, Liddell, Lee Mr. wrote:
>TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
>[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
>----------------------------------------------------------------------------
>
>All,
>
>I have been trying to link RS Console DB to a back end using MS SQL with
>ODBC. I have imported the database and relinked the MDB tables to the ODBC
>MS SQL Database. I keep getting an error that the database scheme is not
>correct. Could anyone please help me on this?? Is there some thing
>fundamental that I am missing?
>
>~Lee