Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-02-12 : 09:41:15
|
| Hi is there any way of increasing the size of a access database to be more than 2gigs ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-12 : 09:43:48
|
| If you have a MS Access database of 2 gig, you most probably have other issues than lack of storage space.Is the 2 gig in size after a Compact & Repair?Peter LarssonHelsingborg, Sweden |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-02-12 : 10:35:35
|
| My size issues is related to data i take in data each day about 200mb of it from extracts. so the database is growing in size but i then delete the pervious days data before i bring in the next days. I have Compact & Repair the Db it brough it down to about 1.6 but my problem keeps repearing am thinking i might create another DB and create a linked table to it. It just i have lots of forms and queries linked to the tables will this work ok with linked tables if i leave the name the same ? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-12 : 10:41:29
|
| Is there a chance you can store the data in a MS SQL Server, and still use MS Access as front-end application?Peter LarssonHelsingborg, Sweden |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-02-12 : 12:15:53
|
| If you must keep it in MS Access, you can move some of the tables into separate MDB files and then link them all together in 1 master MDB file. As long as each "slave" MDB file is less than 2 gigs, you should be fine. If the data is all in 1 big table, you could essentially horizontally partition the data into separate tables and store each of those tables in its own MDB file as well.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-02-13 : 04:19:13
|
| I have decided to split the data up into 2 databases, what i like to know is that if i create a linked table and give it the same name as the old table will this affect any od my forms or queries in the master DB ? Thanks for your help on this matter. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-02-13 : 08:16:44
|
Noedit: Actually, the main issue I can remember from doing this is that you cannot have referential integrity between two different MDB files. This may or may not affect you, but it is definitely worth noting and planning for, especially if you have cascading updates or deletes and whatnot that you use and rely on and you end up putting two related tables in two different MDBs.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
2 Gig limit size