Re: Linked Table-Embed Password

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

Date: Sun, 20 Feb 2005 11:19:42 -0500

What TC's trying to say is that if you're using tables from another source
(or even from another Access database), any relationships that are defined
must exist in the back-end. Any relationships you might have put in the
front-end don't actually do anything. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"LindaD" <anonymous@discussions.microsoft.com> wrote in message 
news:055301c5175f$2ea367c0$a501280a@phx.gbl...
> Sorry, your response makes so sense at all, back end table
> versus front end links?? never heard of that....everyone
> says to re-link the table.  If you use the Link Table
> manager on the current table, there is no option to save
> the password.  The only way to re-link a table is to
> delete it and do a new table and when linking, hit the
> save password box. Since I did not set up these database,
> who know what someone else did to the relationships but to
> delete a table, then start over with a new table is a
> mess.  Is this the only way to do this?
>>-----Original Message-----
>>
>>LindaD wrote:
>>(snip)
>>> The only way I have found is to re-link the table, a
>>> difficult and not happy chore when Access seems to lose
> every
>>relationship in
>>> the process.
>>
>>The relationships should be defined in the back end
> (containing the
>>tables), not the front end (containing the links to the
> tables).
>>
>>HTH,
>>TC
>>
>>.
>>

Relevant Pages

  • ODBC problem with linked tables
    ... I have an Access database that has linked tables to the ... tables in my oracle DB. ... failures until I re-link the tables. ... can elevate this problem? ...
    (microsoft.public.access.externaldata)
  • Re: Linked Table-Embed Password
    ... LindaD wrote: ... > The only way I have found is to re-link the table, ... > difficult and not happy chore when Access seems to lose every ...
    (microsoft.public.access.security)
  • Re: Linked Table-Embed Password
    ... Sorry, your response makes so sense at all, back end table ... The only way to re-link a table is to ... >LindaD wrote: ... >> difficult and not happy chore when Access seems to lose ...
    (microsoft.public.access.security)