Connection to MS Access with workgroup?


2005-05-19 04:31:56 PM
delphi264
I'm having some trouble connecting to my Microsoft Access database using a
workgroup file. This is the code I am using:
DataSet := TDAODataSet.Create(nil);
with DataSet do begin
DatabaseConnect :=
';SystemDB=C:\WORKGROUP.mdw;Dbq=C:\mydatabase.mdb;uid=user;pwd=password';
ExactRecordCount := True;
DatabaseName := DatabaseFileName;
TableName := 'Job';
Active := True;
Filtered := False;
But it gives me an EOleException, not allowed to read in "Job". And it seems
to makes no difference wether I specify a valid workgroup filename or not.
What am I doing wrong?!
Thanks,
Rune