Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Can My DB Go Live
Sean Turconi 
    
3 years ago
Greetings Access People,

I'm fairly new to the Access world. I've gone through 85% of the Beginner Series lessons and a million YouTube videos (mostly of Richard Rost) and I keep coming back to the same thought: "When will my database be ready to "Go Live" and be solid enough to put my Excel data into? Thank you in advance.

Live Long and Prosper

Sean
Scott Axton  @Reply  
        
3 years ago
Others will probably chime in but playing with pretend data is one thing, actual data another.
Unfortunately this is a question only you can answer yourself.

You can only test dummy data so far.  Are you planning on others using it?  If so maybe give another person a test copy and ask them to help you beat it up.  No matter what I do it seems like I don't account for all the ways people can break things.
I think it is a case of me being to close to the trees to see I'm in the forest.

The next question is, are you going to have more than one person using this at the same time?  Once that happens it can cause other issues. Splitting your db.

The real world scenario is you will probably never be totally finished with your db (at least in my case).  Our db is 25 or so years old and I still tweak it on a regular basis. Making little changes here and there as I learn different things here.
The key is good back ups and working on a copy of the db.  I very rarely make a change in a live db.  That almost always is a disaster waiting to happen.
Adam Schwanz  @Reply  
           
3 years ago
The biggest thing I've noticed is as Scott said, if others will be using it, you will probably find a bunch of errors that you didn't expect. It can work perfectly how you use it (the intended way), but somehow, someway, other users always find a way to get to stuff that you wouldn't even think it was possible (why would they do that?) and break something. I would probably go live alongside your excel files at the same time for a week or two and make sure everything is how you expect it to be.
Kevin Yip  @Reply  
     
3 years ago
You just have to keep testing and testing, and until the number of errors and problems go below what you deem to be an acceptable number, you keep on testing.

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

Next Unseen

 
New Feature: Comment Live View
 
 

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 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 11:54:43 PM. PLT: 1s