Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VSS And Access Linked Tables

VSS And Access Linked Tables

VSS And Access Linked Tables

Does anybody know how or what does VSS manage with regards to linked backend tables in the frontend database? There is an option there to checkout the table but it is linked so what does that mean? You can't change table design of a linked table in the frontend so why do you have to check it out? Is VSS smart enough to version control the tables in the backend database if you only enable VSS in the frontend database? Do you have to add the backend database to VSS too? I can't find any information on this so I would really appreciate it if you could share with me how you manage backend databases in VSS. I find it strange that I can't find any info on this. Am I missing something here? I would like to get some info on this before I add all my Access database frontends to VSS.


RE: VSS And Access Linked Tables

I have read in a book handling Micosoft Visual Studio that it is best practice to NOT add any kind of database (be it Access, SQL Server etc) to the VSS database.  When I add a project folder which contains an Access database, I then go back, right click the file and choose 'Remove From Source Control'.  This takes it out of source control thereby eliminating potential problems.

RE: VSS And Access Linked Tables

Hi Shaker,

Did you ever figure this out how Sourcesafe handles linked tables?

Is VSS a good tool to use to source control an Access database? (it's the only tool out there...)

If you could give me some info from your experiences, that would be greatly appreciated. =)


RE: VSS And Access Linked Tables

If you add an MS-Access database to sourcesafe, be sure to clear the "other objects" from the list of objects to check in. Otherwise your data is checked in in sourcesafe. I do not know what is stored when using linked tables, but I don't want any tabledata in sourcesafe whatsoever (I mean, what's the point in storing one database in another?).
Apart from the extra startup time when starting a checked-in database and some sourcesafe bugs, I think it is a workable solution to keep your modules, queries etc. in sourcesafe.

Best regards

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close