Import DDL database structure to Access database (1 Viewer)

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 19:41
Joined
Feb 28, 2001
Messages
20,240
Can't address the question about CONSTRAINT syntax. My "big boy" database experience is with ORACLE and a non-Access FE. Have to leave that to others more familiar with SQL Server and its variants.

However, the fact that you have the same two fields participating in two indexes might confuse Access more than just a little bit. It would probably matter considerably as to which index name you used for the relationships. Access really doesn't like it when you give it mixed signals - like, "Which index to use?" when there are two apparently identical options.

I would bet that if you switched from InvoicesCon to PrimaryKey in that little "Indexes" display, the only thing that would change would be that "Primary" would be YES for that one.

It is your database and of course you are more familiar with it - but people's names are usually very poor choices as PKs. Given you have only First name and Last name, my dad and I couldn't be in your database together. Because we have the same names except he was "Senior" and I was "Junior."
 

Minty

AWF VIP
Local time
Today, 01:41
Joined
Jul 26, 2013
Messages
8,612
I couldn't enforce referential integrity in the UI for a join of that type, which means you probably can't code it either.
 

jaryszek

Registered User.
Local time
Yesterday, 17:41
Joined
Aug 25, 2016
Messages
740
Minty,

you mean cant code by VBA?

Jacek
 

Minty

AWF VIP
Local time
Today, 01:41
Joined
Jul 26, 2013
Messages
8,612
I couldn't make it work, but it is not something I have ever tried to do in Access.

I wonder if the amount of effort you are expending on this far outweighs any potential benefit.
 

jaryszek

Registered User.
Local time
Yesterday, 17:41
Joined
Aug 25, 2016
Messages
740
We will see i hope it will be useful.
Maybe i will try to do this via VBA...

Jacek
 

Users who are viewing this thread

Top Bottom