Where is Compact and Repair in Access 2007?

[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...

 

[Brendan Reynolds]

Click the round Office icon in the upper-left corner, then choose 'Manage'.

 

[Guest]

Have you considered upsizing to SQL Server?

 

[Tony Toews]

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