Accessing a .mdb database on a CD
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
Yes, the Jet database engine, which Access DBs are based on, create a *.ldb database lock file. But this has nothing to do with whether or not you use C#.
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi -
Yes, the Jet database engine, which Access DBs are based on, create a *.ldb database lock file. But this has nothing to do with whether or not you use C#.
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma GandhiI'm not experienced in Access so don't quote me - but... Is it possible to open the database as a shared connection - would this remove the need to write the lock file. Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript) tatham@e-oddie.com +61 414 275 989
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
Hi, If you choose "Read Only" AND "Open Exclusive" together, Access won't create the *.ldb file if it isn't already there. Another option is to get any "ldb" file, and copy it into the CD as well... not very clean solution, but it seems that it works fine :-) Good luck Braulio
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
Hi, Have you tried to set "Exclusive Access" and login to the database with an user that only has "Read Data" access ? Tools >> Security >> User and Group Accounts Tools >> Security >> User and Group Permissions HTH Braulio
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"
-
Regards, We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works. But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what? Thanks for any note and help, -nSun --- "Art happens when you least expect it"