Where is Compact and Repair in Access 2007?

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

Guest

I have been using a "trial" version of MS Office 2007. Using Access 2007 I
am looking for a database utility called "Compact and Repair database".

I routinely run into the max size of 2 gigs with my databases and often have
to split functions across several databases. I use this after each
subprocess in complete to keep the files from exceeding the 2.0 gig limit.

Ideas? Thanks...
 
Jack202 said:
I routinely run into the max size of 2 gigs with my databases and often have
to split functions across several databases. I use this after each
subprocess in complete to keep the files from exceeding the 2.0 gig limit.

I'm with Jerry on this one. Have you consider SQL Server? What kind
of data do you have that routinely requires more than 2 Gb of data?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top