Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / Source Safe / August 2005

Tip: Looking for answers? Try searching our database.

Expected: 'End' Error building Microsoft Access Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sturgel - 22 Aug 2005 16:51 GMT
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!

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.