Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-07-2015, 04:16 AM   #1
pr2-eugin
Super Moderator
 
pr2-eugin's Avatar
 
Join Date: Nov 2011
Location: Bournemouth, UK
Posts: 8,498
Thanks: 68
Thanked 2,067 Times in 2,014 Posts
pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about
How to Upload a Stripped DB.

Hello there,

I have seen this many times across the Forum, when some of us ask users to upload the DB.. The responses we get are "The information is sensitive", "The file is too big", "There are over 100,000 records"..

Well when I started using this Forum, I did not know how to UPLOAD a stripped DB.. So here is the information on how to create a Stripped DB.

Thread : How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..
1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..
Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

__________________
Regards,
Paul Eugin

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
!
!
Windows 7 Professional, MS Access 2010
---------------------------------------------------------------------------------------------------------------------
If the above post has helped you, please click the scales
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
or click the 'Thumbs up'. Cheers.

---------------------------------------------------------------------------------------------------------------------



pr2-eugin is offline   Reply With Quote
The Following 5 Users Say Thank You to pr2-eugin For This Useful Post:
hassanogaibi (06-28-2016), KBJ911 (07-16-2016), mjdemaris (06-29-2016), murray83 (07-24-2019), shephardfamilyenterp (10-07-2019)
Old 06-22-2017, 09:00 PM   #2
daniel.smith.10
Newly Registered User
 
Join Date: May 2017
Posts: 11
Thanks: 0
Thanked 3 Times in 3 Posts
daniel.smith.10 is on a distinguished road
Re: How to Upload a Stripped DB.

Thanks for sharing this information
daniel.smith.10 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spaces Stripped from Append Query Field alawless Queries 1 08-07-2011 08:58 PM
VBA for FTP Dowload and Upload giovanniroi Modules & VBA 1 01-27-2011 09:51 AM
Importing CSV w/report title stripped out.. LeverColson General 2 11-14-2006 10:29 PM
I can't upload this ..to big...please help.. f_disk Forms 5 09-21-2006 10:29 AM




All times are GMT -8. The time now is 06:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World