Automatically import all objects from one database to other

[June7]

I am still confused about how you intend to handle edits of table structure - which should be very rare event. User sends you file, you modify table structure and/or other objects, return file to user. This assumes user does not enter/edit records in the meantime.



Why doesn't code work, what happens - error message, wrong results, nothing?

Step debug - review link at bottom of my post for guidelines.

I'm with ItsMe - split database is best. Then on the rare occasions of table modification, user will have to send you their backend for modification and they cannot enter/edit records until the revision is received.

[gstylianou]

Ok June7, can you please explain step by step your idea with split database?

Please take into account the followings:

1. There is a database with 3 active users which they cannot stop their daily work.

2. Every end of the day they export their data by sending email with attachment

3. They are many pending issues with the design and development of the database. I'm working every day in order to finish with the development of the database.

4. Every day something new with the design occur.

5. As i explain from the beginning i must create some new tables, as well as some new fields into some existing tables. Don't ask "why not from the beginning" didn't add these fields and these new tables...!! Just note that the database was created by another person since 2006 and something.. So i just found the database "live"..

6. If i'm going with split idea how can i solve the issue regarding the new fields and the new tables?

Please, if you can describe to me your idea on how can do live updates i will appreciate

Thanks in advanced

Note: about the code which i have attached i will make screen capture with the error which i'm taking tomorrow.

[June7]

If the database is split and every user is linked to the same backend file, then design changes can be relatively transparent to the users. Some changes (such as deleting or renaming fields or objects) will cause code failure. Other table changes might not error but data might not be captured because the code is not in place. Database modifications should be done when users are not interacting with it. Period. This is why programmers are night people. I keep a master copy of frontend for me to edit and then when I want to deploy revision, I copy it into the Install folder which is used to automatically copy to the user's local drive the next time they open their file. But I can continue to do edits on the master without impacting the deployed version.

Since your users are not in an enterprise database environment, updating their database is greatly complicated. You say users 'export' their data daily by sending email with attachment. What is the attachment? Do they need to retain all this data?

I suggest that daily revisions of db is not practical. A revision should 'roll out' under very controlled conditions and will probably involve a temporary shutdown, like when IT sends out email that the 'server will be out of service from 6am to noon on Sunday for software updates'. So when you want to update the users file - maybe every 2 weeks - have them send you the file Friday night, tell them not to enter data until they receive the revision on Monday, with all their existing data intact. And you spend the weekend fixing their files.

Now if their database is split, and the edits do not involve table design, just new code and/or design of objects in the frontend, then all you need to do is send them the frontend which replaces the one they have. Maybe need to run code to re-establish links to the backend tables.

[gstylianou]

Good morning all,

Please find attached a sample of database in order to check whats going wrong regarding with import / export code. Moreover, you will find attached a code regarding to delete - copy - rename objects.

I will be glad if somebody can help.

Thanks in advanced

[gstylianou]

Attached you can find the screen capture of the errors which i'm taking when i'm trying to import / export objects from one database to new.

Regards