Is it possible to change the structure of an existing database while keeping all of the current data? Thank you for your time.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Restructuring Access Database
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Restructuring Access Database
- This topic has 3 replies, 4 voices, and was last updated 15 years, 8 months ago.
Viewing 2 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerSeptember 24, 2009 at 9:13 am #1178555Welcome to Woody’s Lounge!
But in general it should be possible to preserve your data, but how much work it will be will depend on what exactly you want to do.
You can:
– Add fields to an existing table.
– Change the field size of existing fields in tables, as long as you make sure that the new size is not too small for existing data.
– Change the field type of existing fields in tables with certain restrictions.
– For example you can convert a number field to a text field, but usually not the other way round (depends on the data).
– Add, change and remove indexes.
– Add, change and remove relationships.For more complex modifications, it may be necessary to add auxiliary fields to a table, and populate them using an update query.
If you want more help, please provide some details about what you want to do.
-
WSStephenElms
AskWoody Lounger -
WBell
AskWoody_MVPSeptember 24, 2009 at 10:56 am #1178566Is it possible to change the structure of an existing database while keeping all of the current data? Thank you for your time.
In addtion to the other comments, when you restructure a database it can have pretty wide ranging impacts. For example, if you decide the database wasn’t properly normalized, and you really need to have some of the data in a table spun off into another table that is linked to the first table, that will probably affect any forms or reports that use that data. So restructuring can be a pretty large task.
However, it is sometimes necessary to really make the database work effectively. That is why we usually spend a fair bit of time up front making sure we understand the problem, and making sure that the schema we set up is appropriate. It’s much like pouring a foundation for a house – you want to make sure you have that right before you start putting up studs and such.
Viewing 2 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Auto Time Zone Adjustment
by
wadeer
2 hours, 27 minutes ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
7 minutes ago -
Manage your browsing experience with Edge
by
Mary Branscombe
8 hours, 18 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
4 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
42 minutes ago -
Apps included with macOS
by
Will Fastie
8 minutes ago -
Xfinity home internet
by
MrJimPhelps
13 hours, 10 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
1 hour, 22 minutes ago -
Debian 12.11 released
by
Alex5723
23 hours, 35 minutes ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
1 day, 3 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
6 hours, 43 minutes ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
23 hours, 45 minutes ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
1 day, 20 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
1 day, 10 hours ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
1 day, 22 hours ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
1 day, 15 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
22 hours, 41 minutes ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
38 minutes ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
2 days, 8 hours ago -
Sometimes I wonder about these bots
by
Susan Bradley
2 days, 4 hours ago -
Does windows update component store “self heal”?
by
Mike Cross
1 day, 18 hours ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
2 days, 22 hours ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
1 day, 6 hours ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
18 hours, 54 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
3 days, 1 hour ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
3 days, 1 hour ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
2 days, 13 hours ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
3 days, 9 hours ago -
0Patch, where to begin
by
cassel23
3 days, 3 hours ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
3 days, 22 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.