Problem Database

[le888]

Hi,

I don't know want I did, suddenly, all the forms,tables, and query in my database are gone. But when I go to the proprities of my database it still has 49 Mo. Any ideas to restore my database?

Le

 

[KenHigg]

Try:

1. Compact & Repair
2. Un-Hide stuff
2. Import all your stuff into a new db
3. Reboot pc
4. Try it on another pc

??

 

[le888]

Try:

1. Compact & Repair
2. Un-Hide stuff
2. Import all your stuff into a new db
3. Reboot pc
4. Try it on another pc

??

Thanks for your reply, but I see Compact but I didn't see Repair. Where should I go to find repair?

Le

 

[KenHigg]

What version Access do you have?

 

[le888]

What version Access do you have?

Access 2000

 

[Dan_T]

what version are you using? Older versions from memory are options next to each other. New versions do both together. If all contents are deleted the size wont reduce until compaction. Access allocates chunks of storage (16k??) as it needs it but doesn't release it again. Hopefully you haven't lost if but if so theres are harsh lesson for making a back up copy. Good luck

 

[KenHigg]

Thanks for your reply, but I see Compact but I didn't see Repair. Where should I go to find repair?

Le

Did you find it?

 

[le888]

Did you find it?

I have compact my Database, I'am not sure if I done right. Because the memory still at 49 Mo. I try to tranfere all my data, it didn't work.

Thanks for taking care of my problem.

Le

 

[KenHigg]

Q. Say you do a new, blank db. Then do an import and go to your problem db, can you see any of the objects in your problem db?

 

[le888]

Q. Say you do a new, blank db. Then do an import and go to your problem db, can you see any of the objects in your problem db?

That what I did. When I try to import from the problem db, it seem nothing happen.

Le

 

[KenHigg]

1. Can you link to the tables?

2. Did you try it on another pc?

3. I assume 49 mo is the same as 49meg? Can you zip and post it?

 

[le888]

1. Can you link to the tables?

2. Did you try it on another pc?

3. I assume 49 mo is the same as 49meg? Can you zip and post it?

I have try on another PC, it didn't work. When I open database, the database window didn't appear. So, is it possible to reappear this window?

Le

 

[KenHigg]

Did you try holding down the shift key as it opens?

 

[le888]

Did you try holding down the shift key as it opens?

Yet, I did that.

 

[KenHigg]

Did you ever find the repair database command?