Double Database

[Branagan]

hi

i currently have a database. for some reason it decided to make a copy of itself, but if i try to delete it, it removes some of the information in my actual database. eg/ it removes all the stuff from april onwards when i delete the copy of database

help

 

[Mile-O]

i currently have a database. for some reason it decided to make a copy of itself

Were you playing with code to do this? Or are you referring the .ldb file that appears when you open a database?

 

[Branagan]

no, it isn't the temp file that is created when you open your database.

Its the same database but its been renamed "Copy Of Database".

Say the orginal database's data goin back from jan this year all the way till july. in the Copy of the database which has been created mysteriously, it has all the dates goin from jan to april.

when you delete the copy (cos i dont want it) and go back into the original database, all the information up until april is there, but the rest has gone.

when you restore the copy from recycle bin, all the information goes back uptodate in the original one..

could this possibly be the way access works when the database gets to a certain size. it makes a copy automatically just in case you lose all that information.

 

[The_Doc_Man]

could this possibly be the way access works when the database gets to a certain size.

Nope. Doesn't do that.

Restore the copy from the recycle bin. Look at the icons very carefully. If your window is not in DETAIL mode or ICON mode, you aren't looking at enough to answer the next question. When you look at the items in question, do they contain little arrows in them (that would indicate they are shortcuts, not actual databases?) Or in detail mode, does either show itself to be a shortcut?

If so, RIGHT-click on each to find its properties. See if they have the same paths. You might be looking at two different files but all you are doing is looking at an old shortcut.

Now how it would have gotten that way is not a question I can answer.