Another way of connecting MS Access using StartupPath & GetCurrentDirectory

Is there a best alternative like IO.Directory.GetCurrentDirectory or Application.StartupPath when merging it to the connection string? because i FOUND this two a bit buggy. I dont know what is happening but it makes the database file read only when I use these two. The data saved is only saved when the application is running and if you will close the application the saved data will automatically be deleted and I dont know I it is happening.

Does the logged in user have read/write ability to those folders?

Are you using and insert or update query or are you using Recordset.Update after manually adding data?

Showing the relevant section of your code would help a lot. :)

everything works fine if I manually put the path of the database like "C:\Application\Bin\Debug\Database\Database.mdb" but when I try to use Application.StartupPath & "\Database\Database.mdb" thats the problem and also for IO.Directory.GetCurrentDirectory & "\bin\debug\Database\Database.mdb" as connection string.

I import Microsoft.ActiveX version 2.6 as Reference for ADOdb for me to use.