Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-07-2019, 12:03 PM   #16
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Exporting Database to XML

Hi. Just a thought... If you add the dbFailOnError parameter, you might get a message why the code fails sometimes. For example:


db.Execute strSQL, dbFailOnError

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
LinksAwakener (02-07-2019)
Old 02-07-2019, 02:03 PM   #17
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,203
Thanks: 3
Thanked 475 Times in 468 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Exporting Database to XML

Re #8
Quote:
I'll have different instances of this same Access program on different machines, and users will be able to send their database (as a single exportable file easily emailed or shared in other ways) to another user, who can then import the database.
This to me sounds like you have not split your database ie tables,queries,forms etc are all in the one database file and you only want to export the data.
Why not split the data tables into a back end file and send that accdb file to other users.


Your response above seems to imply several users are adding/editing data. How are you going to synchronize changes?
Cronk is offline   Reply With Quote
Old 02-07-2019, 02:12 PM   #18
LinksAwakener
Newly Registered User
 
Join Date: Feb 2019
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
LinksAwakener is on a distinguished road
Re: Exporting Database to XML

Quote:
Originally Posted by Cronk View Post
Re #8

This to me sounds like you have not split your database ie tables,queries,forms etc are all in the one database file and you only want to export the data.
Why not split the data tables into a back end file and send that accdb file to other users.


Your response above seems to imply several users are adding/editing data. How are you going to synchronize changes?
The database is split into back-end and front-end. The feature request from the users was specifically that they want to have the ability to back up and restore using XML files.

The users have no need to merge data; each person is going to have their own records. I can't get into much detail, but you can think of it like this; each user's version of this software is going to contain their own personal notes on a particular item. This is meaningful to share between users once in a while, but having everyone on one back-end would muddy the waters.



I was able to implement a solution, fully functional. I had to do things the hard way: test each table as it was imported for dependency complaints. When there was a complaint, rearrange the import procedure to import that particular table later and test again. I hate hard-coding all those tables like that, but when there's dependency constraints and it has to be done in a specific order...\_(ツ)_/

LinksAwakener is offline   Reply With Quote
Old 02-07-2019, 02:14 PM   #19
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Exporting Database to XML

Hi. Congratulations! Glad to hear you got it sorted out. Good luck!
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 02-07-2019, 02:17 PM   #20
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,814
Thanks: 457
Thanked 908 Times in 872 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Exporting Database to XML

Quote:
Originally Posted by LinksAwakener View Post
I hate hard-coding all those tables like that, but when there's dependency constraints and it has to be done in a specific order...\_(ツ)_/
So no doubt you could create a table which would show the order that they need to be imported and could be amended easily should that change.?

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Reply

Tags
export , vba , xml

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help In Exporting Access Database Table atfaniqbal Tables 8 06-24-2013 11:08 AM
Exporting database object using only vba NigelShaw General 1 06-30-2009 11:42 AM
Exporting Calendar into a different database lovelylauralin Forms 19 10-31-2006 07:33 AM
exporting an access database as an exe arobbo General 1 11-22-2004 06:10 AM
[SOLVED] Exporting tables to another database DRWale Tables 0 10-29-2003 10:38 AM




All times are GMT -8. The time now is 10:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World