Does anybody have experience in playing with system tables? I need to be able to send a front-end that I cannot link directly to a user's back-end database. I see that the MSysObjects table holds the complete path to the linked tables. It seems to me that I could use a query or code to simply change the path for all the linked tables. Has anybody tried this? Do I risk crashing everything by doing this?
When I open the table, it won't let me type in a different path in the Database field, says "Control can't be edited; it's bound to replication system column 'Database'."
As an alternative, I have my Linker programs up in Files that can do the relink. However, I am putting the compiled mde file up on a server, and it is copied to the user's computer each time they run the batch file that I give them to start the database. If I send over a differently-linked database and have the code triggered to relink when it doesn't find the key table, it is going to be triggered every time they start that batch file, since they are doing the download each time. If this query on the system table works, then I can make it a quick change before sending the new version out, as long as I know the path to their server, and nobody needs to know what's happened behind the scenes.
Tobi Hoffman
Dept. of Youth Services
Boston, MA
617 960-3354
Please zip all files prior to uploading to Files section.
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" 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.
