Access doubled in size by putting in sharing folder

[robirdman]

My database ballooned from about 50 meg to over 100 after putting it in the sharing folder on my Toshiba. Now that I put it on my IBM laptop, I would like to restore it to its former size, but don't know how.

Also, as it is impossible for me to now print 1/2" long labels for my slides, everytime I want to do so, I have to copy the whole database and put it back on the toshibas W98 computer where it is possible. When I copied to a CDW the first time it was OK, but read only, even after copying it to the Toshiba. Can this be undone?

The 2nd time I tried to copy it on the CDW, overwriting the original, and the result is unopenable on either computer. To proceed, I had to copy it to a new name. Is this necessary with CDW? I thought you could keep updating files.

 

[Tom Wickerath]

I would like to restore it to its former size, but don't know how.

Try compacting the database: Tools > Database Utilities > Compact and Repair...

When I copied to a CDW the first time it was OK, but read only, even after copying it to

the Toshiba.

Use Windows Explorer and browse to the folder that contains the .mdb file. Right-click on
the file. Left-click on Properties on the short-cut menu. Remove the Read Only file
attribute.

The 2nd time I tried to copy it on the CDW, overwriting the original, and the result is

unopenable on either computer.
You probably did not get a good transfer to the CDW. Some bit or byte of information was
not written correctly, or your CD-ROM cannot read the information correctly. This can be
a problem with CDW discs. When information is "burned" to a disk, it is stored in binary
format (a series of ones and zeros). A pit is burned into the surface to represent one of
the numbers, and no pit represents the other number. I'm not sure which is which, but I
have seen SEM (scanning electron microscope) images of a cross-section. The reason CDW
discs are re-writable is that the pits are not burned very deep at all. As a result, they
can sometimes be difficult for a CD-ROM drive to read correctly. My advise is to forget
about CDW and just purchase normal CD discs in bulk. For about $0.15 each, you can get a
much better burn, although the disk is one-time-use only.

________________________________


My database ballooned from about 50 meg to over 100 after putting it in the sharing folder
on my Toshiba. Now that I put it on my IBM laptop, I would like to restore it to its
former size, but don't know how.

Also, as it is impossible for me to now print 1/2" long labels for my slides, everytime I
want to do so, I have to copy the whole database and put it back on the toshibas W98
computer where it is possible. When I copied to a CDW the first time it was OK, but read
only, even after copying it to the Toshiba. Can this be undone?

The 2nd time I tried to copy it on the CDW, overwriting the original, and the result is
unopenable on either computer. To proceed, I had to copy it to a new name. Is this
necessary with CDW? I thought you could keep updating files.

 

[robirdman]

Thanks very much for the reply. I was unable to find the reply, as I didn't know how to search for my posts till now
Compacting the database did not halve the size to what it was before the sharing. It took off about 3 megabytes only

The read-only problem answer was simple and very effective. Unfortunately it has created a new problem. Now I can't look at that database from another computer. (I just set up my LAN) as it says it is not locked. All I want to do is be able to have the same database on 2 computers and be able to back-up either to the other, but because of permissions and such I keep running into all kinds of problems

 

[Tom Wickerath]

So, you're saying that your database started at 50 MB, grew to over 100 MB "after putting
it in the sharing folder" on your Toshiba, and now a compact and repair operation has only
cut it down to the 97 MB range? Did you import a lot of pictures, or other binary files
(Word docs, etc.) into an OLE datatype field?

Try creating a brand new database. Then import each group of objects (ie. tables,
queries, forms, reports, macros, DAP's and modules) one object group at a time. Set the
references in the new database to match the references in the bloated database. To check
the references, open any module (ALT+F11) and then click on Tools > References... What
size is your new database after importing all objects?


_______________________________________


Thanks very much for the reply. I was unable to find the reply, as I didn't know how to
search for my posts till now.
Compacting the database did not halve the size to what it was before the sharing. It took
off about 3 megabytes only.

The read-only problem answer was simple and very effective. Unfortunately it has created a
new problem. Now I can't look at that database from another computer. (I just set up my
LAN) as it says it is not locked. All I want to do is be able to have the same database
on 2 computers and be able to back-up either to the other, but because of permissions and
such I keep running into all kinds of problems.