Hi All,

I changed a text field in access 2007 database to a date field and lost all
the data in the column, Is there a way to get that data back?

I tried changing it back to text and reopened the database, but still dont
see the data

Thanks in advance

"sam" <(E-Mail Removed)> wrote in message
news:84A20C82-042B-44EE-B3F1-(E-Mail Removed)...
> Hi All,
>
> I changed a text field in access 2007 database to a date field and lost
> all
> the data in the column, Is there a way to get that data back?


Only from your backup. I'm sorry.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Unfortunately, I believe you've lost the data. Hope you had a recent backup!

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sam" <(E-Mail Removed)> wrote in message
news:84A20C82-042B-44EE-B3F1-(E-Mail Removed)...
> Hi All,
>
> I changed a text field in access 2007 database to a date field and lost
> all
> the data in the column, Is there a way to get that data back?
>
> I tried changing it back to text and reopened the database, but still dont
> see the data
>
> Thanks in advance

I didnt have a backup.. But I guess I will have to input all the data
manually. Luckily there wasnt much data but It will get big as time goes.

Is there a way I can auto backup my database every night?

Thanks in advance

"Dirk Goldgar" wrote:

> "sam" <(E-Mail Removed)> wrote in message
> news:84A20C82-042B-44EE-B3F1-(E-Mail Removed)...
> > Hi All,
> >
> > I changed a text field in access 2007 database to a date field and lost
> > all
> > the data in the column, Is there a way to get that data back?
>
>
> Only from your backup. I'm sorry.
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>

I didnt have a backup.. I guess I will have to input all the data manually.
Luckily there wasnt much data but It will get big as time goes.

Is there a way I can auto backup my database every night?

Thanks in advance


"Douglas J. Steele" wrote:

> Unfortunately, I believe you've lost the data. Hope you had a recent backup!
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "sam" <(E-Mail Removed)> wrote in message
> news:84A20C82-042B-44EE-B3F1-(E-Mail Removed)...
> > Hi All,
> >
> > I changed a text field in access 2007 database to a date field and lost
> > all
> > the data in the column, Is there a way to get that data back?
> >
> > I tried changing it back to text and reopened the database, but still dont
> > see the data
> >
> > Thanks in advance
>
>
>

"sam" <(E-Mail Removed)> wrote in message
news:C07FB56F-FA7E-47F0-8F67-(E-Mail Removed)...
>I didnt have a backup.. But I guess I will have to input all the data
> manually. Luckily there wasnt much data but It will get big as time goes.

Bummer, but these things happen.

> Is there a way I can auto backup my database every night?

That depends. Is your database normally closed at night -- no users in it?
Is it a multi-user database, or is it just you who uses it?

If the database is closed at night, you can presumably schedule a system
task to copy the database file and make a backup copy. That copy would
probably not be valid if there were somebody in the database when it ran
(though it would still be better than nothing).

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Sam,

FWIW, I put a button on my custom toolbar that when you click it,
backs up the database. Database backup is one of the standard items
and not a macro or anything extra. (Only one person at a time is ever
using the db, so that may not work for you if you have many users at
the same time.)

You can even put a reminder on the Startup Form or even one that pops
up periodically as the database is being used. "Back Me Up!"


HTH

VR/Lost

=?Utf-8?B?c2Ft?= <(E-Mail Removed)> wrote in
news:9239A015-984D-415A-8335-(E-Mail Removed):

> Is there a way I can auto backup my database every night?

The same way you're backing up all your other data.

If you're not, then your data must be completely worthless.

Or you're not too swift.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/