HI,

I have develope a program with VB 6.0 and crystal report 8.5 with access database. Actually, I can run the program smoothly in my PC. However, when I installed the program in a genenal PC. Whenever I activate the crystal report viewer, a error message box appears "Physical database not found".

I tried to install the sample program provided by the Seagate Software. The same error message appears. Please give me some advice. Thanks a lot.

Most probably you are missing database dll. So, depending on how do you connect your database, you should distribute dll that is need for certaing type of connection. For instance, when connecting with OleDB using Jet 4.0 engine, you should distribute p2soledb.dll, if I am not mistaken. Anyway, you have several p2*.dll's, so try copying then when one by one and see which one your connection needs, if you are not sure.

____________________________
If you find the answer helpful, please mark this topic as solved.

Thanks for your reply. I will try your suggestion.
Happy Chinese Lunar New Year.

I am using ADO for my project with Access database. I use Jet 4.0 engine and my database file is protected by a database password. I use crystal report 8.5 for the report. I add some references to the VB project so i can use the CRViewer.dll to display the report in VB form where the report is loaded from external .RPT file coz i think it is more convenient using an external file. (Creating report as .DSR will cause creating .TMP file when the program loaded) I can load the report in VB form but it is not refreshed(which means it is not connected to the database). And when I removed the code, I will get a pop up message asking me to enter Microsoft Access Password. I am trying to link the database using the following code:

Dim strSQL As String
Dim con As ADODB.Connection
Dim cmd As ADODB.Command

Set con = New ADODB.Connection
Set cmd = New ADODB.Command

con.Open "Provider=...     'Connection string which include database password
cmd.ActiveConnection = con
strSQL="SELECT * FROM Branch"
cmd.CommandText = strSQL
cmd.CommandType = adCmdText

Report.Database.AddADOCommand con, cmd

The cmd causes an error that cmd is set to Nothing

I want the report refreshes using the password provided in my connection string. Please help...