Hi all.

I'm having a really frustrating problem when my already created crystal reports (v8) establish connections to an SQL 2005 database stored on a mapped network drive. I don't believe the mapped network drive is the problem as it works fine with an Access database.

Current code is as follows:

    Set oApp = New CRAXDRT.Application
    Set oReport = oApp.OpenReport(sReportPath & "\" & getReportFile(ARGUMENT)) 'this just retrieves a report's filename from an already established database connection

    oReport.Database.Tables(i).location = "H:\database.mdf"
    'oReport.Database.Tables(i).Name = LCase(oReport.Database.Tables(i).Name)
    oReport.Database.Tables(i).TestConnectivity

I'm using the SQL database in this way because the software has been designed to do it that way. Previously it connected in exactly the same way but to an Access (*.mdb) file. When I try and do this... it works fine. Are there compatibility issues between crystal reports v8 and SQL2005??? Perhaps there's another way of doing it? I can't find anything about it...

I get "file integrity" errors and "file not found" errors when the "TestConnectivity" method is invoked. I know the tables exist and that the "case" of the table names match.

Hope someone can help... Any ideas?

Cheers,

VBM2

Kind regards,

Craig

__________________
Kind regards,

Craig