Newbies andyZhang Posted January 25, 2001 Newbies Posted January 25, 2001 Hi, I am looking to rename 6 relational database and was wondering what method is the best method to avoid the sub-script from directing to the wrong database. Does anybody have any ideas on performing this? Any help is appreciated. Thanks in advance. ------------------
Kurt Knippel Posted January 25, 2001 Posted January 25, 2001 quote: Originally posted by andyZhang: Hi, I am looking to rename 6 relational database and was wondering what method is the best method to avoid the sub-script from directing to the wrong database. Does anybody have any ideas on performing this? Any help is appreciated. Thanks in advance. 2 ways to deal with this. One way is to go though each file and relink all scripts and relationships. The other is to use the Developer tool to rename/relink the files. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=
pspafford Posted February 6, 2001 Posted February 6, 2001 I read this someplace on the forum, but can't find it now. I've experimented with this technique using a smaller relational database, and it seemed to work. 1. Open the database 2. Change all of the files to single-user 3. Close the database 4. Rename the files 5. Re-open the database 6. Use it a little, making sure that you enter each and every file at least once. This give it a chance to notice the new names as they pertain to relationships. 7. Close the database 8. Re-open the database 9. Change all of the files to multi-user 10. Close it 11. Re-open it 12. Now you can set the files to single or multi-user - whichever you need it to be - and everything should be OK I OFFER NO GUARANTEES Paul
Recommended Posts
This topic is 8961 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now