Re: Link to a new table location

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 18:07:50 -0500

There's sample code at "The Access Web" in
http://www.mvps.org/access/tables/tbl0009.htm but it'll need some tinkering,
as it's only set up to handle all tables being in the same database.

Post back if you have problems modifying it for your purposes. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Beth" <bigblueogre@sbcglobal.net.INVALID> wrote in message 
news:fewNd.26547$wi2.7991@newssvr11.news.prodigy.com...
>I am struggling with a linked table issue.  My database has about 15 tables
> and 1 of them (tblMembers) is linked to another database, which keeps
> moving.  I would like create some code that let's me specify the new data
> path and it relinks the table to the new path.  I am  not very experienced
> with VBA, so any help you can offer is appreciated.
> Thanks,
> Beth
>
>

Relevant Pages

  • Re: Converting Access 2000 back to 97
    ... Access 2000+, and recent versions of SQL Server, normally use ... and if any of your tables use nVarChar fields ... On the other hand, if this is a old database, using VarChar ... The sample code often demonstrates linking CurrentDB, ...
    (microsoft.public.access.conversion)
  • Re: Registering programs in access
    ... It worked fine for me with no changes to the sample code. ... 'Create text string containing "Database to Call". ... >> (no private e-mails, please) ...
    (microsoft.public.access.conversion)
  • Re: Fun Code
    ... >It could be The Access Web: ... >> was referred to a website with sample code. ... >> clock, scrolling text box, randomly changing the color ... >> anyone that could assist me in locating this website. ...
    (microsoft.public.access.formscoding)
  • Re: Create Site: The specified domain either does not exist or could not be contacted.
    ... I specified email server settings again which succeeded. ... if I use the complete sample code for extending a vs: ... Database 'sts_content' already exists. ... After you create a new configuration database, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to capture SelHeight when pressing a button?
    ... Create module level variables for the form's SelTop and SelHeight props ... Finally the Access Web contains sample code based on a Timer event that ... "Bertrand" wrote in message ...
    (microsoft.public.access.formscoding)