• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1892
  • Last Modified:

Access 2007 dsn less connection string

I have an access 2003 database that has been converted to 2007.  How do I modify my dsn less connection string so that my asp pages can read the new file?  My current code is

DB_CONN_STRING = "Driver={Microsoft Access Driver (*.mdb)};"
DB_CONN_STRING = DB_CONN_STRING + "Dbq=d:\webs\data\test.mdb;"
DB_CONN_STRING = DB_CONN_STRING + "Uid=Admin;"
DB_CONN_STRING = DB_CONN_STRING + "Pwd=;"
'------------------------------------------------------------------------
set Conn = server.CreateObject("adodb.connection")
Conn.Open DB_CONN_STRING
0
AHMA001
Asked:
AHMA001
  • 4
  • 3
1 Solution
 
Gustav BrockCIOCommented:
Nothing? Except if you changed the filename to test.accdb, and in that case UID and PWD is of no use, as user level security has been removed from Acess 2007 using the new fileformat.

/gustav
0
 
AHMA001Author Commented:
I've tried this and I get a variety of errors, depending on how I tweak it.  Either a resource not found or some generic microsoft error message that appears to be similar to one where the file does not have permissions.  I have confirmed the file is there and if I put a new file out it the directory that is Access 2003 it works fine.  
0
 
Gustav BrockCIOCommented:
But do you really need to convert this file? Access 2007 works nicely with a 2003 file (mdb). And I doubt very much that your ASP pages will see any advantages changing the database file to accdb type.

/gustav
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
AHMA001Author Commented:
Actually, yes I do.  Access 2007 has data import wizards that I want to use so that my user can do a two clicks and your done process to update the data on-line.
0
 
Gustav BrockCIOCommented:
Yes, but that wizard is in 2007 - the frontend - and should work even if the backend - the file with your data - is in 2003.

If your database isn't split in a frontend and backend, a wizard to create that exists.

/gustav
0
 
AHMA001Author Commented:
Sometimes it takes someone further away from the problem to see outside the box.  I never thought to put the data in a 2003 mdb and the wizard in a 2007 accdb.  That solved my problem.  Thank you very much.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now