My Assistant
![]() ![]() |
|
|
Aug 5 2009, 01:15 PM
Post
#1
|
|
|
New Member Posts: 14 |
I have a deployed database that has all data stored on a remote SQL database. The size of the accdr file is very large - about 30MB. Why is the file so big? Is their a data cache stored in the file?
I have many forms, reports, queries, etc - but, not enough to justify 30MB. Is this normal? |
|
|
|
Aug 5 2009, 01:35 PM
Post
#2
|
|
|
Utter A-fishin'-ado Posts: 17,723 From: Cincinnati, Ohio, USA . . . ><((((°> |
Are there any embedded pictures in your forms or reports?
Have you performed a Compact & Repair lately? |
|
|
|
Aug 5 2009, 02:28 PM
Post
#3
|
|
|
New Member Posts: 14 |
The compact and repair did it. For some reason I thought C&R was only for locally stored databases
|
|
|
|
Aug 5 2009, 03:19 PM
Post
#4
|
|
|
Utter A-fishin'-ado Posts: 17,723 From: Cincinnati, Ohio, USA . . . ><((((°> |
You may find this FAQ article of interest.
Glad you got it sorted. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/cool.gif) |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 04:04 AM |