Access 2006; Is 2 Gig database limitation addressed ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003 and previous can't handle databases that reach 2 Gig in size.
Only alternative that has worked is to break up tables and link various
databases together. Sloppy. Issue still out there with Access 2006 ? Other
options to address available ? Thanks.
 
mark said:
Access 2003 and previous can't handle databases that reach 2 Gig in
size. Only alternative that has worked is to break up tables and link
various databases together. Sloppy. Issue still out there with
Access 2006 ? Other options to address available ? Thanks.
Click to expand...

You sound like a candidate for an SQL server.
 
mark said:
Access 2003 and previous can't handle databases that reach 2 Gig in
size. Only alternative that has worked is to break up tables and link
various databases together. Sloppy. Issue still out there with
Access 2006 ? Other options to address available ? Thanks.
Click to expand...

Just to add to my prior message. I am assuming you have a properly
normalized table design and have compacted the database, correct?
 
Yes to both your questions. What you are telling me is at end of the day if
my database is "flirting" with Access' 2 Gig limit that outside of what I
have oulined that I am doign today, that going to SQL is my only option. I
thought this was the case. Just wanted to confimr. thanks
 
mark said:
Yes to both your questions. What you are telling me is at end of the
day if my database is "flirting" with Access' 2 Gig limit that
outside of what I have oulined that I am doign today, that going to
SQL is my only option. I thought this was the case. Just wanted to
confimr. thanks
Click to expand...

Not exactly, I would tend to suggest that it is likely your best
choice. :-)
 
Back
Top