[AccessD] RemoteEatBloat

Max Wanadoo max.wanadoo at gmail.com
Fri Feb 19 08:23:10 CST 2010


Hi Dan,

Relationships are handled in my RemoteEatBloat (REB) so feel free to pick
out that code if you want it.  Also References and re-linking of linked
tables.

The point about exporting to different folders based on object type was to
allow the user to more easily find single items for importing. But ATEOTD it
doesn't matter much  either way.

I wouldn't allow the linked tables to be exported as data (I did leave that
code there for others but thinking about it,  these should be handled by EB
in the BE database and not the FE database.).  Your chose though.

I had a quick look at your version and it looked nice. I am still trying to
get REB "out of the door" so I didn't get too much time to play with it.

I will be passing REB over to AccessD in due course so people can take
whichever suits them the best. Also, Shamil's version will be available so
people will be spoilt for choose.

Better  too much then none at all, eh?

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: 19 February 2010 13:21
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] RemoteEatBloat

Hi Max,

<1. EatBloat
<a. Allows individual selection of objects to export and import.
<b. Sits inside another mdb as a self-contained form 
<c. Did not handle <Relationships, References or linked tables.
<d. All of the above may have changed in Dan's re-write to EatBloat2.>

For my rewriting of your form, a and b are still true.  It also will export
all objects of one type, or all objects.

For c, it does not handle relationships (I think code to determine, store,
and replace relationships may be interesting).  It does allow linked tables,
but only as an option that is turned off by default.

My primary purpose in rewriting this was to change the export structure so
that all of the objects that were exported at one time were exported to the
same folder, rather than a different folder for each type of object.  This
took a lot of file/folder manipulation, but it's worth it.  Now when I'm
importing I can just 'select all' in the navigation window, push the Proceed
button, and it all gets imported at once.  Tables are imported first, then
queries, then the remaining objects.

In addition, you said once that you like to use this as a backup mechanism.
To do this the export folder is now date and time stamped.  You can reset
the date and time stamp to current time by pushing one button, or you can
turn on auto update of date and time so that each export is automatically
sent to a different export folder.

I also wanted to use the list boxes for a visual selection of objects to
export.

Please take a look and let me know what your thoughts are!

www.promationsystems.com/databaseadvisors.htm

Thanks!
Dan

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list