Linking .udl file to .mdb or .accdb in programming

[mini09]

Hi Jim,

        Thats a great piece of info I will start working on it..

[mini09]

Hi Ranjeet,

             Sure I will work with the .mdb with the conneection string suggested by Jim.... So .udl file will not be a problem.

[mini09]

Hi Mike,

       Thats a nice piece of info.. thanks...

[karthik9]

I know it's a 1 year Old Post, but I Had the same problem , after a lot of digging around I feel this would be the easiest solution, with manipulation over here and there your problem would be solved

[mikeporter]

Yes, this was the solution that a couple people suggested. The only problem with it is that it is not maintainable. You are hard coding way too much information. To begin with, there is the file name. Next, the example hard codes the database you are using -- no actually it's worse than that -- it hard codes the driver that you are using. The result is code that could break depending what version of Windows you are running.

Mike...

[Ranjeet_Singh]

If you have common database then use UDL file. This is easily configurable and you can change as per your resquirement !!!

I will not recomment this becasue for next project when you database changes then you need to program in your application. In other case only your UDL file will be changes 

As per you requirement

[karthik9]

Well I suggested this because, I had to run the application on different systems not connected by any network, so people used to copy the whole folder, and I had the database kept in the location of the application folder, I know there would be missing data if someone doesnot copy the latest database...

[Ranjeet_Singh]

---

@karthik9 wrote:

Well I suggested this because, I had to run the application on different systems not connected by any network, so people used to copy the whole folder, and I had the database kept in the location of the application folder, I know there would be missing data if someone doesnot copy the latest database...

---

If this is the case then for providing the database path use relative path and database in same folder.So chances of missing datbase is eliminted. Otherwise you can use in your database that if writing is failed  then display an error messge stating DB missing....

[Praveen_Kumar_N]

Hi, Can you please suggest a method to create udl for accdb. I need to use accdb in my project. 

I am facing an issue with that, can you please guide me?

Thanks in advance.

Praveen