|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hello, Monsters!
I've been working with two coworkers on a small Access database for a few
weeks now, but all of a sudden one of the main tables is simply no longer
there. No one has deleted it (as far as we have been able to determine), but
it's simply not there anymore. If anyone has any suggestions that might help
get back a table that has gone missing, I would be very glad to hear it!
Seaton
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200609/1
|
|
As far as I know there is only one way you can get it back. You can import
the table from your back-up file. All good Access db users back-up right? To
import the table from your back-up to the version you are working on go to
File, Get External Data, Import. When the window pops up select your back-up
copy then select the table tab, select the table to import and select ok;)
--
Thanks,
Dennis
"seaton via AccessMonster.com" wrote:
[Quoted Text] > Hello, Monsters! > > I've been working with two coworkers on a small Access database for a few > weeks now, but all of a sudden one of the main tables is simply no longer > there. No one has deleted it (as far as we have been able to determine), but > it's simply not there anymore. If anyone has any suggestions that might help > get back a table that has gone missing, I would be very glad to hear it! > > Seaton > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200609/1> > |
|
Seaton,
Could the table be hidden? Go to Tools -> Options -> menu and then
check the hidden objects option on the View tab. If the table's attributes
have been changed to "hidden", it will now show with the icon in a faded
style.
--
Davina Lightner
"seaton via AccessMonster.com" wrote:
[Quoted Text] > Hello, Monsters! > > I've been working with two coworkers on a small Access database for a few > weeks now, but all of a sudden one of the main tables is simply no longer > there. No one has deleted it (as far as we have been able to determine), but > it's simply not there anymore. If anyone has any suggestions that might help > get back a table that has gone missing, I would be very glad to hear it! > > Seaton > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200609/1> > |
|
Don wrote:
[Quoted Text] >As far as I know there is only one way you can get it back. You can import
>the table from your back-up file. All good Access db users back-up right? To
>import the table from your back-up to the version you are working on go to
>File, Get External Data, Import. When the window pops up select your back-up
>copy then select the table tab, select the table to import and select ok;)
Thank you for the response, Don.
Actually, we ended up reverting to a backup of the entire database from the
previous day. Unfortunately, some of the most recent data was lost, but
because the table that went missing was *the* most critical one in the
database, I don't think that could be helped.
Thanks again for the response. I greatly appreciate it!
--
Message posted via http://www.accessmonster.com
|
|
Davina wrote:
[Quoted Text] >Seaton,
>
> Could the table be hidden? Go to Tools -> Options -> menu and then
>check the hidden objects option on the View tab. If the table's attributes
>have been changed to "hidden", it will now show with the icon in a faded
>style.
Thank you for the response, Davina!
No, I don't think the table was hidden, because everything that was based on
that table (queries, forms, reports, etc.) completely stopped working after
it disappeared. That wouldn't happen if the table were merely hidden, would
it?
--
Message posted via http://www.accessmonster.com
|
|
|