Deployment using MS-ACCESS

V

vellaima

Well-known member
Joined
Jan 29, 2003
Messages
109
I have created an application which should run in a small network.

How can we make the client
 
Can you please tell me how to add the mdb file (Access database) plus its necessary components while creating PDW. I have added the mdb file into bin folder currenctly. I want both the exe and mdb file together.
 
Code: 
Dim trstring As String = "C:\somedatabasefile.mdb"
Dim sconnstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source =" & trstring & ""  
        Dim oledb As New OleDbConnection(sconnstring)
 
Originally posted by Vidhya
Can you please tell me how to add the mdb file (Access database) plus its necessary components while creating PDW. I have added the mdb file into bin folder currenctly. I want both the exe and mdb file together.
Click to expand...
In the deployment project, right click on the "Application Folder" and select "Add" and "File" then select the .mdb file you want to include in the deployment.
Might suggest you develop against the database in a file on your machine that is identical to what the application folder will be. Then it takes no further work for your app to connect to the database since it is deployed to the same file on the new machine.
 
JFackler, thanks for replying to my query. I have put the Database file in the bin folder.

Code: 
Dim strPath As String = Application.StartupPath()
Dim strConnection As String = 
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & "\Northwind.mdb"
Dim cn As OleDbConnection = New OleDbConnection(strConnection)

Can you please tell me how to put the Output file and the mdb file together while creating them as setup files.

Please do help me out.
 
Back
Top