Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Delphi and Ms-Access user's

Hi Experts
How I  can define MS-Access user and password From Delphi
thanks
Best regards
0
fhbexpir
Asked:
fhbexpir
  • 3
  • 2
1 Solution
 
Darth_helgeCommented:
If you want to use msAccess database in delphi you can use a TADOConnection. then fill in its connectionstring.

like this:
procedure TForm1.Button1Click(Sender: TObject);
var
ADOConnection1: TADOConnection;
Accesspwd: string;
begin
ADOConnection1 := TADOConnection.Create(nil);

ADOConnection1.ConnectionString  := 'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source='
      +  'IFDB\Info Form.mdb;' + 'Persist Security Info=False;Jet OLEDB:'
      +  '\\Itts\Felles\MARTIN\Info Form.mdb;' + 'Persist Security Info=False;Jet OLEDB:'
      + 'Database Password=' + AccessPwd + ';Jet OLEDB:New Database Password=' + AccesPwd;

ADOConnection.Active := true;

end;

now you're connected to the msaccess database with a password.
0
 
Darth_helgeCommented:
ADOConnection1.ConnectionString  := 'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source='
      +  thePathToTheDataBase + 'Persist Security Info=False;Jet OLEDB:'
      + 'Database Password=' + AccessPwd + ';Jet OLEDB:New Database Password=' + AccesPwd;

sorry, was a little fast there..

0
 
fhbexpirAuthor Commented:
Thanks for you

But I want define user and password for Ms-Access For many users runtime
(i use of Adoconnection and .....)
Like as SqlServer(Sp_Addlogin and sp_password and ....)

Thaanks
0
 
fhbexpirAuthor Commented:
Thanks for you

But I want define user and password for Ms-Access For many users runtime
(i use of Adoconnection and .....)
Like as SqlServer(Sp_Addlogin and sp_password and ....)

Thanks
0
 
fhbexpirAuthor Commented:
I want to use msAccess database in delphi.How I can define  users and password from delphi(dll,Activex,ocx,...)
thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now