stored under the user id's Application Info \ Microsoft \ Queries folder.
Full Path is
C:\Documents and Settings\UserID\Application Data\Microsoft\Queries
When External Data in imported to a spreadsheet, it makes a query for the
user and saves it in this folder. This can be moved or modified and then
saved again.
Regards,
Mark
>From: "mpatter_us" <[EMAIL PROTECTED]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: [Access VBA Central] A really tough problem for the pros
>Date: Thu, 20 Apr 2006 11:52:34 -0000
>
>This is the first one that stumped me in a while. I am using an Excel
>workbook with three worksheets; each worksheet is dynamically linked
>via OLEDB to an access database on a server. Each worksheet is set to
>refresh on open. The workbook itself is linked to a website so when
>the user double clicks on the link, the workbook appears on their
>station.
>
>The problem revolves around the refresh on open aspect. When the
>workbook opens a message box appears that asks the user "Data file
>C:\myfolder\myfile.mdb not found. Would you like to connect
>to "http://myserver/myfolder/myfile.mdb" instead?" If the answer
>is "yes" the workbook updates automatically and all is well. If the
>answser is "cancel", no update occurs. If the answer is "no" ....well
>lets not go into that.
>
>My question is this: How does the Excel program know of the existence
>of the database at the server site? That is where is the various
>properties assoicated with the spreadsheets or associated queries can
>I find this key and change it? I know of the connection and
>commandtext and can change them via VBA. However, this is my first
>foray onto the web as a data publisher and I have been unable to
>address (if you will excuse a small pun) the problem.
>
>If I cannot get an answer to this one I will be force to abandon
>Access and move the app to SQL Server ( a fate worse than death so
>take pity).
>
>Thx
>
>Mik
>
>
>
>
>
SPONSORED LINKS
| Microsoft access database | Database development software | Microsoft access development |
| Database management software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
