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
urjudoAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this
AFSCME.mdb
0
 
COACHMAN99Connect With a Mentor Commented:
did you try a compact and repair?
0
 
PatHartmanConnect With a Mentor Commented:
The database has compile errors.  Fix them to clear up the problems.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
urjudoAuthor Commented:
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.
0
 
PatHartmanCommented:
It opens fine for me if I rename it.  Are you getting an error message?
0
 
urjudoAuthor Commented:
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
0
 
Rey Obrero (Capricorn1)Commented:
try saving the db to your desktop and try..
0
 
urjudoAuthor Commented:
I save to my desktop, it works,  I think there is a problem of the flash drive.
0
 
urjudoAuthor Commented:
Thanks guys!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.