G
Guest
I'm trying to creat an input form that will add/update/edit tables in
multiple files
multiple files
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
6
'69 Camaro
Hi, Tom.
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.
I'm trying to creat an input form that will add/update/edit tables in
multiple files
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.
G
Guest
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?
fields will contain OLE objects. In the past these objects make the file size
grow to large. Does this logic make sense?
6
'69 Camaro
Hi, Tom.
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.
Does this logic make sense?
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.
6
'69 Camaro
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.
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.
G
Guest
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.
6
'69 Camaro
You're welcome. Don't forget to compact the files to see just how small the
tables are, and try to use temporary database files for temporary tables and
link to those to avoid bloat in your back end.
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.
tables are, and try to use temporary database files for temporary tables and
link to those to avoid bloat in your back end.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.