Access 2007: Creating a local relationship between two remote ODBCtables

#11

David Wrote:

Quote:

Why are you using a generic library to create a structure that is
proprietary to Access?

Because it was the first example of code that creates relations that I
found, most of the other example I found used the same libraries (or
referred to the original code I found). I'm a PHP coder by profession
and only use odd bits of Microsoft technologies thrown in when
requested by the client.

Quote:

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).

Ok, no problem. I'm always happy to learn. What technology would you
use in this case? A small snippet of example code would be very useful
too :-)

Lyle wrote:

Quote:

Set r = DbEngine(0)(0).CreateRelation("NameofRelation")

Thank's, I'll take a look at that this morning :-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2007: Creating a local relationship between two remote ODBCtables

comp.databases.ms-access comp.databases.ms-access

Re: Access 2007: Creating a local relationship between two remoteODBC tables - 01-25-2008 , 04:05 AM