I had a simular issue with a direct link between excel and access.
Access does not like importing information from some forumlas.
I found a way around it by creating a new worksheet in the spreadsheet titled IMPORT DATA and then just set up =A2 (or the cell reference of the information in the...
I've been having some problems with sharing an MS Access 2000 database across a network.
The database is setup to open in shared mode and has been tried both with and without record locking, with the same issue occurring.
The main users are:
User 1 (Administrator) - MS Access 2000 Full...