Freehold Fred
07-26-2006, 04:05 PM
Here is the problem:
My client has the photo concessions at several amusement parks around the US and Canada. Within each park, there may be several locations: front gate, specific ride, etc. The client normally enters weekly data for revenues, attendance, labor, and COGS, but the client also has permission to add new parks and new park locations, in what I call a maintenance module.
I created a front-end and back-end with linked data tables in Access. The linked tables use absolute references on a network drive: H:\folder\file_be.mdb.
Client entered new maintenance data, ran reports, and as a result, the data for one of the parks (a related table to location within park) did not show on any weekly or YTD reports.
I had the client send me the data file and the front-end engine. By observing the main maintenance tables, somehow a foreign key was wiped out and thus the data did not show on the reports. I still trying to figure out how that happened, but the fix was easy by rechoosing the foreign key from the available list box lookup. No problem!
The question is, as a developer and if I want to make changes to the Front-End, should I mimic the absolute references to the 'network drive' above or simply change it temporarily and then change it back. Is there an easier way to do this with Link Manager?
Fred
My client has the photo concessions at several amusement parks around the US and Canada. Within each park, there may be several locations: front gate, specific ride, etc. The client normally enters weekly data for revenues, attendance, labor, and COGS, but the client also has permission to add new parks and new park locations, in what I call a maintenance module.
I created a front-end and back-end with linked data tables in Access. The linked tables use absolute references on a network drive: H:\folder\file_be.mdb.
Client entered new maintenance data, ran reports, and as a result, the data for one of the parks (a related table to location within park) did not show on any weekly or YTD reports.
I had the client send me the data file and the front-end engine. By observing the main maintenance tables, somehow a foreign key was wiped out and thus the data did not show on the reports. I still trying to figure out how that happened, but the fix was easy by rechoosing the foreign key from the available list box lookup. No problem!
The question is, as a developer and if I want to make changes to the Front-End, should I mimic the absolute references to the 'network drive' above or simply change it temporarily and then change it back. Is there an easier way to do this with Link Manager?
Fred