R
Remco Groot Beumer
Hello all,
I've created a MS Access database in which there is an action to write
values to a temp table. I've developed an ODBC (user DSN) which relates to
my database. Now i want to install my application at another company which
has other paths where the access database is placed. I created an ODBC on
the machine and connect it to their database. When I want to open my excel
pivot table (refresh it) it asks me where the database is placed. I then can
search this database (i have to do this 3 times) and it works but when i
later on reopen this...i have to do it all again.
Is there a way to do this more simple, so i don't get the message that the
database is not found.
Any suggestions would be appreciated.
Thanks,
Remco
I've created a MS Access database in which there is an action to write
values to a temp table. I've developed an ODBC (user DSN) which relates to
my database. Now i want to install my application at another company which
has other paths where the access database is placed. I created an ODBC on
the machine and connect it to their database. When I want to open my excel
pivot table (refresh it) it asks me where the database is placed. I then can
search this database (i have to do this 3 times) and it works but when i
later on reopen this...i have to do it all again.
Is there a way to do this more simple, so i don't get the message that the
database is not found.
Any suggestions would be appreciated.
Thanks,
Remco