5 hours ago: Our file storage provider is running maintenance today. If any videos don't load, wait a minute, refresh the page, and try again. Sorry for any inconvenience.  Dismiss
Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Back to Evil Access Stuff    Comments List
Need to fix a badly done DB Upload Images   Link   Email  
John Jira        
17 months ago
Hi Richard

I been asked at work to try and update a badly done DB. Is there any course or seminar on this?  Also something on how to remove a Switchboard.  Any info regarding this would be helpful.

Kevin Robertson            
17 months ago
Scott Axton            
17 months ago
There isn't any one seminar or video on how to accomplish what you are talking about. You're on the right track knowledge wise I see by the courses you have taken.  Now it is just a matter of combining that into making a working solution for you.

The way I see it there are two solutions.  Much like pulling at a loose thread on a sweater, you just start picking apart your db, fix this here and that there.  You will find that making a change on one thing will often break another.

The other solution would be to sit down and plan out your db on paper, just like in Richards new series, Association 1.  Using your old db as kind of a road map, list out what you like and don't like.  What works well and what doesn't and how you need to make it right.
Then build it new.  
You shouldn't loose your data because you will be able to import it into the proper places when you are finished.

I chose the first method in the db I'm responsible for.  I've been at it for what seems like forever.
Honestly I think, looking back now, that I would have been better off starting fresh. I don't think I would have had near the heart burn that I've had.

Which ever road you take make sure that you back up, back up, back up!
Work with a copy making sure you don't trash your live data.
Scott Axton            
17 months ago
Regarding removing your old switchboard, it really was just a crutch for beginners to have a menu system.
You have learned to make you own forms, put buttons on the forms to open other forms or run reports, etc.

It really is pretty much duplicating that functionality like you want it.  Put your new menus in place and stop using the switchboard.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Evil Access Stuff.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/14/2024 11:20:39 AM. PLT: 1s