How do I setup a DSN for a pasword protected accde file?

[Stewart Berman]

I tried to use the 32 bit ODBC manager but it only supports MDB and ACCDB
files. When I tried to enter an ACCDE file name it append .MDB to it.

Is it possible to create a DSN for a password protected ACCDE file?

 

[Arvin Meyer [MVP]]

Have a look here. You may find what you are looking for:

http://www.connectionstrings.com/access

 

[Stewart Berman]

I know how to setup a DSNless connection. What I need to know for this
specific project is how to setup a DSN for an Access 2007 .accdb/.accde
database.

 

[David W. Fenton]

I know how to setup a DSNless connection. What I need to know for
this specific project is how to setup a DSN for an Access 2007
.accdb/.accde database.

Arvin said nothing at all about dsnless connections. Did you
actually *bother* to follow the link you were given? While the
specific page doesn't have ACE connection strings, it's pretty easy
to find the ones for A2007:

http://www.connectionstrings.com/access-2007

I found that because I had the radical idea of putting "ACCDB" in
the search box on the page Arvin cited.

 

[Stewart Berman]

Arvin said nothing at all about dsnless connections. Did you
actually *bother* to follow the link you were given? While the
specific page doesn't have ACE connection strings, it's pretty easy
to find the ones for A2007:

http://www.connectionstrings.com/access-2007

I found that because I had the radical idea of putting "ACCDB" in
the search box on the page Arvin cited.

If you and Arvin had bothered to actually read the message I posted instead
of scanning it and jumping to conclusions you would not have wasted your
time doing a web search for connection strings.

I have already check all of the pages reference and quite a few others.

The connection string is not the problem I am trying to solve. The problem
I am trying to solve is how to create a User DSN with the connection string
in it. The Windows 7 32 bit ODBC Data Source Manager does not appear to
support Access 2007 although it does allow you to select the Access 2007
driver. However, if you put in the path/name of an .acc de file it appends
..db to it and then says it can't find it. It also does not provide a way of
putting in the database password -- only a user id / password combination
which is not supported for an ./.acc de database.

Now please tell me how I put the connection string into a DSN using the 32
bit ODBC Data Source Manager.

 

[David W. Fenton]

The connection string is not the problem I am trying to solve.
The problem I am trying to solve is how to create a User DSN with
the connection string in it.

Oh. Then my answer is DON'T.

Seriously.

DSN's cause more problems than they solve.

 

[Stewart Berman]

Oh. Then my answer is DON'T.

Seriously.

DSN's cause more problems than they solve.

I am aware of this and would normally use a DNSless connection.
Unfortunately, I need a DSN for a specific project.

 

[David W. Fenton]

I am aware of this and would normally use a DNSless connection.
Unfortunately, I need a DSN for a specific project.

You may *believe* that you do, but you really don't.