Prev: Custom Autonumber Incrementation Question
Next: Checkboxes affecting other controls
From: Mikal via AccessMonster.com on 27 Jun 2008 13:30
Good Afternoon,
I have an A2K backend database which suffers fairly frequent corruption (yes,
I do make frequent backups). If I open it in Access 2000 and compact and
repair it the file is repaired and looses a good bit of bulk. However, If I
do the same thing in Access 2003 the repair takes place but the file size
remains unchanged.

Just curious if anybody else has experienced this.

I am Running Access 2003 in WinXP. Access 2000 is via Citrix and for all I
know the OS might be NT 4.0
Thanks,
Mike

--
Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1

From: Allen Browne on 27 Jun 2008 23:36
Especially as you are opening it under different versions here, a decompile
might fix it.

Standard recovery/maintenance steps:
http://allenbrowne.com/recover.html

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

"Mikal via AccessMonster.com" <u16180(a)uwe> wrote in message
news:864f5b00dbda0(a)uwe...
> Good Afternoon,
> I have an A2K backend database which suffers fairly frequent corruption
> (yes,
> I do make frequent backups). If I open it in Access 2000 and compact and
> repair it the file is repaired and looses a good bit of bulk. However, If
> I
> do the same thing in Access 2003 the repair takes place but the file size
> remains unchanged.
>
> Just curious if anybody else has experienced this.
>
> I am Running Access 2003 in WinXP. Access 2000 is via Citrix and for all
> I
> know the OS might be NT 4.0

From: Mikal via AccessMonster.com on 28 Jun 2008 16:11
Allen Browne wrote:
>Especially as you are opening it under different versions here, a decompile
>might fix it.
>
>Standard recovery/maintenance steps:
> http://allenbrowne.com/recover.html


Thank you very much. That looks pretty straight-forward. I'll give it a try
when I get back to work.
Mike

--
Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1

 | 
Pages: 1
Prev: Custom Autonumber Incrementation Question
Next: Checkboxes affecting other controls