Moving Workbook linked to ODBC query

A

Adam

Dear All

I am using office 97 I warn you

I have a Access Database which links via an ODBC query to our mainframe database. Now I have an Excel spreadsheet which runs querys into my Access Database to retrieve the required information and place into the worksheet

This is brilliant BUT I now want to put this spreadsheet onto our shared network drive so that other users can access the spreadsheet and update it to their hearts content

When I send this spreadsheet to other users they cannot update it, how can I have this spreadsheet on the network drive so it can update

Many Thank

Adam
 
Top