Re: Access 2007: Creating a local relationship between two remote ODBC tables

"Richard@Home" <richardathome@xxxxxxxxx> wrote in
news:e4324d0b-559b-4a9c-a731-1548a3197675@xxxxxxxxxxxxxxxxxxxxxxxxxxx
m:

Here's the code again (from my original post).

[snipped]

It's using Microsoft ADO Ext. 2.8 for DDL and Security, I'm quite
happy to change this to another library if that will get the job
done :-)

Why are you using a generic library to create a structure that is
proprietary to Access? I don't know for a fact that DAO can create
the non-enforced relationship, but it would be the first choice,
since you're altering something in a Jet MDB (i.e., the front end).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Is there a Stuff() Function or equivalent in MS Access
    ... If search for Midin VBE help in Access, ... with its own Help article and example code. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.modulesdaovba)
  • Re: App Crashes on Compact & Repair
    ... only import into a new MDB from a decompiled and compacted source, ... some of the corrupted code could be carried over ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)
  • Re: Access not Installed on Pc, Are user still able to use application?
    ... I'm running an A2K-format MDB in the runtime, ... developed in A2K3. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.externaldata)
  • Re: Snow Storm
    ... He has an email waiting. ... Uh, please don't interfere. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (soc.motss)
  • Re: Where is the best gay place to live?
    ... You should be able to figure out who is plonkable by reading a ... couple of posts. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (soc.motss)