I have an Access application (adp) that is under source control at work using
TFS (Team Foundation Server). When I check-out the application I can use it
in any way I want (to modify it).

However, I need to bring the .adp file at home to study the code on my free
time. I managed to duplicate the SQL Server database it's connected to. But
when I try opening the adp file at home, I get the "lock" icon next to all my
access objects (forms, modules, etc). I'm no expert in TFS but we use it at
work to manage our Access applications with the rest of the team. How can I
bring a copy of the Access application at home and use it.

Hi Ray,

Have you tried creating a new .adp file, and then importing all objects from
your checked-out copy? I don't know if this will work, but its worth a try.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"Ray C" wrote:

> I have an Access application (adp) that is under source control at work using
> TFS (Team Foundation Server). When I check-out the application I can use it
> in any way I want (to modify it).
>
> However, I need to bring the .adp file at home to study the code on my free
> time. I managed to duplicate the SQL Server database it's connected to. But
> when I try opening the adp file at home, I get the "lock" icon next to all my
> access objects (forms, modules, etc). I'm no expert in TFS but we use it at
> work to manage our Access applications with the rest of the team. How can I
> bring a copy of the Access application at home and use it.

If you want to remove the db from source control, compact it and click Yes
when it asks about removing from sourcecode control. If you want to edit
objects and then check it back into source control at work, check out the
objects you want to edit at home before you leave work, and then bring the
db home. Once you're back at work you can check those objects back into
source code control.

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
news:B89693FD-7143-4E38-9962-(E-Mail Removed)...
> Hi Ray,
>
> Have you tried creating a new .adp file, and then importing all objects
> from
> your checked-out copy? I don't know if this will work, but its worth a
> try.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> __________________________________________
>
> "Ray C" wrote:
>
>> I have an Access application (adp) that is under source control at work
>> using
>> TFS (Team Foundation Server). When I check-out the application I can use
>> it
>> in any way I want (to modify it).
>>
>> However, I need to bring the .adp file at home to study the code on my
>> free
>> time. I managed to duplicate the SQL Server database it's connected to.
>> But
>> when I try opening the adp file at home, I get the "lock" icon next to
>> all my
>> access objects (forms, modules, etc). I'm no expert in TFS but we use it
>> at
>> work to manage our Access applications with the rest of the team. How can
>> I
>> bring a copy of the Access application at home and use it.