Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-15-2019, 07:00 AM   #16
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,545
Thanks: 13
Thanked 1,449 Times in 1,381 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Long Text Tables

Quote:
In a system where you are required to develop to avoid into the Maximum Open Databases limit.
Good application design would control this. Users get confused when too many forms are open at once and so most applications limit the number of open forms. Once you do that, the problem of too many tables open goes away.
Quote:
We don't really use the built-in referential integrity anyway.
RI is there for a reason. The reason being to protect the integrity of data. It's a dirty job but someone has do it. If the database engine does it in one place, you don't have to do it in hundreds of places.

I don't like the multi-use solution you have chosen but at least you have made it possible to use RI by defining a unique tableNum and an intermediate m-m table. To enforce RI, you need to include that dummy field in every "from" table. That way you can make the tableNum and FK unique in the m-m table and enforce RI on the two column unique index. Normally RI involves the primary key of a table but in this case, you would reference the unique composite index.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 04-15-2019, 01:44 PM   #17
Thales750
Formerly Jsanders
 
Join Date: Dec 2007
Location: Galveston, Texas
Posts: 1,638
Thanks: 50
Thanked 28 Times in 28 Posts
Thales750 is on a distinguished road
Re: Long Text Tables

I agree about the Maximum. We have been using more popups and less subforms behind Tab Controls. Multiple subforms on Pages of Tab Controls should be avoided for a number of reasons. It is about the easiest way to bloat a system.

It takes building one before you believe just how bad it gets.

Having orphaned records is not any kind of problem at all. Like I said, we use queries for data entry, and never allow deletions.

Never allowing deletions is a fundamental requirement of mission critical data. I can't even imagine the problems that would cause.

"What happened last week, when we sent that shipment to Algeria without Prepay?

I don't know, what shipment?

Yeah, not good.
__________________
Aboard Oceans Eleven on Offatts Bayou
inveniemus viam aut faciemus
Thales750 is offline   Reply With Quote
Old Yesterday, 09:20 AM   #18
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,545
Thanks: 13
Thanked 1,449 Times in 1,381 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Long Text Tables

Someone can and will break RI on any app where you have rolled your own. It is hubris to think you can do this better than the database engine.


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In-text citations in long text field Harry Paraskeva Forms 5 02-08-2019 02:20 AM
Short Text -> Long Text PD1978US1 General 2 01-15-2018 04:46 AM
carriage returns not showing up in text field(long text) MilaK Forms 3 09-06-2017 06:04 AM
Question importing multiple rtf documents into rich text format long text field. niawo General 2 07-05-2017 02:50 AM
Query changing Data Type from long text to short text Galette Queries 4 11-12-2015 05:16 AM




All times are GMT -8. The time now is 10:53 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World