Database query open problem
Hi, I want to use relative path for my database file, but i got Unspecified error when the script tries to open the query. Here is the code: var Qry = ADO.CreateADOQuery(); Qry.Connect...
Forum Discussion
var dbpath = ProjectSuite.Path + "..\\..\\..\\1\\1.1\\1.2.1\\vault.accdb";
However, if your database is placed somewhere (e.g. c:\\database\\vault.accdb) and this path never changes (and will not change even on another PC), then I suggest hardcode the path with absolute path, not relative.
However, if your database is placed somewhere (e.g. c:\\database\\vault.accdb) and this path never changes (and will not change even on another PC), then I suggest hardcode the path with absolute path, not relative.