Well I've got Access talking to my test database and I can edit and add rows to tables so in principal it's working, tarting it up a bit and making it a bit more useful will come later. That was actually far easier than I expected - scary!

On a side note, it's possible what I'm trying to do might be possible via TFS, which we're getting soon so I might try and hold off for a little while.