Compact Question

[BW]

I have an access database that is scheduled to compact on close.....I didn't
realize it but the compact was not executing correctly and I have several
db1, db2, db3 files in the directory that holds the database. I was able
to get the database today by compact properly but I'm missing some data from
it now. When I try to open up the dbX databases a get a permissions error.
Is there a way to view what data is in those files? Any help is
appreciated.

BW

 

[aaron.kempf]

Compact and Repair is no longer the reccomended way of working with
Microsoft Access.

If you upsized to SQL Server; you would never have to deal with this
mess.

Thanks

-Aaron

 

[BW]

Ok. but this doesn't answer my question.


Brent
Compact and Repair is no longer the reccomended way of working with
Microsoft Access.

If you upsized to SQL Server; you would never have to deal with this
mess.

Thanks

-Aaron

 

[vbasean]

I'm no expert but what is the exact error you get when trying to open
the dbx files?

 

[Jerry Whittle]

Ignore aaron.

Probably the reason why you have all the DB1, etc. files plus the
permissions problem is that you don't have the proper permissions for the
folder holding the database files. You need read, write, create, and delete
or modify permissions for both the .mdb files AND the entire folder.

You could try copying one of the db1 files to somewhere that you do have
permissions to see if it will open there.

BTW: I always recommend turning off compact on close. Things can go wrong
and you'll not notice until too late. Plus it doesn't really do any good.
Instead compact and repair about once a month using something like the
JetComp tool available from Microsoft. If forces you to make a backup before
compacting the database in case something goes wrong.

 

[BW]

Ok....I'll modify the settings and try....


Thanks
BW

 

[aaron.kempf]

I disagree.

you need to waste your time on compact and repair-- like you need
(something that you don't need)

You're spinning your wheels.

SQL Server compacts for you-- automagically

thanks

-Aaron