Thank you so much, Albert, that was so nice of you. I will definitely keep watching this Forum, even though I haven’t a clue what much of the discourse means.
I love the idea of “passing it along”, so I will concentrate on not focusing on myself so much and seeing what I can do to help some other people. Cathy From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Tuesday, January 02, 2018 9:05 AM To: [email protected] Subject: Re: [RBASE-L] - One last question, if possible Cathy, It is often the case that those lurking on the server (including me) will learn something from another’s question and answer session. Never even think of hesitating to post a question. We are very fortunate to have this most helpful site provided by RBTI. Some of us learned virtually everything we know from this site and its predecessors — dating back to 1984 in my case. I, among many others here, consider it our sworn duty to pass on any knowledge we may have to newcomers. It is pay back time for us. Albert On Jan 2, 2018, at 5:24 AM, Cathy Grimes <[email protected] <mailto:[email protected]> > wrote: Thanks, Steve. I did disconnect before packing (mainly because I’ve not disconnected before and given that error). Re your SECOND part…. THANK YOU! THANK YOU! THANK YOU! YOU’RE RIGHT!! My Desktop shortcut to Explorer (to copy files) goes to C:\RBTI\RBG76\DATA and that was the directory that I used to connect to my databases before my computer crashed and I had to purchase upgrade to re-install to my new computer. IT NEVER OCCURRED TO ME that I forgot to change my desktop shortcut to the NEW directory. C:\RBTI\RBG95_32\DATA. AND THERE my DATABASES WERE in Explorer under the RBG95-32 directory … WITH THE CHANGES in Date Modified, Date last Saved, size correctly modified! So I have been backing up the WRONG FILES ALL THIS TIME! I am correcting this immediately. I would have been devastated to learn that NONE of my back-ups were backing up ANY of my changes. I can’t thank you, Razzak, and the others here enough who have taken your time to help me. I really appreciate it.. it means a lot to me. I just recovered from a year’s treatments for throat cancer, and my body is still adjusting to getting ‘back to normal’. So my working on my database I’ve been updating for decades now really helps keep me feeling more “normal”. I am just so sorry that my knowledge is so minimal that I can’t participate in helping others here. Cathy From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Steve Johnson Sent: Monday, January 01, 2018 4:29 PM To: [email protected] <mailto:[email protected]> Subject: RE: [RBASE-L] - One last question, if possible Cathy, Perhaps you may have figured this out, but Larry left out re-connecting the database after setting multi off. Pack will not take place with database disconnected. #3 - R> Disconnect #4 - R> Set Multi Off #4a R> Connect DBname #5 - R> Pack #6 - R> Dir *.RB? Remember to disconnect after packing and set Multi On: Disconnect Set Multi On Connect DBname I am somewhat suspicious that you are seeing a duplicate but original files lurking in your machine, but the program is accessing same files in a different folder or even subfolder. You might try starting your application, exit to DB Explorer and check what database and path is shown at the bottom left for Current Folder. Your other option would be, assuming you have a desktop icon for your application, would be to right click on the application icon and click on properties. The database path will be indicated in the Start In box. Steve From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Cathy Grimes Sent: Monday, January 01, 2018 6:23 AM To: <mailto:[email protected]> [email protected] Subject: RE: [RBASE-L] - One last question, if possible Thanks so much, Larry. That was interesting to check, and does give me comfort to feel I have some control over solving a problem. I love finding out new things about a program’s problem that I can understand. I performed your tasks below. Unfortunately, the ‘time’ only showed a 3 min difference in r:base between the time I listed the database there and the time I packed, then rechecked. But the pack result DID show row changes in Forms, Sys Reports, Categ, Videos, Ratev, couple more… total changes of maybe 230 or so. The file sizes of .rb2, rb3 and .rb4 DID REDUCE in size. However, when I exited to re-copy the new packed database, Explorer still shows the same dates and file sizes as were in all previous several months. So those results at least tells me that R:Base IS making changes and, since I haven’t noticed any data loss so far, I’m hoping that means it’s just a glitch in either Explorer or Windows, etc. Thanks again for your help and Happy New Year. Cathy From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Larry Wilson Sent: Sunday, December 31, 2017 2:06 PM To: <mailto:[email protected]> [email protected] Subject: Re: [RBASE-L] - One last question, if possible Cathy, IF you really want to confirm date, time and file size changes here is a sure method. Make certain that you have a current backup of your database. #1 - exit to the R> prompt #2 - R> dir *.RB? make not fo the date. time and file sizes #3 - R> Disconnect #4 - R> Set Multi Off #5 - R> Pack #6 - R> Dir *.RB? make note of the date, time and file sizes - they should have changed Reconnect to your database Hope this helps and gives you comfort. Larry Larry Wilson President & CEO Promesa Consulting Group, Inc. 1727 N Street NW, Suite 400 Washington, DC 20036 202-808-8836 (O) 202-733-7006 (C) 202-808-8837 (F) On Sun, Dec 31, 2017 at 12:52 PM, Cathy Grimes < <mailto:[email protected]> [email protected]> wrote: Thank you, Albert. The date and time does not change no matter what I do, or when I make any changes. The file sizes not changing is what concerns me most. I have not been creating new databases or tables, but regularly edit the data and create and/or edit reports….but still no file size change (or date change) at all. Hopefully, since I don’t seem to be losing my changed data, the static file sizes are not affecting the integrity of the database. But it would really ease my mind if I could find out how to fix it. Cathy From: <mailto:[email protected]> [email protected] [mailto: <mailto:[email protected]> [email protected]] On Behalf Of Albert Berry Sent: Sunday, December 31, 2017 9:33 AM To: <mailto:[email protected]> [email protected] Subject: Re: [RBASE-L] - One last question, if possible The date/time is last connection time, not the time you disconnected, I think. I don’t think you need to change the dates. When you disconnect and reconnect, the date/time will be updated to the time of connection. File sizes, on the other hand, should change as you manipulate the data and the database files are saved. Albert On Dec 31, 2017, at 9:20 AM, Cathy Grimes < <mailto:[email protected]> [email protected]> wrote: Thank you, Buddy, for taking the time to respond. I am the only user so no one else in the database ever. I’m not sure what you mean by R:Base possibly considering the database as being out of sync, but I’ve had no problems accessing the database, making changes, etc., then having the changes (ones I’ve checked) still there after I’ve exited, updated the dates, then re-accessed. I do check my back-up drive periodically to make sure that all 4 of the data files are copied after I’ve forced a date change. Because I do manually update the dates and copy the files every couple of days, that should accomplish the same end result as your schedule task suggestion – it just takes me a few seconds each time (even if it is annoying to have to do this). That is a good thing, because I would have no idea how to create a schedule task. My tech guy set up Acronic True Image in the separate back-up hard drive, and I have periodically have problems with that working properly. I guess I just wanted to be assured that my database is still ok with my manual updating, especially since the file sizes do not change at all when I update them. Cathy From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Buddy Walker Sent: Sunday, December 31, 2017 7:56 AM To: <mailto:[email protected]> [email protected] Subject: RE: [RBASE-L] - One last question, if possible Cathy I believe the date will change when everyone is disconnected from the database. Also I would be careful about forcing a new date because R:Base may see this as the database being out of SYNC. The auto backup looking at dates may not backup up all 4 database rx files. I would suggest using something like a schedule task that would start R:Base and then copy all 4 files to a backup area. I did this in the past. I would copy the database files at noon (limited activity) and then at 5:00pm and then the normal daily backup at 11:00pm Buddy From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Cathy Grimes Sent: Sunday, December 31, 2017 10:10 AM To: <mailto:[email protected]> [email protected] Subject: [RBASE-L] - One last question, if possible I hope it’s ok if I ask one more question that has been driving me crazy (as an end user, also the buyer of R:Base). I was so happy to have my only other main R:Base problem fixed by Razzak so quickly and easily. When I last upgraded to R:Base Extreme 9.5(32), the file Attributes suddenly stopped changing, i.e., the date modified never changes, and RB1 through RB4 never changes size (no matter how many rows I add or changes I make). Because I have auto back-up drive that backs up changes only, it will not back-up my R:Base data files unless I do it manually. I found a program that will automatically update the date changes to current (if I mark and select those each time), but it does NOT change the size of any of the RB1 through RB4 files. My data always seems to be there, but I’m worried that the file sizes are static. Thank you. Cathy -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
