?
Solved

How to login to Visual Sourcesafe when using office 2007 integration

Posted on 2009-07-08
4
Medium Priority
?
268 Views
Last Modified: 2013-11-26
I'm adding my Access project to Visual Sourcesafe.  On the initial transfer - I get a login prompt for VSS - I log in and the project is loaded into VSS - no problem.

Now when I launch Access 2007 I receive the message "Another user(user1) has placed this database under source code control and is the only person who should work with it.  Source code control features will be disabled."  

How do you cause the system to prompt for your Visual Sourcesafe user name and password?  It seems that it is trying to use the windows user/password which is different from my Sourcesafe login.

Software;

Windows Server 2003
Access 2007 w/ SP2
Visual Sourcesafe 2005 w/ update package
Access 2007 Developer Extensions

Suggestions?  
Thanks
0
Comment
Question by:lesatict
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 24812390
I'm assuming you've installed the Developer Extensions for Access 2007, which includes the SourceCode addin?

Make sure you have "checked in" the objects in your "other" database. That is, you must launch your database from the same location each time. If your original database (the one that you used when adding it to SS) is located at C:\My Database\, then you need to launch THAT instance of your database.

If it still won't work, try opening VSS directly ... if it detects troubles with that file, it'll prompt you to repair it.

Finally, if you cannot get it to work, open VSS directly and remove the project. Note that deleting the project from VSS does NOT delete your original database, but to be safe, make a backup of that database (and verify that you can successfully open it) BEFORE you do this.

http://www.kevingao.net/sourcesafe/integrating-sourcesafe-vss-with-access-2007.html
0
 
LVL 10

Assisted Solution

by:Luke Chung
Luke Chung earned 1000 total points
ID: 24817537
We use VSS all the time with all versions of Access, so I can assure you this will work.
Are you logging in with the same user name that you used when you added the database to VSS?
If you launch VSS, via Run SourceSafe, you can go to the database and see the status of the objects that are checked out and who has them checked out.  The check out folder of all the files hopefully matches the folder created on your desktop
0
 

Author Comment

by:lesatict
ID: 24817764
Thank you both for your information.  

As it turns out - there was a VSS database user named Administrator.  When I initially added the project to VSS the system prompted me for my VSS user name and PW(which did NOT match the current Windows user).  The next time I started Access and attempted to load the project - VSS would log me in as Administrator automatically without prompting for the possibility of using different credentials.  I removed the Administrator user from VSS and now VSS will prompt when I load the project.  My learnings:  have your VSS login credentials the same your windows login OR make sure there are not VSS user credentials for the current windows login in which case it will prompt for a valid VSS user.

Also, if you need to change VSS users on a machine, you'll need to recreate the project from VSS with the new user Credentials.

Again, thanks for the quick responses.
0
 

Author Closing Comment

by:lesatict
ID: 31601411
It all helped!!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month10 days, 22 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question