Re: Connection to Access Database Problem

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






















.