Publish a windows form project

See more:

C#

database

Hello,

I want to publish a windows form project to an application (.exe) . I used project->properties->publish. there is a database which should published also.

my code is:

OleDbConnection cn = new OleDbConnection("Provider='Microsoft.Jet.OLEDB.4.0';Data Source=|DataDirectory|\\data\\jamiyi.mdb;");
            OleDbDataAdapter adp = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            DataSet tb = new DataSet();
            try
            {
                cn.Open();
                MessageBox.Show("Connection Open ! ");
                cn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can not open connection ! ");
            }

the problem is when I run the project the connection to the database opens but when I publish the project the connection fails(I run the published project another PC which has all program requirements).


so what I have to do to fix it?

Thanks in advance.