| Author |
Message |
|
Les Guys
#1 / 9
|
 MS Access with Delphi Are there any papers or books out there that deal specifically with using
delphi with MS Access? I've been trying to connect to some ACCESS
databases with no success. It wants passwords (which there aren't any) or
it says it's the wrong format.
Any quick tips out there????
Thanks in advance for you help.
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
|
Ray Porte
#2 / 9
|
MS Access with Delphi
Quote: > Are there any papers or books out there that deal specifically with using > Delphi with MS Access? I've been trying to connect to some ACCESS > databases with no success. It wants passwords (which there aren't any) or > it says it's the wrong format. > Any quick tips out there????
> Thanks in advance for you help.
Loginprompt property to false. That will eliminate the userid/password
dialog. It'll take more information to tell what's going on with your other
error. Which version of Delphi and the BDE are you using with which version
of Access?
--
================================================
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
Home Page: http://www.unc.edu/~dragon/
"Meddle not in the affairs of dragons,
for thou art crunchy and taste good with ketchup."
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Les Guys
#3 / 9
|
MS Access with Delphi I've tried all that but when I try to set the Connected property to true I
get "unrecognized format" error.
I'm currently running Access 2000 and I've tried to convert it back down to
an earlier release to no avail.
If someone could post the few parameters listing for a typical Access DB and
a sequence of events I sure would appreciate it.
Delphi 5 Enterprise
Access 2000
Win 98 2nd
Regards, Les Guyse
Quote:
> > Are there any papers or books out there that deal specifically with
using
> > Delphi with MS Access? I've been trying to connect to some ACCESS
> > databases with no success. It wants passwords (which there aren't any)
or
> > it says it's the wrong format.
> > Any quick tips out there????
> > Thanks in advance for you help.
> Are you using the BDE? If so, use a TDatabase component and set the
> Loginprompt property to false. That will eliminate the userid/password
> dialog. It'll take more information to tell what's going on with your
other
> error. Which version of Delphi and the BDE are you using with which
version
> of Access?
> --
> ================================================
> Ray Porter
> Applications Analyst Programmer
> Administrative Information Services, UNC-CH
> Phone: 966-5878
> Home Page: http://www.unc.edu/~dragon/
> "Meddle not in the affairs of dragons,
> for thou art crunchy and taste good with ketchup."
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Thomas Hammere
#4 / 9
|
MS Access with Delphi Hello !
I have exactly the same problems as you. I am using Delphi 3 and MS Acess
2000 on Windows NT 4.0. I have no success to connect with any access
Database. If you have some information about this problem, please tell me
also.
Regards
Thomas Hammerer
Quote: > I've tried all that but when I try to set the Connected property to true I > get "unrecognized format" error. > I'm currently running Access 2000 and I've tried to convert it back down to > an earlier release to no avail. > If someone could post the few parameters listing for a typical Access DB and > a sequence of events I sure would appreciate it. > Delphi 5 Enterprise
> Access 2000
> Win 98 2nd
> Regards, Les Guyse
> > > Are there any papers or books out there that deal specifically with
> using
> > > Delphi with MS Access? I've been trying to connect to some ACCESS
> > > databases with no success. It wants passwords (which there aren't
any)
> or
> > > it says it's the wrong format.
> > > Any quick tips out there????
> > > Thanks in advance for you help.
> > Are you using the BDE? If so, use a TDatabase component and set the
> > Loginprompt property to false. That will eliminate the userid/password
> > dialog. It'll take more information to tell what's going on with your
> other
> > error. Which version of Delphi and the BDE are you using with which
> version
> > of Access?
> > --
> > ================================================
> > Ray Porter
> > Applications Analyst Programmer
> > Administrative Information Services, UNC-CH
> > Phone: 966-5878
> > Home Page: http://www.unc.edu/~dragon/
> > "Meddle not in the affairs of dragons,
> > for thou art crunchy and taste good with ketchup."
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Eddie O'Brie
#5 / 9
|
MS Access with Delphi Is this an Access 2000 problem?
I can see Access 97 just fine with Delphi Pro 4 and BDE.
Eddie
Quote: > Hello ! > I have exactly the same problems as you. I am using Delphi 3 and MS Acess > 2000 on Windows NT 4.0. I have no success to connect with any access > Database. If you have some information about this problem, please tell me > also. > Regards
> Thomas Hammerer
> > I've tried all that but when I try to set the Connected property to true
I
> > get "unrecognized format" error.
> > I'm currently running Access 2000 and I've tried to convert it back
down
> to
> > an earlier release to no avail.
> > If someone could post the few parameters listing for a typical Access DB
> and
> > a sequence of events I sure would appreciate it.
> > Delphi 5 Enterprise
> > Access 2000
> > Win 98 2nd
> > Regards, Les Guyse
> > > > Are there any papers or books out there that deal specifically with
> > using
> > > > Delphi with MS Access? I've been trying to connect to some ACCESS
> > > > databases with no success. It wants passwords (which there aren't
> any)
> > or
> > > > it says it's the wrong format.
> > > > Any quick tips out there????
> > > > Thanks in advance for you help.
> > > Are you using the BDE? If so, use a TDatabase component and set the
> > > Loginprompt property to false. That will eliminate the
userid/password
> > > dialog. It'll take more information to tell what's going on with your
> > other
> > > error. Which version of Delphi and the BDE are you using with which
> > version
> > > of Access?
> > > --
> > > ================================================
> > > Ray Porter
> > > Applications Analyst Programmer
> > > Administrative Information Services, UNC-CH
> > > Phone: 966-5878
> > > Home Page: http://www.unc.edu/~dragon/
> > > "Meddle not in the affairs of dragons,
> > > for thou art crunchy and taste good with ketchup."
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Eddie O'Brie
#6 / 9
|
MS Access with Delphi Is this an Access 2000 problem? or lack of driver?
I can see Access 97 just fine with Delphi Pro 4 and BDE 5.1 (or via ADO).
I can expand on this if needed.
Eddie
Quote: > Hello ! > I have exactly the same problems as you. I am using Delphi 3 and MS Acess > 2000 on Windows NT 4.0. I have no success to connect with any access > Database. If you have some information about this problem, please tell me > also. > Regards
> Thomas Hammerer
> > I've tried all that but when I try to set the Connected property to true
I
> > get "unrecognized format" error.
> > I'm currently running Access 2000 and I've tried to convert it back
down
> to
> > an earlier release to no avail.
> > If someone could post the few parameters listing for a typical Access DB
> and
> > a sequence of events I sure would appreciate it.
> > Delphi 5 Enterprise
> > Access 2000
> > Win 98 2nd
> > Regards, Les Guyse
> > > > Are there any papers or books out there that deal specifically with
> > using
> > > > Delphi with MS Access? I've been trying to connect to some ACCESS
> > > > databases with no success. It wants passwords (which there aren't
> any)
> > or
> > > > it says it's the wrong format.
> > > > Any quick tips out there????
> > > > Thanks in advance for you help.
> > > Are you using the BDE? If so, use a TDatabase component and set the
> > > Loginprompt property to false. That will eliminate the
userid/password
> > > dialog. It'll take more information to tell what's going on with your
> > other
> > > error. Which version of Delphi and the BDE are you using with which
> > version
> > > of Access?
> > > --
> > > ================================================
> > > Ray Porter
> > > Applications Analyst Programmer
> > > Administrative Information Services, UNC-CH
> > > Phone: 966-5878
> > > Home Page: http://www.unc.edu/~dragon/
> > > "Meddle not in the affairs of dragons,
> > > for thou art crunchy and taste good with ketchup."
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Andrew Bayli
#7 / 9
|
MS Access with Delphi I guess that it's an Access 2000 problem. Have you tried using ADO to
connect / work with the database instead? This way you don't have to use the
BDE at all.
Cheers,
Andrew
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Home
#8 / 9
|
MS Access with Delphi Use ADO. It will connect reliably to Access 2.0 thru 2000, and it is very
fast. I do this all the time. If you don't have D5 Enterprise, or the ADO
Express pack for the Professional version, there is a very good third party
ADO control set from Timur Islamov (with and without source).
Quote: > Are there any papers or books out there that deal specifically with using > Delphi with MS Access? I've been trying to connect to some ACCESS > databases with no success. It wants passwords (which there aren't any) or > it says it's the wrong format. > Any quick tips out there????
> Thanks in advance for you help.
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
|
|
Zoralli
#9 / 9
|
MS Access with Delphi <snip>
Quote: > Express pack for the Professional version, there is a very good third
party
> ADO control set from Timur Islamov (with and without source).
<snip>
I'd have to agree with that, but pay the extra for the source. It's worth
having
if only to help debug what's wrong with your (mis-)usage of it sometimes....
(or is that just me... :-))
|
| Wed, 18 Jun 1902 08:00:00 GMT |
|
| |
