Hi,

I have created a program which uses access as the database. I wish to give it to my friends, but some of them are not much aware of windows administration.

Can i create a .bat file which can add the DSN for my database

Thanks in advance,

Alfahed p m

You need to create a .vbs script that will create the DSN.

Here is one for a SQL Server to get you started.

Uninstall your current DSN, then install it and note the changes, and document them.

You could also use a DSN-less provider statement so you wan't have to do this.

Let me know if you need additional help.

'------------------
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\AssetManagement\Descr iption", "SQL"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\AssetManagement\Drive r", "C:\Windows\System32\\SQLSRV32.dll"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\AssetManagement\LastU ser", "Unknown"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\AssetManagement\Serve r", "SQLDatabaseName"
WshShell.RegWrite "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\AssetManagement", "SQL Server"
'----------------------------------------

mmcdonal