Corruption of Access 2003 forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve King - 31 Mar 2005 19:19 GMT

We have installed the Access 2003 add-in adc_accscc.exe for VSS and upgraded
to the specified service packs (1 for Office, 6 for Visual Studio, and 6 for
VSS). When we change a form in Access 2003 format and try to rebuild the
database, that form is corrupted and will not download. However, this
procedure works fine if the database is in Access 2000 format. Has anyone
else experienced this and is there a fix or workaround?

Signature

Steve King

Reply to this Message

Paul Shapiro - 01 Apr 2005 15:07 GMT

I use VSS with Access and don't usually have problems. Corruption seems to
be a little more likely when mixing Access versions.

Possible fixes:
1. Delete the corrupt form and import a working version from a backup file.
You might be able to checkout the existing form first, and then check in the
replacement to keep the history. If you have to delete the existing form you
lose the version history.

2. The files are stored as text in VSS. You could try looking at the VSS
copy, compare it to a good form, and see if you can fix the file yourself.
Or add the newly imported working form to VSS and use that as a template to
try and fix the bad one.
Paul Shapiro

> We have installed the Access 2003 add-in adc_accscc.exe for VSS and
> upgraded
[quoted text clipped - 4 lines]
> procedure works fine if the database is in Access 2000 format. Has anyone
> else experienced this and is there a fix or workaround?

Reply to this Message

Corruption of Access 2003 forms

Free Magazines