Lantica User Forum - Removal of SubDatabase from the Database

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Removal of SubDatabase from the Database

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Removal of SubDatabase from the Database (Read 1062 times)

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Removal of SubDatabase from the Database May 8^th, 2012 at 9:25pm	Print Post
	I am planning to detach one subdatabase and attach it to another Database, as Document subform is in the database that I normally work with and I need to attach (reparent) document from the form that belongs to the database. Unfortunately, that creates a problem with reparenting.� How do I do it? What precautions should I be taking? I have about 10,000 subform records in each of the two subforms that I have to detach from one database, create another database and attach to that. How much time should I assign for that? Any support and help is appreciated.


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Removal of SubDatabase from the Database Reply #1 - May 9^th, 2012 at 9:02pm	Print Post
	Hello Bharat, I always recommend creating a backup of the database before doing large operations such as reparent. How long the reparent is going to take depends on quite a few factors, so it's really impossible to say how long the operation is going to take. Be sure you delete the subrecord fields in the current parent Database to completely detach the subdatabase from it and then create the new parent form and add the subform to it. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Removal of SubDatabase from the Database Reply #2 - May 9^th, 2012 at 9:10pm	Print Post
	Thanks Ray. I should gather all courage and start the process. So long as I have backup copy, what do I have to lose?� I will have to change the code at multiple places. But it seems doable and earlier I do that better it would be. Thanks again.


	IP Logged

lksseven Full Member Offline Posts: 416 Location: Southwest Joined: Jan 26^th, 2009	Re: Removal of SubDatabase from the Database Reply #3 - May 9^th, 2012 at 10:01pm	Print Post
	Good luck, Bharat! (why not make 2 backups, just for grins?).

	Larry
	WWW YIM IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Removal of SubDatabase from the Database Reply #4 - May 9^th, 2012 at 10:05pm	Print Post
	I usually have multiple backups. Daily backups, weekly backup, in-house backup, Cloud backup, etc. Thanks Larry.


	IP Logged

BOBSCOTT Senior Member Members Offline That Darn Computer #$X# {curse words} Posts: 1195 Joined: Nov 22^nd, 2002	Re: Removal of SubDatabase from the Database Reply #5 - May 9^th, 2012 at 10:42pm	Print Post
	Bharat, Are you moving the entire DB or do you just want a specific form? If it's just a form you really want to move, I find that the Export Form to XML and Import Form from XML works like a champ.

	Team � Together Everyone Achieves More
	IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Removal of SubDatabase from the Database Reply #6 - May 10^th, 2012 at 2:07pm	Print Post
	Hi Robert, I am just moving two subforms from one form to a new database form. But in the process I will have to make a new database and transfer and change codes in various places.


	IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›