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
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
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.

John
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.
 

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

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