I have a database application in MS-Access running in Windows NT, that is in a network drive, and it has about 150 users.
What i want to do, is centralize the database in a PC that would be the server, and place the MS-Access tables in a MySQL database, and the tables would be accessed from MS-Access with ODBC. The MS-Access Application remains the same, the only diference is the tables that would be acessed with ODBC. I would like to know if there is any way of setup and configure ODBC automaticaly, because i have 150 users, and i wouldn't like to setup and configure the ODBC Data Source in 150 PC's. The Optimal solution would be when the application starts, detects if the ODBC Data Source exists, and if it doesn't exists, copy (for example from a network drive) the files needed into the operating system, and the process would be transparent to the user. If anyone has a solution to this problem i would be gratefully. Best Regards, Francisco Spínola --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php