back end question

[Phil]

I made a change to a backend db by adding a table and relationships.
How can I integrate that into another backend which has the correct and
valid data. This change I can do manually but I would like to know if I
can check to see if there is any other changes to the design in my
development copy with the invalid data but up-to-date structure.

--
Phil

[Allen Browne]

There are commercial tools you can buy to do this, such as:
http://www.ssw.com.au/ssw/DataPRO/

It's quite a job to program this kind of tool yourself, because you need to
visit:
- new tables
- dropped tables
- changed tables:
o changed table properties
o new fields
o dropped fields
o changed field properties
o new indexes
o dropped indexes
o changed indexes:
* new fields
* dropped fields
* changed fields
* changed field properites
- new relations
- dropped relations
- changed relations:
o changed properties
o new fields
o dropped fields
o changed fields

Here's Tony Toews take on this:
http://www.granite.ab.ca/access/backendupdate.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil" <st***@basketball.net> wrote in message
news:mH****************@newssvr30.news.prodigy.com ...

I made a change to a backend db by adding a table and relationships.
How can I integrate that into another backend which has the correct and
valid data. This change I can do manually but I would like to know if I
can check to see if there is any other changes to the design in my
development copy with the invalid data but up-to-date structure.

[Salad]

Phil wrote:

I made a change to a backend db by adding a table and relationships.
How can I integrate that into another backend which has the correct and
valid data. This change I can do manually but I would like to know if I
can check to see if there is any other changes to the design in my
development copy with the invalid data but up-to-date structure.

See TableDef, TableDefs, Fields, Field, CreateTableDef and all code
examples associated with them in help. Look too at CreateRelation and
Relation Object.

You should also be familiar with On Error..Resume Next, etc.

You should know how to do for/next loops...or Do Whiles.

See OpenDatabase and Connect for opening up other databases.

The above methods/properties should get you pointed in the right direction.

In your case, you would check to see if a tabledef exists in a the other
database. If it doesn't, build it.

If it does exist, you would then open up the development tabledef and
scan all fields in it. You would compare each field and see if it
exists in the other database tabledef. If not, add the field.

[Phil]

thx, I knew it would be a chore by hand. I was hoping access had
something built in.

I may try to just scan both dbs tables and list out differences in there
properties. I am thinking also if I could do the documenter on both and
use my file compare program to check differences.

Allen Browne <Al*********@SeeSig.Invalid> posted in
news:41***********************@per-qv1-newsreader-01.iinet.net.au

There are commercial tools you can buy to do this, such as:
http://www.ssw.com.au/ssw/DataPRO/

It's quite a job to program this kind of tool yourself, because you
need to visit:
- new tables
- dropped tables
- changed tables:
o changed table properties
o new fields
o dropped fields
o changed field properties
o new indexes
o dropped indexes
o changed indexes:
* new fields
* dropped fields
* changed fields
* changed field properites
- new relations
- dropped relations
- changed relations:
o changed properties
o new fields
o dropped fields
o changed fields

Here's Tony Toews take on this:
http://www.granite.ab.ca/access/backendupdate.htm
"Phil" <st***@basketball.net> wrote in message
news:mH****************@newssvr30.news.prodigy.com ...

I made a change to a backend db by adding a table and relationships.
How can I integrate that into another backend which has the correct
and valid data. This change I can do manually but I would like to
know if I can check to see if there is any other changes to the
design in my development copy with the invalid data but up-to-date
structure.

--
Phil

[Tony Toews]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote:

It's quite a job to program this kind of tool yourself, because you need to
visit:
Allen

I hope you don't mind but I've added a Groups Google link to your posting to the
below page.
Here's Tony Toews take on this:
http://www.granite.ab.ca/access/backendupdate.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Jack MacDonald]

Google for "MDBDIFF" -- a free utility for showing differences between
two MDB files.

On Sat, 23 Oct 2004 12:18:08 GMT, "Phil" <st***@basketball.net> wrote:

thx, I knew it would be a chore by hand. I was hoping access had
something built in.

I may try to just scan both dbs tables and list out differences in there
properties. I am thinking also if I could do the documenter on both and
use my file compare program to check differences.

Allen Browne <Al*********@SeeSig.Invalid> posted in
news:41***********************@per-qv1-newsreader-01.iinet.net.au

There are commercial tools you can buy to do this, such as:
http://www.ssw.com.au/ssw/DataPRO/

It's quite a job to program this kind of tool yourself, because you
need to visit:
- new tables
- dropped tables
- changed tables:
o changed table properties
o new fields
o dropped fields
o changed field properties
o new indexes
o dropped indexes
o changed indexes:
* new fields
* dropped fields
* changed fields
* changed field properites
- new relations
- dropped relations
- changed relations:
o changed properties
o new fields
o dropped fields
o changed fields

Here's Tony Toews take on this:
http://www.granite.ab.ca/access/backendupdate.htm
"Phil" <st***@basketball.net> wrote in message
news:mH****************@newssvr30.news.prodigy.com ...

I made a change to a backend db by adding a table and relationships.
How can I integrate that into another backend which has the correct
and valid data. This change I can do manually but I would like to
know if I can check to see if there is any other changes to the
design in my development copy with the invalid data but up-to-date
structure.

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

[Allen Browne]

Always welcome, Tony.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:rm********************************@4ax.com...

"Allen Browne" <Al*********@SeeSig.Invalid> wrote:

It's quite a job to program this kind of tool yourself, because you need
to
visit:

Allen

I hope you don't mind but I've added a Groups Google link to your posting
to the
below page.

Here's Tony Toews take on this:
http://www.granite.ab.ca/access/backendupdate.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm