Using the Sql Explorer under Delphi5, when I click on the + to the left of
"MsAccess Database", Delphi displays a "Database Logon" dialog box.  What do
I need to supply for the User Name and Password to to work with the
Shared\Data\DbDemos.MDB Access database?

Wm David Parker <d...@DelphiExpert.com> wrote in message
news:7tjn8p$2mi17@forums.borland.com...

I don't have D5, but assuming that the database is using the standard
C:\Windows\System\System.mdw workgroup file, the user id is Admin

No password is required

--
Pierre
http://delphidao.finalfiler.com
http://delphiotc.finalfiler.com
http://www.finalfiler.com

I tried Admin as the user id, but no luck.  Other ideas?

dP

Pierre du Parte <pie...@finalfiler.com> wrote in message
news:7tkhbj$b5h10@forums.borland.com...
|
| I don't have D5, but assuming that the database is using the standard
| C:\Windows\System\System.mdw workgroup file, the user id is Admin
|
| No password is required
| --
| Pierre
| http://delphidao.finalfiler.com
| http://delphiotc.finalfiler.com
| http://www.finalfiler.com
|
|

Try leaving both blank.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to questions received via email)

Both blank does not work either.  Other ideas?

dP

news:7tm4ds$ots20@forums.borland.com...
| Try leaving both blank.
|
| Bill
|
| --
|
| Bill Todd - TeamB
| (TeamB cannot respond to questions received via email)
|
|
|

"Admin" is Access's Default user name with no password.  
If that doesn't work then someone has set up Access security with some other
user names and passwords

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Are you _sure_ that there is no user level security or database password on
this Access database?

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to questions received via email)

I had exactly the same problem, but unfortunately I can't recall the
solution since I tried so many different things before I finally got it
to work.  It was related to the driver for the database.  I'm now using
ODBC that I set up through the control panel.  I use a TDatabase
component where the AliasName points to the ODBC name and the
DatabaseName is used by all my components that access the database.  Try
deactivating everything except one component.  That technique helped me
to isolate the problem.

Sorry I can't be more help, but it was a lot of code ago when I had this
problem.  You're not imagining things.  It really is a problem, but once
you figure out how to set up the database it goes away.  I think it may
have been caused by trying to use Borland's Access driver instead of the
ODBC driver.  Using the TDatabase component makes the request go away
altogether once you get past the other problems.

Rick

Immediately after installing Delphi5, Enterprise Edition,
I clicked Database on the main menu, then Explore.
On the SQL Explorer, when I clicked the + box to the left of MS Access
Database,
Delphi displayed the Database Login dialog box.

This happens on both NT SP4 and Win98.

I tried various combinations of UserName and Password (including admin,
sysda, and blanks).

When I press Enter, a Database Engine Error displays the message "Key
violation.  [Microsoft][ODBC Microsoft Access Driver] General error Not
enough information to connect to this DSN with SQL Connect. Use
SqlDriverConnect BDE Error 9729 [$26][$1]"

The Database Login displays when I click the + box for dBase, Excel Files,
MQIS, MS Access Database, Visual FoxPro Database, and Visual FoxPro Tables,
but NOT when I click DBDEMOS or Default DD (both of whom use Paradox
drivers).

news:7to3l1$bpp7@forums.borland.com...
| Are you _sure_ that there is no user level security or database password
on
| this Access database?
|
| Bill
|
| --
|
| Bill Todd - TeamB
| (TeamB cannot respond to questions received via email)
|
|
|

Open up the ODBC Administrator and finish filling out that ODBC DSN.  It is
missing the Database itself.  The MS Access Database gets added as an ODBC DSN
at some point (I think it is done during install of Access, but not certain),
but whatever installs that DSN never fills out the Database portion of the DSN.

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
This sad little lizard told me that he was a brontosaurus on his mother's
side.  I did not laugh; people who boast of ancestry often have little else
to sustain them.  Humoring them costs nothing and ads to happiness in
a world in which happiness is in short supply.   (RAH)