Why did Microsoft decide to change this directory location anyway?
Printable View
Why did Microsoft decide to change this directory location anyway?
That is one reason seasoned programmers do not use Bound Controls the are too limiting. But you can dynamically set the Data Source and Connections using code that you can use App.Path with. You should NEVER have hard coded paths in your app it makes your app self limiting.
Yes I know, its given me endless problems, many thanks and will look at ways to dynamically change the connections but I think it's a bit outside my expertise at the moment
Take a look in the Database Forum. There should be an ADO tutorial that should help you on your way.
BTW: it's not outside you expertise all it takes is
obj.DataSource = App.Path & "\yourdatabasename"
and
obj.Connection = the connection string that you want to use
(I think it is .Connection)