D
Dave
I am linking to an Access 2000 database from Excel 2002
(using the External Data functionality). When I update my
Access table, I should be able ot click the Refresh icon
in Excel and have it update. This used to work fine. Then
I did not use it for a few months. I just updated my
Access table and in Excel click the Refresh icon, and get
a message that the database is not in the correct folder
(which it is). If I click OK I can locate the database
again (ie go to the same locaion on my hard drive, all
fiels are local) and then I get a login dialog, requiring
a login and password. The Login defaults to 'Admin' and
the password field is empty. The Access DB has no
password associated with it, and I am stumped. Thanks.
(using the External Data functionality). When I update my
Access table, I should be able ot click the Refresh icon
in Excel and have it update. This used to work fine. Then
I did not use it for a few months. I just updated my
Access table and in Excel click the Refresh icon, and get
a message that the database is not in the correct folder
(which it is). If I click OK I can locate the database
again (ie go to the same locaion on my hard drive, all
fiels are local) and then I get a login dialog, requiring
a login and password. The Login defaults to 'Admin' and
the password field is empty. The Access DB has no
password associated with it, and I am stumped. Thanks.