HI,

When i try to compact  my database , in Access 97, it
gives me a message  :

==> record(s) can't be read; no read permission on
    c:\work\NIF.mdb 

???

it does not compact.

Can someone helps me ???

Thanks..

J. CARLIER
Brussels
BElgium

> HI,

> When i try to compact  my database , in Access 97, it
g> ives me a message  :

> ==> record(s) can't be read; no read permission on
 >    c:\work\NIF.mdb 

> ???

> it does not compact.

> Can someone helps me ???

> Thanks..

> J. CARLIER
B> russels
B> Elgium


In fact , it compacts but the new mdb compacted has a another
name ==>  bd1.mdb

J. CARLIER 

Are you using NT?
If you are have you got administrator rights?
If not do you have permission to delete and rename the database? 
Unless you have delete and rename rights to your database, Access will be 
unable to delete  NIF.mdb  and rename db1.mdb to NIF.mdb  as it does 
during compact procedure. If you try to compact it the second time you 
will get db2.mdb and so on...

Is the database read only?
Right-click on NIF.mdb, select Properties.  In General check if Read Only 
attribute is checked (uncheck if it is).  

Hope this helps.

____________________________________________________

John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________

The doors we open and close each day decide the lives we live
____________________________________________________

CONFIDENTIALITY & PRIVILEGE NOTICE
The information contained in this email message is intended for the named 
addressee only.  If you are not the intended recipient you must not copy, 
distribute, take any action reliant on, or disclose any details of the 
information in this email to any other person or organisation.  If you 
have received this email in error please notify us immediately.

>>> jacques.carlier@c... 24/04/2002 1:49:08 >>>
> HI,

> When i try to compact  my database , in Access 97, it
g> ives me a message  :

> =3D=3D> record(s) can't be read; no read permission on
 >    c:\work\NIF.mdb

> ???

> it does not compact.

> Can someone helps me ???

> Thanks..

> J. CARLIER
B> russels
B> Elgium


In fact , it compacts but the new mdb compacted has a another
name =3D=3D>  bd1.mdb

J. CARLIER

This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.