Re: Connection to Access Database Problem

Michael,

UserName & Password are OK as I (currently) have to enter them when I open
the mdb in Access. I didn't give the actual username/password ;-). The error
I get occurs when I hit the Test button in the Connection Editor - at this
stage I haven't been asked to enter a username/password.

Originally the mdb didn't have any userid/password set (which is how I had
the editor parameters set to, with LoginPrompt set to False). When I kept
getting the error which says suff about the workgroup information file
missing I created this file. Part of that process was in providing a
username and password. By choice I don't want a userid/password, especially
whilst I'm developing/testing.

I've just deleted the above connection and tried setting up a new one.
Without changing anything (taking all the defaults) & pressing Test I get
the same error instantly. Like it isn't even looking at the database. Then I
pointed it to the mdb file & left other parms as they were (login set to
false, UserName=myuser, UserPassword=mypass & pressed Test - same error.
When I remove the username/password I get a BDP exception error.

Just entered Admin as username & no password, as you suggest, & get
different error messgae. I've subsequently pointed the Database to another
copy of the mdb in an entirely different folder and I get a succesfull Test
connection! How weird is that! It's the exact same database - one copy is in
the wwwroot folder the project files are in (doesn't work) the other in
another folder and it does work.

Barry

"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:4469b446$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Barry,

Is Myname/mypassword a legitmate username/password combination for your
database? If not, then they should be blank as they wil cause the error
you're seeing. And since 'Login Prompt' is set to True are you entering a
valid username/password in the dialog (default username is Admin with no
passord).

Michael

"Barry Wood" <Barry@xxxxxxxxxxx> wrote in message
news:446981c8$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Michael,

Here are the settings shown in the Connection Editor:

Database: C:\Inetpub\wwwroot\PGCCalendar\CalendarPGC.mdb
Name: conCalendar
UserName: Myname
UserPassword: mypassword
ConnectionLifetime: 0
GrowOnDemand: True
MaxPoolSize: 100
MinPoolSize: 0
Pooling: True
BlobSize: 1024
LoginPrompt: True
QuoteObjects: False
Tracing: False
TransactionIsolation:ReadCommitted
Assembly: Borland.Data.Msacc, Version=2.5.0.0, Culture=neutral,
PublicKeyToken=91d62ebb5b0d1b1b
Provider: MSAccess
VendorClient: msjet40.dll

these last two are greyed (not editable)

Pressing the Test button gives the error message.


"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:4468eae5$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Barry,

What are the settings you see when you open the connection editor?

Michael

"Barry Wood" <Barry@xxxxxxxxxxx> wrote in message
news:4468b763@xxxxxxxxxxxxxxxxxxxxxxxxx
Michael,

I can't see a Connection string as I'd expect - there is a Connection
Editor with settings: the location of the mdb file, username, password
that sort of thing.

Actually, I a copy of this mdb on a website for real - only there I've
used Dreamweaver to set it up & it works fine - no error messages etc.
The connection string is setup by DW OK. With this one I'm using the
BDP on the Data Explorer tab to try to get access. Maybe there is
another way?

Barry

"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:446873e9@xxxxxxxxxxxxxxxxxxxxxxxxx
Barry,

It still really sounds like an issue in your connection string and you
are correct it is a problem with Access and not Delphi. I encountered
the problem a few years ago. What is the connection string you're
using?

Michael

"Barry Wood" <Barry@xxxxxxxxxxx> wrote in message
news:44683fda$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Michael,

Thanks for that. I've looked at this link & tried to follow what it
is saying, but it doesn't make sense. The error message is clearly
wrong as the .mdw file is with the database & nobody else is using
it. The article talks about data access pages, which I am not using -
I want access to the tables and views that I've created not any data
access pages.

The article refers to Access 2002 & 2003 wheras I'm using Access
2000.

How frustrating is this - a simple connection to a database is a
major mystery - why do Microsoft make things so complicate?

Barry


"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:44672707$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Barry,

Most likely you've an incorrect or missing value in the connection
string.
This page may provide more info

http://support.microsoft.com/?scid=kb;en-us;300699&spid=2509&sid=54

HTH,

Michael
"Barry Wood" <Barry@xxxxxxxxxxx> wrote in message
news:4464fb0e$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I've just started to use Delphi 2006 to develop web pages. I'm
trying to get
a connection to an Access database but I get the following error
message:

SQL State: 3028, SQL Error Code: =124520301. Cannot start your
application.
The workgroup information file is missing or opened exclusively by
another
user.

..which doesn't mean a lot to me. I don't have Access ot the mdb
file open
anywhere else. & the mdb is just a simple access file - I haven't
set any
secutity on it.

Has anyone had this problem before and how might I solve it? It
sounds like
an Access problem rather than a Delphi one, but maybe not...

Barry Wood


























.