Expert: Scottgem - 5/25/2006

Question

Win XP Pro
MS Access from Office 2000 [Premium SR-1]

Today I appear to have accidentally created 2 different versions of a database I have been building for years,altho they both versions have exactly the same name:
Music Collection3-2000-ver.mdb.
One is on the Quick Launch Taskbar  [folder] the other is located in My Documents folder.

When I created the one on the Quick Launch Taskbar I assumed it was just a shortcut it,but it really seems to be [the icon for] the app itself & not a shortcut or a copy!
--which is the cause of the xtra database.

Today I added batch #1 of new data to the  Quick Launch Taskbar .mdb &
later entered batch #2  of new data to the My Documents .mdb.
PROBLEM:Each batch only shows up in the database it was entered into!

How can I mesh these 2 versions so I don’t have to re-enter data?
How can there be 2 different versions of a database when both have the same name?

I may just need to restart but I’m hesitant to do anything ‘til I know more
[I have closed both databases & made a restore point after I discovered the problem].


Answer
Sorry hit the wrong button.

Sounds like you made a copy of the file in a different folder. You can have dup file names as long as they are in different folders.

What you can do is copy and paste the records from one version into the other, then delete the other.

HTH
Scott<>