really basic access question

It's been over 10 years that I don't look at Access. I've been working
in asp.net for the last 5 developing intranet sites.

Just got a project where we are trying to avoid building an
application by virtue of reusing something already in place at another
site developed in Access 2003.

I've never seen the application in production, apparently access2003
linked to SQL server 2005 db.

My really basic questions,

presuming the application will only run on a single station, what's
the best way to deploy? Does access still need to run on every client?

How does one limit what the client can see? For example, will the
client be able to unlink tables, view code, etc?

Will a 2003 ap usually run under Access 2007?

I noticed they've included code with the application. It looks like
vb6, is it?

Thanks for any help or information.

.