Linked Table Dilema

[raymond.allan]

Hi,

Access 2000 & Excel 2000

I have 6 linked dbf tables to MS Access on a server which are
automatically updated each day

Queries are written in Access and Excel is used to extract data
depending on the users selection, this works fine when using the raw
dbf files, however there are occasions when the user has to do a what-
if scenario and the dbf files are copied to the users local C:\My
Documents folder where they can make changes to the dbf file using my
Excel program as the files on the server have to remain unchanged.

When running from the local drive I have to manually copy the mdb file
and change the links from the server path to C:\My Documents

Does anyone have a sample on how I can do this using VBA code in Excel

TIA

Raymond Allan

 

[Tom Wannabe]

you don't need to do this in VBA code

you need to do this in Access VBA

 

[Tom Wannabe]

and for the record, linked tables are not reccomended for anything anymore

you should learn SQL Server, use ETL tools to move all your data into SQL
Server and then use best in breed development, administration and reporting
tools