Invalid bookmark

[L4serK!LL]

"Invalid bookmark"

Every time I try to open the .mde file of my Access Database, it gives me an 'Invalid Bookmark' error and quits instantly
It worked fine when I left it behind yesterday, is it possible someone wrongly exited the DB?

How did this happen and what should I do about it?

 

[Birdy]

You need to repair and then compact the database. It looks as though the database crashed whilst someone was in it updating a record. You will however lose this one record.

 

[L4serK!LL]

You need to repair and then compact the database. It looks as though the database crashed whilst someone was in it updating a record. You will however lose this one record.

Tried reparing: wasn't able to open the .mdb file itself so I opened MS Access and selected the repair command without a current database loaded, it asked me for an access file and I selected the broken one, but after that it just gave the error message box again (Invalid Bookmark), and when I pressed the OK-button the repair operation stopped...

I can't open the database in any way as far I know, tried opening, importing in another database, ...

 

[Birdy]

Try this nice little tool from Microsoft. It's the Jet Compactor. I have been able to repair and compact databases that had lost their system tables.

 

[L4serK!LL]

Thanks but that didn't work
The tool can apparently only repair .mdb files, no .mde ones...

 

[Birdy]

Is the .mde file connected to a MDB file on a server. If so, you should be compacting the server database not the client. If you only have a .mde file database (A Standalone database as apposed to a client / server database) then there is no way you can repair. Try getting another copy of the .mde file created from the .mdb.

 

[Pat Hartman]

Why don't you just rebuild the .mde?

 

[L4serK!LL]

"Is the .mde file connected to a MDB file on a server."

I just created the MDE file from the Extra menu, there was no option asking me if I wanted it to link to the MDB or not...

"Why don't you just rebuild the .mde?"

The data is the tables, that is kept in the MDE file and not in the MDB file, would be lost then as the MDE form is heavily used to enter data...
Seems all the entered data is lost


I rebuilt the MDE file yesterday evening before leaving the office, and this morning it's corrupt again... I have no idea what people are doing here to get it that far or what I have done wrong, anyway, I have to repiar it again, no "Invalid Bookmark" this time, it immediately asks me to Repair...

 

[Birdy]

The best solution that I can give is that you split the database so all the data tables are kept on the Server. Keep this as an MDB file.

With the NEW front end database (just forms, table links, queries, reports and code) create a MDE file. This way, if your users crash the database again, you just have to repair the server database where the data is and don't have to worry about losing all your data.

 

[L4serK!LL]

I have repaired and put back the MDE file, reloaded the forms on every computer: it seems when loading it on one of those pc's, the database gets corrupt... It's always that 1 computer that causes the problems, the form won't load and the database gets corrupt, how can this be explained?