Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Mar 5, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Avoiding Hard-Coded Path for Data Control Targets

You can easily create simple database projects in design mode by assigning a set of database properties to the Data control. Once you assign a database and record source, you can bind controls to the available fields. However, when you assign a database name, VB inserts an explicit path to the location where it resides on your machine, such as, "D:\Program Files\Microsoft Visual Studio\VB98\Tips Fall 98\NWIND.MDB". If you compile the application and send it to other people, it doesn't run unless their database is in the same location on their machines. You can assign the properties in code and have them take effect at run time. However, this prevents you from linking the bound controls at design time. You can easily work around this by designing the project on your machine, letting VB insert whatever path information it wants, and reassigning the DatabaseName property at run time:
Private Sub Form_Load()
	Data1.DatabaseName = App.Path & "\NWIND.MDB"
End Sub
In this code, the database resides in the same directory as the application itself. If you place it in a different directory, use the appropriate path name.
Ron Schwarz
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date