If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
lost the data on changing the field type from text to date/time
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 |
#2
|
|||
|
|||
lost the data on changing the field type from text to date/time
"sam" wrote in message
... 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) |
#3
|
|||
|
|||
lost the data on changing the field type from text to date/time
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" wrote in message ... 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 |
#4
|
|||
|
|||
lost the data on changing the field type from text to date/tim
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" wrote in message ... 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) |
#5
|
|||
|
|||
lost the data on changing the field type from text to date/tim
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" wrote in message ... 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 |
#6
|
|||
|
|||
lost the data on changing the field type from text to date/tim
"sam" wrote in message
... 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) |
#7
|
|||
|
|||
lost the data on changing the field type from text to date/tim
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 |
#8
|
|||
|
|||
lost the data on changing the field type from text to date/tim
=?Utf-8?B?c2Ft?= wrote in
: 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/ |
Thread Tools | |
Display Modes | |
|
|