Re: Connection to Access Database Problem



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










.



Relevant Pages

  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Problems with ADO and Multithreading: List Index Out Of Bounds
    ... I've realized an application with Delphi 7 or Delphi 2006 and ADO ... connection to a Microsoft Access Database ...
    (borland.public.delphi.database.ado)
  • Re: Problems in loading data from an access database into an array
    ... Suppose your database has a table called which has columns called ... Dim oleCSB As New OleDbConnectionStringBuilder ... 'associate the connection string just built with the ole connection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Syntax
    ... The connection string format is not valid. ... connection string with zero components is set on database connection manager. ... Access database connection string, and not the Expression issue you're ...
    (microsoft.public.sqlserver.dts)