asked on

Problem with Database

Hi Experts,
I create a new database (I have a existing one, now we need the same designed beut different data, so I copy the existing one and create a new table, new form & new report), I don't know what I did wrong, all the search button & exit button pop up a error message also if I want to name it to a correct DB name, it will not open. for example, if I name is "AFSCME.mdb, it will not open but if I name "AFSCMEA.mdb then it opens, can some one help? Attach is the DB

Thanks,
AFSCMEA.mdb

SOLUTION

COACHMAN99

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

urjudo

ASKER

ok, thank you, I already compile and clear up, it was the problem that I have was Private Sub Find_Click() twice, I removed it, but I still have one problem that if I rename it, it still will not open. Now I have name it is AFSCMEA.mdb, if I re-name to AFSCME.mdb, it will not opens.

PatHartman

It opens fine for me if I rename it. Are you getting an error message?

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

urjudo

ASKER

I save the one from Rey Obrero and it does the same thing, it's because I save to a flash drive? When I re-name it, I did not get any error message but it just flash that's all, nothing opens

Rey Obrero (Capricorn1)

try saving the db to your desktop and try..

urjudo

ASKER

I save to my desktop, it works, I think there is a problem of the flash drive.

urjudo

ASKER

Thanks guys!!