First, my apologies for bringing such an off-topic issue here. But, BAUT is the only board I'm currently semi-active in, and since I know there are a few programmers around, I thought I would give it shot.

A client/friend of mine uses an Access database in his business, and have severe performance problems (lock-ups, crashes) when many people work simultaneously. He asked me if I could convert it to an SQL database, but nevermind that for now.

Having very little experience with Access, but from what I understand, you define tables etc and then you can slap an interface + logic on it with Visual Basic (*shudders*). When I open the "application", Access gives me the interface but I can for the life of me not see where I can see the source or make any changes to it; it appears locked. My client says many different people have extended the application over the years, but he claims to have no other files.

I've looked for some quick overview of how "Access applications" of this kind are made up, but found nothing useful. Can someone see my problem here, and perhaps point me in the right direction?