Re: Linked Tables Manager
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 06/16/04
- Next message: varvil29: "Form inputting"
- Previous message: John Vinson: "Re: Establishing Relationships with ID numbers as foreign keys"
- In reply to: Eric Butts [MSFT]: "RE: Linked Tables Manager"
- Next in thread: ryan: "RE: Linked Tables Manager"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 13:34:10 -0500
The only thing missing is "apon starting a database for the first time". I
use code in the on open of a splash screen (or startup code) that attempts
to open a recordset based on a linked table. If the code errs, then the
error handling runs a function that relinks the tables.
-- Duane Hookom MS Access MVP -- "Eric Butts [MSFT]" <ebutts@online.microsoft.com> wrote in message news:QIDPok8UEHA.328@cpmsftngxa10.phx.gbl... > Hi Ryan, > > Create an AutoExec macro that uses the Action > > RunCommand > Command: LinkTableManager > > Or if using VBA > > DoCmd.RunCommand acCmdLinkedTableManager > > > I hope this helps! If you have additional questions on this topic, please > respond back to this posting. > > > Regards, > > Eric Butts > Microsoft Access Support > ebutts@online.microsoft.com > "Microsoft Security Announcement: Have you installed the patch for > Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises > you to review the information at the following link regarding Microsoft > Security Bulletin MS03-026 > <http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or > to visit Windows Update at <http://windowsupdate.microsoft.com/> to install > the patch. Running the SCAN program from the Windows Update site will help > to insure you are current with all security patches, not just MS03-026." > > This posting is provided "AS IS" with no warranties, and confers no rights > > > -------------------- > | Content-Class: urn:content-classes:message > | From: "Ryan" <anonymous@discussions.microsoft.com> > | Sender: "Ryan" <anonymous@discussions.microsoft.com> > | Subject: Linked Tables Manager > | Date: Wed, 16 Jun 2004 09:47:53 -0700 > | Lines: 9 > | Message-ID: <1d16101c453c1$aac02850$a301280a@phx.gbl> > | MIME-Version: 1.0 > | Content-Type: text/plain; > | charset="iso-8859-1" > | Content-Transfer-Encoding: 7bit > | X-Newsreader: Microsoft CDO for Windows 2000 > | Thread-Index: AcRTwarAbc8DS6JVTjyFkcYc4PmRng== > | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 > | Newsgroups: microsoft.public.access.tablesdbdesign > | Path: cpmsftngxa10.phx.gbl > | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:80776 > | NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163 > | X-Tomcat-NG: microsoft.public.access.tablesdbdesign > | > | I would like to have the Link tables manager to pop up > | apon starting a database for the first time. But I > | cannot figure out how to do this. > | > | Can any body offer any suggestions. > | > | Thanks in advance > | > | ryan > | >
- Next message: varvil29: "Form inputting"
- Previous message: John Vinson: "Re: Establishing Relationships with ID numbers as foreign keys"
- In reply to: Eric Butts [MSFT]: "RE: Linked Tables Manager"
- Next in thread: ryan: "RE: Linked Tables Manager"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
