DSN

[amulay]

Hi,
I want to set a DSN on my local machine pointing to a Access database located in some folder at my web site.
eg.
www.xyz.com/Data/abc.mdb
How do I do it ..... I can definately set a DSN pointing to a SQL Server database located at my web site then why not with Access ......

regards,
Amulay

[Iouri]

You can set MS Access driver the same way how you set it for SQL server. Go to Control Panel->ODBC Data Source. Chose User or System DSN and click the button Add. You will see Microsoft Client Access driver. If you don't see it there - it means that you don't have driver installed on your computer. Install the latest version of mdac_typ.exe. It will update your ODBC drivers. You can download mdac from
http://www.microsoft.com/downloads/search.asp? and do search by keyword mdac


Iouri Boutchkine
iouri@hotsheet.com