Solved

Problem with Database

Posted on 2014-04-09
9
227 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 34

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
 
LVL 34

Expert Comment

by:PatHartman
ID: 39989919
It opens fine for me if I rename it.  Are you getting an error message?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 119

Accepted Solution

by:
Rey Obrero 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 119

Expert Comment

by:Rey Obrero
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now