Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2006

Tip: Looking for answers? Try searching our database.

database won't open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
matthewemiclea@eaton.com - 10 Jun 2006 17:05 GMT
I have built an Access database that is located on a network drive at
my company.  The database is accessed by as many as 7 people at any
given point in time (although there is never really more than 2 or 3 on
it at the same time).

It has been in use for 2 months now with absolutely no problems.
However, today I try to open the file and when I click on the icon, an
Access window opens, but not my database.

I am guessing that there is some corruption issue, but does anyone know
what may have caused this to happen?  Would splitting the database
help? (although I have split databases before and ended up receiving a
lot of complaints because the database slowed down dramatically).

My main concern is:

-  Is the file corrupted?
-  Is there any way to recover this file? (I am checking if there is a
network backup)
-  How does an issue like this arise in the first place?

Thanks in advance for any help,

Matt
tina - 10 Jun 2006 19:23 GMT
if you google on this issue, you'll see that it's been posted many times,
and the answer is always:  split your database.
the issue of a split database running slower has also been raised many
times, and the answer is frequently:  see Tony Toews' Performance FAQs at
http://www.granite.ab.ca/access/performancefaq.htm
as far as the db goes, you might try opening the database directly from
Access rather than from the icon. or try compacting the database without
opening it (try this on a COPY), and then try opening it from Access. if
neither attempt flys, you could try creating a new db, and importing the
tables from the original db - if that works, try importing the rest of the
objects.
if none of the above works, and you don't have a recent, uncorrupted copy of
the db to fall back on, you might try sending a copy of the db to a recovery
service. a few have been recommended in these newsgroups from time to time,
google the groups to see what you come up with.

hth

> I have built an Access database that is located on a network drive at
> my company.  The database is accessed by as many as 7 people at any
[quoted text clipped - 20 lines]
>
> Matt
jahoobob - 22 Jun 2006 21:05 GMT
Even if you haven't kept a copy yourself of the db somewhere, check with your
IT dept and see if there is a "good" copy in the backups.  You can usually
get them to load it somwhere for you to check it out before ovrewriting the
"bad" copy.

>if you google on this issue, you'll see that it's been posted many times,
>and the answer is always:  split your database.
[quoted text clipped - 19 lines]
>>
>> Matt
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.