Update data from sql, using ODBC - avoiding password

P

Peter

Hi.

(Excel 2007)

I am preparing a model to be used by multiple users every week. A part
of the model is a list of active project in the company.

The project informations comes an sql database.

In the model I have a table, which should be updated when the
excelmodel is opened.

The users do not have access to the sql database. Is there a way to
set he table (properties, ... ) with the password stored in the model
e.g. the users do not have to know and enter the password.

Med venlig hilsen

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top