• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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
0
urjudo
Asked:
urjudo
  • 4
  • 2
  • 2
  • +1
3 Solutions
 
COACHMAN99Commented:
did you try a compact and repair?
0
 
PatHartmanCommented:
The database has compile errors.  Fix them to clear up the problems.
0
 
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
PatHartmanCommented:
It opens fine for me if I rename it.  Are you getting an error message?
0
 
Rey Obrero (Capricorn1)Commented:
try this
AFSCME.mdb
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now