How to create User DSN for *.accdb from commandline in Windows?

windows ms-access command-line odbc dsn
brainless picture brainless · Oct 5, 2012 · Viewed 7.5k times · Source

I work in an environment where DSN-Less connection is not possible due to some restrictions. I need to create User DSN for "Microsoft Access Driver (*.mdb,*.accdb)". the .accdb file is located in local disk.

I have tried C:\>odbcconf configdsn "Microsoft Access Driver (*. mdb,*.accdb)" "DSN=crt1|SERVER=c:\a.accdb". But this doesn't seem to work.

How to do it?

Answer

bohica picture bohica · Oct 5, 2012 
odbcconf configdsn "SQL Server" "DSN=fred|Database=dave"

works for me. I don't have a 64 bit MS Access driver on this 64 bit machine to try. You don't show the error. Why not add /Lv x.log and see what is in the log file.

However, is this a 64 bit machine? If it is I doubt you've got a 64 bit MS Access driver installed and odbcconf will be attempting to add a 64 bit DSN. If it works with c:\windows\syswow64\odbcconf then that will likely be your answer.

c\windows\syswow64\odbcconf configdsn "Microsoft Access Driver (*.mdb)" "DSN=fred;Database=dave"

works for me to create a 32 bit DSN.

Related questions

How to copy to clipboard using Access/VBA?

Using VBA inside Access2003/2007. How to copy the contents of a string variable to the clipboard? This site recommends a creating a zero length TextBox, copying the string to the TextBox, then running DoCmd.RunCommand acCmdCopy. Ugh. I mean, we …

Read More
Register RichTx32.Ocx in Windows 7 64 bit

I am trying to register RichTx32.Ocx for an application I am working on in Access 2010 (File Format 2003 mdb). I have been updated to Windows 7 64 bit (from Windows XP SP3 32 bit) and can't get the ActiveX OCX to register. I …

Read More
How can I show an "&" (ampersand) in button or label text?

I would like to show the & character, not the keyboard shortcut in the text property of a button or label. Is there a way to do this?

Read More