Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BoulderRidge

  1. BoulderRidge

    Should I convert Access 2000 app (with mail merge) to 2010 to run on 2013?

    I have a small single-user app (one main data entry screen with subforms and several reports with export to Excel option) that was written and deployed in Access 2000. Amazingly the app is still in use and they recently requested a few report modifications so I am opening the code for the first...
  2. BoulderRidge

    archive strategy for large application database SQL 2008

    Thank you Frederico! When we are talking about archiving a minimum of 34 tables at a time, is it always easier/advisable to do so in some type of database backup as opposed to exporting the contents into flat files via an SSIS package? IF so why? Thanks, -- BoulderRidge B-)
  3. BoulderRidge

    archive strategy for large application database SQL 2008

    update: i just learned that the contents of the "static" tables may be updated as often as quarterly. So now it seems like the goal is to save a copy of all "static" tables once per quarter and all run-specific tables monthly. same questions apply: what is the best format to preserve this data...
  4. BoulderRidge

    archive strategy for large application database SQL 2008

    I’m trying to design an archive strategy for a large SQL Server 2008 application database (that I didn’t create). The database has two types of tables: static and run-specific. Static tables don’t change frequently but run-specific tables are completely refreshed once per month. Data from...
  5. BoulderRidge

    Dropped connection causing corruption—should I change configuration?

    I have an Access 2007 app running in a Windows 7/Access 2010 environment. The back end database lives on a network server. The users connect wirelessly to the network on tablets (no other option). Currently each user has a personal copy of the front end application database (with tables linked...
  6. BoulderRidge

    If this is not corruption, what else can it be???

    It was corruption but a stronger flavor than I have seen before--one of the indexes on one of the main tables was corrupted. I became suspicious when I saw a post mentioning random results from a filter being related to a corrupted index. So I deleted ALL the indexes on each of these main...
  7. BoulderRidge

    If this is not corruption, what else can it be???

    One form in my Access application is behaving badly. It normally opens in Data Entry mode to a new blank record, but today it is opening on the first record in the table with all 5900 records available to view. I have a drop-down that filters these records to Last Day, Last 7 Days or Last 30...
  8. BoulderRidge

    Multi-User application behaving badly

    I have an application developed in Access 2007/Windows ME and running on Access 2010/Windows 7. The Back End shared database lives on a network server. Version 1 deployed a year ago and suffered from periodic corruption. I finally discovered that it had not been deployed as intended and...
  9. BoulderRidge

    AutoNumber field AND unique index field contain a duplicate value in my table

    Actually just last week I had a major "ah-hah" moment on this issue. I believe it was indeed corruption...and I think I now know what triggered it: 1. Multiple users were running the same physical copy of the front-end Access application from the network instead of running from their own...
  10. BoulderRidge

    AutoNumber field AND unique index field contain a duplicate value in my table

    Hi lameid, Thanks for the comments and detailed advice...I think I'll go for the "rare and not likely to repeat" option but if it turns some other bit of luck in my favor that will be a bonus. I had deleted the offending record and added the primary key with two successful repair and compact...
  11. BoulderRidge

    AutoNumber field AND unique index field contain a duplicate value in my table

    I can send screen shots if you need proof:) In my table, the first column is an AutoNumber field and the second column is long integer with a unique index (Primary Key=No, Unique=Yes, Ignore Nulls=No). I can see two records with the same first column value and the same second column value. How...
  12. BoulderRidge

    Access accde opens read-only in Windows 7

    I created an Access application in Access 2007 on a Vista machine. Now it is being distributed in an Access 2010 and Windows 7 environment. The shared database lives on the network and works fine. The front-end application database file is distributed by placing it on the network share and then...
  13. BoulderRidge

    3 computers on same MiFi, one suddenly slower?

    Hi ChrisHirst, I'll ask the dumb question: how/where would I go about 'switching to the OpenDNS servers'? Is this just when searching from Google or is it more universal than that? thanks, -- BoulderRidge B-)
  14. BoulderRidge

    3 computers on same MiFi, one suddenly slower?

    Odd, I checked settings and downloads are scheduled to run daily at 3 am. If I have the machine shut down overnight, wouldn't they start as soon as I log in? The slowness was consistent all that day Wednesday. We don't have any cordless phones active anymore; had hoped to run the old landline...
  15. BoulderRidge

    3 computers on same MiFi, one suddenly slower?

    Hi linney and vacunita, Thanks so much for the helpful comments. I will go thru the recommended cleanups since I think they are overdue anyways. However, today the speed has doubled on the desktop (without me making changes). When I shut down last night, I got a blue system screen and it went...
See more

Part and Inventory Search

Back
Top