Re: DB Front End is extremely large !

SaveAsText/LoadFromText is undocumented, but the arguments are
straightforward. You just specify the type of object, its name, and the name
of the file.

You can use this programmatically, e.g. looping through the AllForms
collection. I'm not sure, but if memory serves correctly, this backup wizard
by Terry Kreft uses this technique:
http://www.mvps.org/access/modules/mdl0045.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SodaJim" <SodaJim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:16C9276B-E6CF-4AAD-93FE-ACF105A43C3A@xxxxxxxxxxxxxxxx
Hello again,

Where can I find info on SaveAsText/LoadFromText...?

I attempted to export everything as txt files but this didn't work well as
some fields had problems... Not to mention how time consuming this
technique
is since I had to export each object at a time...

I wish I knew what MSysAccessObjects table stored, why soo many records,
at
least in this case, and why I cannot delete any of the records in an
attempt
to minimize file size...

Thanks again,
Jim

"Allen Browne" wrote:

Jim, I don't really know what MSysAccessObjects does. It's a system table
with long binary data, and seems to relate to replication. 2614 seems
high.

An alternative approach might be to use the undocumented SaveAsText and
LoadFromText to rebuild the database, and see if that shrinks the number
of
entries in this table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SodaJim" <SodaJim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7CA30CC9-EB38-4765-BA66-E76A90B35317@xxxxxxxxxxxxxxxx
Thanks for quick response Allen!

I followed your instructions only to have the DB size reduced to 10
megs...

Here's a few details for analyzing:
3 tables:
tbl1 - 61 records
tbl2 - 19 records
tbl3 - 17 records
8 queries
5 forms with no images
2 reports

MSysAccessObjects - 2614 records
MSysACEs - 112 records
MSysObjects - 38 records
MSysQueries - 144 records
MSysRelationships - 1 record

This still seems like a very large foot print, 10 megs, for this DB...?

Any thing else I should be looking at or is this the nature of the
beast...?

Thanks again for your suggestions!
Jim

"Allen Browne" wrote:

Try this sequence:

1. Create a new database.

2. Turn off the Name AutoCorrect check boxes under:
Tools | Options | General.

3. Import (File | Get External | Import) the tables, or link them
(File |
Get External | Link) if the database is split.

4. Import the other objects (queries, forms, reports, macros,
modules.)

5. Set minimal References under Tools | References (from the code
window).
If you are not sure what references you need for your version of
Access,
see:
http://allenbrowne.com/ser-38.html

6. Compile (Debug menu, from the code window).

7. Compact:
Tools | Database Utilities | Compact

The other thing that can make the front end large is any graphics you
have
imported into your forms or reports, or stored in an OLE Object field
in
a
table.





.

Relevant Pages

  • Re: DAO 3.6 to 3.51 new error..
    ... Compact the database to get rid of any temp stuff: ... and choose References on the Tools menu. ... > Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: Renaming control breaks module ?
    ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: cant save changes in design view (form)
    ... Step 3 (sorting out references) should work whether any code is actually shown in the code window or not. ... Allen Browne - Microsoft MVP. ... > compile the database, ...
    (microsoft.public.access.queries)
  • Re: #Name? Error... trying to link two fields in same form
    ... SaveAsText/LoadFromText could achieve the same ... Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... > I ended up taking another copy of the original database and pasted my ...
    (comp.databases.ms-access)
  • Re: Selecting Database
    ... When the user selects the folder they wish to check for pdf's, ... additional references. ... Allen Browne - Microsoft MVP. ... I would like to be able to select a database using explorer and then be ...
    (microsoft.public.access.modulesdaovba)