Hello everyone,
I'm running a Make-Table Query in Access. They was working fine up intill an hour ago and suddenly now that I'm running the query , I keep getting this error message:
Can not open Database 'Query 1'. This may not be a database that your application recognizes, or the file maybe corrupted.
And if I close access and reopen it , sometimes it works fine then but sometime it gives error again.
Please advise
6  13947  patjones 931
Recognized Expert Contributor
I would take a cue from the error message and first consider corruption as a possibility.
A simple remedy for this is to open a new (blank) Access database, import all of your objects (forms, reports, queries, etc.) into this new database, and see if the problem still persists. If it does, then at least you can eliminate corruption as a possibility.
Pat
How can I export all the forms, tables, queries and reports all together?
I exported that problematic query to blank database as you said, and it worked perfectly fine. Thanks
But I still don't know how to export ALL of my objects in one shot.
Please advise,
patjones 931
Recognized Expert Contributor
In the new file, you'll do External Data > Import... if you are using Access 2007. Earlier versions of Access have a menu option somewhere for bringing external data or objects into the current file.
Anyway, a dialog will come up allowing you to navigate to the old file and select it. When you do, you'll just select everything in the list that comes up and import it all. If it is a corruption issue, which does happen from time to time with Access, this should fix it.
Pat
You're awesome, I did imported all the objects, and it's working perfectly fine now.
Thanks a lot for you fast help.
NeoPa 32,569
Recognized Expert Moderator MVP
Just as a caveat, although most of a database is held within its importable objects, there are values (of greater or lesser importance depending on your views) which are not associated with these items which will not be replicated with this procedure. It is often not very important in my experience, but can be sometimes.
As another alternative (generally worth trying first and only proceeding on to the multi-object import if you don't find that it solves your problems), you can choose to do a Compact and Repair from your Tools / Database Utilities menu.
It is always worth keeping copious backups when working in Access to give you options to revert to a known working status for any object that may be corrupted beyond repairing or importing.
Good luck.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ralph Noble |
last post by:
Any advice from the crowd? Every time I try to run "Copy Database
Wizard" I get an error message saying I must be a member of the
sysadmin group and have permission to copy files over the network. I'm
a local admin on both boxes and a member of the sysadmin group on both
SQL servers and an admin on the network. What am I missing here?
Thanks,
Ralph Noble
ralph_noble@hotmail.com
|
by: ANSWER |
last post by:
Hi,
I have Win 2000 Pro with service pack 4 and Access 2003. I stoll get the
message when I try to open database:
This file may not be safe if it contains code that was intended to harm your
computer,
Do you want to open this file or cancel the operation?
Instructions in the help don't work, does anybody knows how can I disable
|
by: Ray |
last post by:
I am running a database on a file server from a pc operating Windows XP Pro.
MS Office 2003 is used. When I open the database, below error message
appears.
The expression On Click you entered as the event property setting produced
the following error: A problem occurred while Microsoft Office Access was
communicating with the OLE server or ActiveX Control.
It happens on certain pcs only, not all pcs. Some work perfectly well. Any...
|
by: Holly Cross |
last post by:
I have a report that uses several subreports. The report looks fine in print
preview, but when I send it to the printer, I keep getting this message
"Cannot open any more databases." This happened when I add the last
subreport. Is there a limit on the amount of subreports
you can call from a report? If so, any work-arounds? There is a little code
behind the report, but nothing using recordsets.
|
by: robertmeyer1 |
last post by:
Hey I'm gettitng the following error message: Too Many Fields Defined. But I only have 6 fields in the query. I created a query based off of 2 others which are in turn based off 2 others. I spereated them out so that I oculd avoid this message. Now that I'm finally at the end and about to be done, I get this error. Any help/sugegstions? (the errors pops up noo matter how I change the join propz)
| | |
by: Bob |
last post by:
Hi all,
I've created a database at work and have copied it to home but have
had some problems when I try to open the main form. The error when I
run it is:
Compile error: Can't find project or library
This error comes up then it highlights the 'date' function in the
following line of code:
|
by: Tim Streater |
last post by:
I have this script of a few lines, which runs as expected when I do it
from the command line. It does one select followed by one insert on an
SQLite database. The db in question has permissions guo+rwx.
If I run it as a web page (this is under OS X Leopard), the select works
but the insert fails with this exception:
SQLSTATE: General error: 14 unable to open database file
Any reason PHP cannot write to a file from apache?
|
by: Manikrag |
last post by:
Hi Team,
I have copied one ASP.NET application on a new server and configured it all.Now I am getting below error when I am trying to authenticate users thru LdapAuthentication function. This function is authenticating user and thn reading data from datbase server. DOMAIN\WEBSERVER$' is nowhere in the picture but still I am not able to read the database.
Here is the error.
__________________________________________________________________...
|
by: student2 |
last post by:
Hi :-)
I've designed a query that gathers its information for two tables:-
1)Author and
2) Category
My selection criteria for this query is Author.AuthorName and
Category.CategoryName .
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
