I have a linked table to an exchange folder. My access application appends records to this table. When I work on my local machine the "Link Table Manager" says the path is:
C:\TEMP\TMP\Inventory Adjustment Tracker
I also have a server that has a scheduled job to append the records to this table. When I open the db on this machine it can't find the table. I must relink to the exchange folder. Then the "Link Table Manager" says the path is:
C:\DOCUME~1\OPSAUT~1\LOCALS~1\Temp\ Inventory Adjustment Tracker
All is well until I need to work on my local machine again. I need to do the relink thing again.
Does anyone know how to link directly to the exchange folder and not to a TMP or Temp folder on the local machine?
Thanks,
Pat
C:\TEMP\TMP\Inventory Adjustment Tracker
I also have a server that has a scheduled job to append the records to this table. When I open the db on this machine it can't find the table. I must relink to the exchange folder. Then the "Link Table Manager" says the path is:
C:\DOCUME~1\OPSAUT~1\LOCALS~1\Temp\ Inventory Adjustment Tracker
All is well until I need to work on my local machine again. I need to do the relink thing again.
Does anyone know how to link directly to the exchange folder and not to a TMP or Temp folder on the local machine?
Thanks,
Pat