MS error message - need help - please

hi all - first post - unfamiliar territory - looking for a helping hand
been trying to open/use an old app - dev'd about 5 or 6 yrs ago - uses an export/import function to an Access db. I'm on Vista Home Prem using Office 2007 [app was dev'd using Access 2000]....keep getting "Data source name not found and no default driver specified".

I am not a db guy nor a prgrmr but I have just enough knowledge to really f'up my machine and i'm well on my way....i've tried some benign tinkering inside Vista's admin tools but nothing has changed.

Can anyone help me decipher the following and explain it to me as if i'm a fifth grader?:

************** Exception Text **************

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode) at
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions) at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningObject) at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.Odbc.OdbcConnection.Open() at
KADU.KADUFunctions.KADUMDBConnect(String MDBPath) at
KADU.PlayerFileIO.ClearKADU_MDB() at
KADU.PlayerFileIO.WriteToKADU_MDB(Player[] Players) at
DMBPlayerEditor.frmMain.btnExportKADU_Click(Object sender, EventArgs
e) at System.Windows.Forms.Control.OnClick(EventArgs e) at
System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at
System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks) at
System.Windows.Forms.Control.WndProc(Message& m) at
System.Windows.Forms.ButtonBase.WndProc(Message& m) at
System.Windows.Forms.Button.WndProc(Message& m) at
System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies ************** mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
---------------------------------------- KADU
    Assembly Version: 0.6.0.0
    Win32 Version: 0.6.0.0
    CodeBase: file:///C:/dmb9/KADU/KADU.exe
---------------------------------------- System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---------------------------------------- System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3620 (GDR.050727-3600)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---------------------------------------- System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---------------------------------------- KADU_Library
    Assembly Version: 0.7.0.0
    Win32 Version: 0.07.0
    CodeBase: file:///C:/dmb9/KADU/KADU_Library.DLL
---------------------------------------- System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
---------------------------------------- System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------

Thanks to anyone who takes the time to read this
ATB
Tom k

1 answer

Hey Tom --

Just to take a stab at it -- my assumption is you are connecting to access from another of the office programs - probably excel? If so there are two different first step answers that you may have already taken a look at - or maybe not.

1 - if you want to keep the access db in 2000 format then I would check your vba references. You will need the Microsoft ActiveX Data Objects 2.8 Library to communicate with access 2000.

2 - if you are upgrading your access db to 2007 then you need to change your connection string and driver to match up with the connection string shown on this site. If you want a specific example just reply back and I'll send you an example.

If you have already checked both of these then you are beyond me already so good luck waiting for someone else to answer ...

Thanks --