Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2004

Tip: Looking for answers? Try searching our database.

Question on update table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pei - 02 Aug 2004 21:25 GMT
To All

How do I "update or replace a table" in the data base with new information without loosing my connection to forms that I have created? ( I am hesitating to use use "append table" because I have added information and new field on the new table. )  What I have done so far, is rename the old table, and name the new table with the old name; to do this I had to delete the relationship and connect the relationship of old form to new table.  But what I have found was that although the control source property is the same and the form shows up in design view, but I can no longer view any data information in form view.  What is your suggestion?

P.S. I have a back up of the data base.
Jeff Boyce - 03 Aug 2004 12:43 GMT
Pei

Why do you feel you need to replace a table?  We're not there, so we can't
see what situation you are dealing with.  It may be that there's another
solution besides replacing the entire table.

Signature

More info, please ...

Jeff Boyce
<Access MVP

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.