Solved

Change extention of a database to my own application file.

Posted on 2009-07-09
3
180 Views
Last Modified: 2012-05-07
Dear experts,

I have made a programm that uses a MS-ACCESS database.
I use the components ADOConnection and ADOQuery for that.
And everythings works fine. But I have a couple of questions:

1. Do you have to install MSACCESS on the computer for my application
   to open an Acces-database?
2. I want to make of the database (.MDB) my own application file (.PKD)
    How can I do that?
3. If I change the database extention .MDB to a .PKD is than still possible
    to open it with MSACESS.

Greetings, Peter Kiers

 
0
Comment
Question by:peterkiers
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
FactorB earned 500 total points
ID: 24812565
1. No, you don't need to. You just need the compatible driver, in your case "Microsoft.Jet.OLEDB.4.0" which is pre-installed on Windows XP and above, if not you can download it from http://support.microsoft.com/?id=239114

2. Simply change the file extension from Database.mdb to Database.pkd


3. It is not possible to open the .pkd file with access straight away, file association will be lost, you will need to redo the association with the help of open dialog or programmatically ...

3.5 :) In order to access your new database you will need to use appropriate connection string, ex.
Form1.ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source='+IncludeTrailingPathDelimiter(ExtractFilePath(Application.ExeName))+'Database.pkd;';

Regards,
B.
0
 
LVL 1

Author Comment

by:peterkiers
ID: 24812920
Thanks for the info, you really helped me alot.
0
 
LVL 6

Expert Comment

by:FactorB
ID: 24813102
This was quick grading :)
You are always welcome.

Regards,
B.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question