Create a form that inputs to multiple tables in seperate files.

  • Thread starter Thread starter Guest
  • Start date Start date
Hi, Tom.
I'm trying to creat an input form that will add/update/edit tables in
multiple files
Click to expand...

Do you want to add tables using this form or add records to existing tables?
If it's the former, it's better to let the Access database developer design
the tables and relate them to others, then design the database application
based upon that database design rather than to let the user stick a monkey
wrench into the gears by adding tables.

If it's the latter, then this implies that these are related tables, which
means that referential integrity cannot be enforced between tables located
in different database files. If this is the case, then move the tables to
the same database file and use this as a back end, set referential integrity
on the relevant tables, link to the tables in the back end and create a
query in the front end that displays the columns in the tables needed. Use
the Form Wizard to create a form with this query as its Record Source.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
The reason that I used seperate files was to manage size. One of the tables
fields will contain OLE objects. In the past these objects make the file size
grow to large. Does this logic make sense?
 
Hi, Tom.
Does this logic make sense?
Click to expand...

Yes. It does. It's very common to try to spread out large tables to
multiple database files. The downside is that referential integrity in a
relational database cannot be enforced on tables located in external files.
If the tables you need to enforce referential integrity on can't fit
comfortably inside one 2 GB Jet or ACE database file, then it's time to move
to a bigger database engine. SQL Server 2005 Express, Oracle 10g Express,
and IBM DB2 Express-C are free to download and hold 4 GB of data or more.
In IBM DB2 Express-C's case, there's no data file size limitation, whereas
the other two hold up to 4 GB of data. If that's not enough, consider
migrating to a larger version of any of these database engines, although
those won't be free.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Hi, Tom.

In case you're interested, you can find the links to download the free SQL
Server 2005 Express, Oracle 10g Express, and IBM DB2 Express-C at the Web
site on the following Web page, along with a short explanation of each of
them.

http://www.Backends.QBuilt.com/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Thanks for the help.

'69 Camaro said:
Hi, Tom.

In case you're interested, you can find the links to download the free SQL
Server 2005 Express, Oracle 10g Express, and IBM DB2 Express-C at the Web
site on the following Web page, along with a short explanation of each of
them.

http://www.Backends.QBuilt.com/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Click to expand...
 
Back
Top