Hello,
I have a workbook which has links to access to import data. I have to have the information in Excel for a couple reasons: 1.) Many of our customers don't have Access. 2.) The customers use a "discount calculator" to apply their own discounts. They also use it to then apply their own margin mark ups to be able to then use to quote to their customers. So a static report/pdf for them to look at doesn't work.
I've begun to create links from a number of queries in Access, which work fine. My problem is when I go to update the data. I'm not getting the following error coming up:
The database definitely hasn't moved. And I've run the queries in q, and there aren't any problems there. I've looked this error up and I'm seeing that it could mean that I've got some corruption going on.
Before I hit my main q, I should also note: I'm running all of this on a Citrix network. I should also note that it's a consulting gig. Once I'm done, I won't be available to fix major issues like this. My main q: will this corruption problem/error happen frequently? I'm in the early stages of linking this data, and I'm having a hard time fixing it, and the people who are there will really have trouble doing so. Anyone out there have experience here?