| Author |
 Topic  |
|
|
TastyNutz
Junior Member
USA
251 Posts |
 Posted - 01 September 2007 : 16:06:03
|
| Is there an easy way to compare the structure of two Access databases? I'd love something like a "Beyond Compare" equivilant for .mdb files. |
PowerQuad Disability Support Forum |
Edited by - TastyNutz on 04 September 2007 11:51:11 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
TastyNutz
Junior Member
USA
251 Posts |
|
|
TastyNutz
Junior Member
USA
251 Posts |
Posted - 04 September 2007 : 11:50:33
|
When connecting an old database, I ran my dbs_ files to add missing tables/fields, and everything appeared to work fine. One exception was that the old topics would not archive properly. I compared the database against a known working one, and the only differences were the names of several indexes. The indexed fields were the same, just different names for the index. I made the names match those of the working database, and then the old topics archived okay.
Can someone help me better understand how the indexes work?
Are they created when the database is designed, or are they somehow created by code when the table is searched?
Why the long, random appearing names (e.g. Index_5D879B58_022D_4339)?
And when writing a dbs_ file, how can I best ensure that an upgraded database will work properly?
TIA.
BTW... The comparison tool I linked above works well enough. It doesn't have the easy copy over capability like Beyond Compare, but it is free. |
PowerQuad Disability Support Forum |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
TastyNutz
Junior Member
USA
251 Posts |
Posted - 04 September 2007 : 12:04:29
|
When I selected a forum to archive, the process appeared to run and would give several lines of dots and then a single confirmation line, to the effect of "All topics older than 9-1-06 were archived." But upon checking the forum, there were still old topics. Archiving the same forum again resulted in something like "No topics archived. None found."
After changing the indexes, the archive process resulted in many lines of confirmation, and the old topics were removed as they should be. |
PowerQuad Disability Support Forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 September 2007 : 12:11:46
|
| That's weird. Indexes speed up database operations, many times dramatically, but they should not cause the forum to provide erroneous information like 'no topics found', when there are topics to archive. Timeouts or generally longer times to get operations to conclude, yes, but not things like those. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
TastyNutz
Junior Member
USA
251 Posts |
Posted - 04 September 2007 : 12:18:12
|
That's what I thought. But I'm 99% certain that my only changes were the index names. Hmmmm... Perhaps I'm mistaken. I'll try to replicate the issue later and see if I can provide access to a live example.
Thanks ruirib. |
PowerQuad Disability Support Forum |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 04 September 2007 : 12:47:47
|
Index names are unimportant to the db, however maybe changing the name forced a statistics/index refresh?
Indexes themselves would speed up searches and reads, but slow down inserts, updates and deletes (as the dbengine has multiple writes to do, not just one table) |
|
|
| |
Topic |
|
Topic Locked
