Member Avatar for saintrenz

When transfering file to another location i always need to change the source or directory..

Dim cnn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Renz\Desktop\FINAL\Database\AuditDB.mdb")

Is there a way I can avoid that?

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by Mike Askew
Member Avatar for Mike Askew

Putting the connection string the application config file is good practice and will allow for such changes without needing a re-compile of code.

commented: Yep! +9
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.