I am using VSS 6.0 with Access 97 and I get this error: Expected: 'End' when
I try to build my Access database. The objects can't be extracted from the
VSS database and are omitted from the build. This so far has been the only
form of corruption I have encountered. I ran ANALYZE and it did fix some
problems but not this one. Does anybody know what this error means in
SourceSafe 6.0? What causes it? And how to fix it? Any help would be
appreciated!
Thanks!
sturgel - 22 Aug 2005 17:02 GMT
More Info...
I viewed the access files in VSS and discovered that this problem happens at
the end of the "PrtDevNames" section of the .ACR file. As a matter of fact,
this error only occurs with the Access report files in VSS. It appears to be
a print driver problem?
> I am using VSS 6.0 with Access 97 and I get this error: Expected: 'End' when
> I try to build my Access database. The objects can't be extracted from the
[quoted text clipped - 5 lines]
>
> Thanks!
sturgel - 22 Aug 2005 17:45 GMT
More Info:
Here is the actual code in the VSS file version of the report object:
PrtDevNames = Begin
0x080012002400010077696e73706f6f6c00004850204c617365724a6574203431 ,
0x3030000031302e352e3231392e38370000000000000000000000000000000000
0x00
End
The problem appears to be the "0x00" line. As you can see there is no comma
before this line. I'm not sure if there should be one or the "0x00" line
shouldn't be there.
> I am using VSS 6.0 with Access 97 and I get this error: Expected: 'End' when
> I try to build my Access database. The objects can't be extracted from the
[quoted text clipped - 5 lines]
>
> Thanks!
sturgel - 22 Aug 2005 17:55 GMT
Possible Solution:
I disabled the Disable_UI switch in srcsafe.ini file and checked out one of
the report files in VSS. I added a comma to the end of the line before "0x00"
in the same position as previous commas on other lines. Saved the file,
checked it back in, and created my access database again. This time the
report object extracted ok. I did a quick check of the report and it opened
in design view and previewed ok. This looks like a solution.
A prevention would be even better.
> I am using VSS 6.0 with Access 97 and I get this error: Expected: 'End' when
> I try to build my Access database. The objects can't be extracted from the
[quoted text clipped - 5 lines]
>
> Thanks!