Go in Designer
Manage a Database
Manage Fields
Delete Database

Bharat, if Justin has 2 db's with the same name wouldn't using Manage Db, Delete Db delete all db's by that name.

As I presume he wants to keep one db with that name he may need to do it through Windows explorer or my computer to select only one of the db's files to delete.

Becky,

We are talking about database, not application. Application will be listed as the *.db file in the windows explorer, while database is represented in the command tree as a folder. If you have two applications with the same name in the same folder, one will overwrite the other, I believe here we are referring databases in an application. I hope justin will clarify.

Well I managed to figure out how to remove the duplicate database.

I first of all made a backup of the application. I then went into the database manager for the duplicate database and tried using the delete database option, unfortunately it deleted both.

I restored the backup and gave it another try. I went into the database manager on the parent database. I noticed there was 2 subform databases (even though i'd already deleted the 2nd subform layout element. These subform elements were uniquely named (Note & Note2). I then selected the delete field option selected the Note2 field and then ran the batch. This deleted the 2nd database - As a warning to all those in the future - be careful not to let yourself get duplicate databases - its a real headache.

To the lantica staff I suggest adding some sort of checking to make sure something like this doesn't happen There should not be duplicate database names allowed.

I'm just glad its resolved and I hope no one else gets this problem.

That could be possible I can't remember exactly how I created it I remember creating 2 subforms one using relational links and one using natural links but I can't remember how I created the duplicate. I might have tied it to two different layouts for the same database mistaking them for two different databases.