jplivingston08
New Member
- Joined
- May 14, 2010
- Messages
- 7
We have an access database that currently draws information from tables within it and cross references that data with an excel doc for additional information (linked Excel Doc). Our problem is that the excel doc locks when a user is in editing items in access and this then does not allow anyone to access the queries or reports or edit any others. The excel doc is purely just reference... it is never changed from access. We have a program that scrapes our core system here and spits out a new excel file each day that replaces the old. So, i am not sure how we can fix this. I think that if we were to import the excel doc everyday into an access table then multiple people could edit and view at once. It would be preferred that the excel doc overwrite all data in the table in access so that there are not multiple entries that are the same. Is there an automated way of doing this? through a Macro or .BAT file? I do not know anything about coding with VB and Access... Maybe there could be a bat file that would delete the tables data in access and replace it with the current excel data...? Any ideas? We are a growing company and more and more people need access to this information.. Thanks for all and any help in advance!!!