Hi,
I am writing a program which will work on several computers. On the same network each computer connects the same SQL Server and creates Linked Tables on Access. The problem is, the ODBC on each computer has the same name but different defalut database. I want each of these computers to connect to their own database. Is there a way that i can learn the default database of an ODBC through VB code? My current solution is i am making ADOX connection for each table (i link 30 tables, but DB has 50 tables). It automatically connects to default DB but it is very slow. I couldnt do this with DoCmd.TransferDatabase command. Is it possible ?

Thanks For Help