Compact & Repair

[Dave]

My database is over 2mb big and I have been trying to move it to a floppy.
I thought if i compact and repair it would reduce to the size I need.
However when I use Compact & Repair it states the following:

Table "TempMSysAccessObjects" already exists

When I search for the file it cannot be found. Sound advice would be
greatly appreciated. Many thanks

Dave

 

[Kripesh Chandran]

Hi Dave,

MSysAccessObjects is a system table and is usually
hidden. to view system objects go to Tools
menu>options>view tab and check "system objects" option.

when runing compact and repair, access creates
TempMSysAccessObjects table. rename or delete
TempMSysAccessObjects table and run compact and repair
and repair again. I will run successfully. All the best!

 

[Kevin @ 3NF]

http://support.microsoft.com/?kbid=818099

Hope that helps (Thanks Tony Toews)

 

[Van T. Dinh]

See if the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=818099

helps.

BTW, I gave up copying Access database onto floppy disk a long time ago. If
you want to copy the database onto another computer and got no other methods
to transfer, use WinZip or similar as:

1. mdb files are usually zipped nicely down to about 50% of the normal
size. Make sure you compact the database before zipping.

2. You can create a WinZip archive which can span over multiple floppy
disks.

Suggest you find a faster method in the future (e.g. network, flash
hard-drive, CD- ROM, etc ...)

 

[Dave]

Thank you works a treat!!

Hi Dave,

MSysAccessObjects is a system table and is usually
hidden. to view system objects go to Tools
menu>options>view tab and check "system objects" option.

when runing compact and repair, access creates
TempMSysAccessObjects table. rename or delete
TempMSysAccessObjects table and run compact and repair
and repair again. I will run successfully. All the best!

 

[Tony Toews]

BTW, I gave up copying Access database onto floppy disk a long time ago.

I gave up using floppies as soon as I purchased my first CDR burner
for $600. Before that I always took two copies of my MDBs on seperate
floppies. Three times out of twenty the first copy was bad.
Fortunately the second copy was just fine.

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