Re: Connection to Access Database Problem

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: Permissions error trying to open MDB file with ODBC
    ... I have set the sharing/security on the folder where the MDB file ... Do you use an UNC path or a mapped drive? ... Do you use a DSN-less connection with a connection string? ... Try the DSN way, first local, then remote. ...
    (comp.lang.php)
  • Re: (Leo) ADO Connection Error
    ... - You probably know this one, specifies ... If you were using user-level security instead of or ... I have an Access mdb file with exclusive file password. ... Is there a difference between the connection string password and ...
    (microsoft.public.access.externaldata)
  • Re: Problem accessing Access/Jet databse: Could not lock file
    ... not lock file" when opening a connection to an Access database on a network ... shared folder. ... Since the .mdb file can be opened using Access and everything can be done, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Leo) ADO Connection Error
    ... The database password is separate and distinct from any user-level password ... I have an Access mdb file with exclusive file password. ... Dim cn As New ADODB.Connection ... Is there a difference between the connection string password and mdb ...
    (microsoft.public.access.externaldata)
  • Re: Cant Open OleDb Connection to Access Database
    ... When setting the data source in the connection string, ... > when I try to connect to an .mdb file on a network share, ... > and granting full control permissions on the share to everyone doesn't ...
    (microsoft.public.dotnet.framework.adonet)