The main disadvantage is that you cannot enforce referential integrity between multiple backends.
 
I'm forced to do things with multiple backends for one of my clients.  You just need to manage your interfaces so that you maintain integrity as you would with relationships. 
 
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)




From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of vjcross2004
Sent: Tuesday, October 18, 2005 6:19 AM
To: [email protected]
Subject: [AccessDevelopers] Multiple BE vs one BE

Are there any advantages/disadvantages in keeping all the data tables
in one back end file as opposed to splitting the biggest data tables
into their own BE?
Or does it make no difference?

Jane






Please zip all files prior to uploading to Files section.




SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming


YAHOO! GROUPS LINKS




Reply via email to