Re: Connection to Access Database Problem

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
















.

Relevant Pages

  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... 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. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Fujitsu NetCobol 8.0
    ... You cannot use a connection string in the way you have shown and expect it ... Any Fujitsu NetCobol / PowerCobol users here? ... Use the ADO control provided in PowerCOBOL, ...
    (comp.lang.cobol)
  • Re: Changing Connection String programmatically
    ... This is a good situation for putting the connection string information in the app.config file. ... every year we will create new database. ... change the body of the private void InitConnection(), ...
    (microsoft.public.sqlserver.connect)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... Also see http://www.connectionstrings.com/ and try other providers ... > Here is some of my connection code: ... >> And are you sure your connection string is ok. ... >>> Oracle error occurred, but error message could not be retrieved from ...
    (microsoft.public.dotnet.framework.aspnet)