Quote:
Originally Posted by yojimbo4
i tried doing it, and after i published it again, i saw the deploy file of my mdb
named db1.mdb.deploy, but after trying to install it again, the same problem occurs (cant find file ...../db1.mdb)
is it because i am using unbound connection,
i connect to the database by using this line of codes:
Dim con As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = db1.mdb"
Dim sql As String = "select * from users"
Dim da As New OleDb.OleDbDataAdapter(sql, con)
da.Fill(dt)
thanks for the help, i really appreciate it...
Er - is your database in the same path as your ASP code? If so, that presents a bit of a security risk. You don't want some erroneous error spewing out the name of the database therefore granting some user to be able to just plug that on the end of the web address and downloading it for their own nefarious use.
Okay...in your solution explorer single click your database object (the one with the yellow cylinder next to it) and in the properties window down below you may notice a "Copy to Output Directory" property that is likely marked as "Do not copy" change it to either option "Copy if newer" or "Always copy". That should transfer your database into your output folder when you publish.
