I have created an Access database that links with a number of Excel spreadsheets using an ODBC link. When other people try to refresh the spreadsheets, they cannot as they do not have the ODBC. I can manually recreate the ODBC on each machine but 1. it takes too long and 2. i have a number of remote users who are not very IT literate. Is it possible to create an ODBC and save it and then email it to my users. If so, please can you give me step by step guidance on how to do it and also where the user should save it to make it work.
2006-10-23 07:10:43 · 1 answers · asked by emma 5 in Computers & Internet ➔ Software
I had a similar problem with the DSN. Then it struck me that VB allows you to create a DB connection without a DSN but only that the ODBC Driver should be installed in the accessing PC. Im pasting a link in Microsoft Help. Hope this helps.
.:Fishie:.
2006-10-23 21:29:26 · answer #1 · answered by Fishie 5 · 0⤊ 0⤋