Solved

Problem with Database

Posted on 2014-04-09
9
230 Views
Last Modified: 2014-04-09
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
Comment
Question by:urjudo
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 7

Assisted Solution

by:COACHMAN99
COACHMAN99 earned 166 total points
ID: 39989810
did you try a compact and repair?
0
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 167 total points
ID: 39989818
The database has compile errors.  Fix them to clear up the problems.
0
 

Author Comment

by:urjudo
ID: 39989901
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 35

Expert Comment

by:PatHartman
ID: 39989919
It opens fine for me if I rename it.  Are you getting an error message?
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 167 total points
ID: 39989927
try this
AFSCME.mdb
0
 

Author Comment

by:urjudo
ID: 39989961
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39989971
try saving the db to your desktop and try..
0
 

Author Comment

by:urjudo
ID: 39990073
I save to my desktop, it works,  I think there is a problem of the flash drive.
0
 

Author Closing Comment

by:urjudo
ID: 39990075
Thanks guys!!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question