I was able to put them back fortunately!
Yesterday I was so frantic/insane enough unable to remember that I had some tags to identify certain records. Big chunk of records are now back by those tags. Thank god!
In fact we had our departmental on-line backup, which coincidently was not running for last couple of days due to changing backup nod.
Definitely this experience is now valuable lesson to me, not to rely...
loisk
Last Activity: Oct 21 '08, 10:24 PM
Joined: Sep 21 '07
Location:
-
I forgot to add some info:
I am using MySQL 5.0
Table type is MyISAMLeave a comment:
-
Big mistake: Update command without where clause
Hi,
Can anyone help me to recover or undo this problem?
I did inadvertently run a command, 'update ..set' without where clause and changed every records. Unfortunately our backup didn't run last night.
Is there any way to recover or undo this? Please help me.... -
I just figured it out
I forgot to set up a primary key!
Thanks for reading!Leave a comment:
-
Why bound fields in my form uneditable?
Hi,
I have created a new Access query and form, linked to MySQL table. I have some fields for just displaying info from MySQL, and others (also bound) are to be entered by user. However when I click the field nothing can be editable.
If anyone help me on this problem, I'd appreciate it! -
I will check it out.
Thank you so much to both of you, missinglinq & megalog!...Leave a comment:
-
Hi, Megalog!
Thank you for your reply!
So working on compacted one should be fine? I was worried about if the newly created/compact one could be incompleted/missing something.
Now I guess I have to go back and try to find what is causing the crash....Leave a comment:
-
Access db unexpectedly quit and creates backup.mdb
Hi,
I don't know why my db is unexpectedly quit, but when it does it always creates myfilename.Back up.mdb and myfilename.mdb (i guess it's compacted one. The size of the byte is reduced greatly.)
My question is which one I should open and continue to work on. Is it the myfilenmae.Back up.mdb (still full byte size) or myfilename.mdb (reduced size one)?
Why it is being quit unexpectedly is another problem... -
Please don't misunderstand me. I wasn't trying to ignore your advice. In fact I was trying to follow the way of the link Stewart gave me in the beginning of this post and there were some lines that I couldn't understand. I found similar method to that of Stewart's suggestion in MS Support website, and I took it and modified it. I couldn't find the way to make my fields right-aligned using TransferText function. Let me try both and I will return...Leave a comment:
-
Here's what I found out in case it can help someone else...
My form is linked to two MySQL tables via a query.
I loaded some records only into one of the tables and forgot to do the same thing to the other table which contains DOB info. When loading records is done partially, but not to both table, then Access ignores the data loaded partially.
My problem is solved now after I did load the data to the other table....Leave a comment:
-
Hi Stewart and NeoPa!
Ok, here's my code that I did dig out from MS support, but I was errored of the type mismatch.
All of my fields is number, except one, Caseid, but I made all the number datetypes to string in order to specify the width of the field, it creates an error. My dilema here is that how to reconciliate this conflict in terms of keeping my datatype and creating the fixed-width (and right aligned) text file. ...Leave a comment:
-
Added records not shown in my existing query
I have added more records to my table, but one of my forms or queries is not reflecting this change. However, those records are shown in a query that I created after adding them to the table. Does this mean that I have to create a new form and query each time I add some records? Can anybody help me on why and what is causing this problem? Thanks! -
Thanks, NeoPa!
I tried the above by using manual menu, the export of file menu, but it did not serve my need since I need to make the output columns right-aligned. I have looked into carefully if there's any way that I can manipulate the columns' alignment in generating the specification, but it seems there's no way to get it.
This output text file will be used in SPSS later and it's got to be right-aligned.
...Leave a comment:
-
Thanks, NeoPa!
It's much clearer and I understood. Right now I am struggling with other problem, but I will get back to this post to report if it works for me. Thanks again!...Leave a comment:
-
I don't think that I did answer to NeoPa's question above.
Yes, it's gotta be by code....Leave a comment:
-
Is it Refresh problem?
Hi,
I added more records recently to my MySQL table which shows all the added records. However, one of my access forms (data entry screen) does not show newly added records while other form (filter form) displays those records. I don't understand why this happens.
I did Refresh and also updated the linked tables through linked table manager menu. Any comment will be appreciated! -
Right! My InvDate is a textbox, but you created a new variable, IDate as a textbox. Is it referring to that I should rename my textbox, InvDate, to IDate OR create another unbound textbox?...Leave a comment:
-
Hi, ADezii!
Thanks for your reply!
I have one question here.
Should I create an unbound textbox of 'IDate' or I should replace the 'Invdate' with 'IDate'?...Leave a comment:
-
By the way, Stewart, My Access form is linked to MySQL table via ODBC....Leave a comment:
-
Type mismatch problem
Hi again,
I need to compare two variables of different datatypes, i.e., intvdate is string & strToday is date. The datatype for intvdate is string to avoid any further problem later, and strToday holds the date function. So intvdate shows 04262008 while strToday shows 4/26/2008. Here's my code:
...Code:strToday = Date If CDate(Me.Intvdate) > CDate(strToday) Then MsgBox "Today is
No activity results to display
Leave a comment: