Sharing External Data Source spreadsheets

[Deano1976]

MS Excel 2000

I have a workbook in Excel with about nine worksheets, all of which have an external data source connection to a MS Access database. I want to be able to share this spreadsheet with other users who may not have the source database or indeed may not even have MS Access. How can I do this?
Currently when one of the users tries to open the excel workbook they get the following message -'Microsoft Access Driver Login Failed'.

 

[xlbo]

They may not need Access - just the Access ODBC driver

Should be able to download it from MS site...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Deano1976]

What if the MS Access database the ODBC would link to does not reside on a network drive they can have access to? And what if I cannot put the database on a drive they have access to?

 

[xlbo]

then you are up the proverbial creek I am afraid....If they cannot access the database location then they cannot access the database data...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question