At least now we fixed errors in your code, so that is a good thing.

What kind of message are you receiving now when the second user tries to
launch their "front end" database copy on their machine?

About the only thing I can think of is that you still don't have proper
permissions in the backend folder. Remember when we say users must have full
permissions to that back end folder where the mdb resides, that includes
file creation rights, and also that of file deletion rights. (if they don't
have file creation rights, then you'll be stuck in single user mode as
stated before).

When users now launch the database, do they get any kind of error message?
Furthermore when you database starts up, do you display some kind of
switchboard or startup form? if the switchboard or startup form does not
attach or have any data from a back end table, then your users should at
least be able to launch the application to the main menu. Can they do that
now?

The other thing you could perhaps check is the locking mechanisms and
settings you have for your forms.  Open up a form in design mode, and check
the "data" sheet of the properties sheet.

Take a look at the setting called : RecordLocks (it should for now be set to
no locks).

Another possible thing you might be overlooking is the default open database
settings you have set. once again in your ND be front and, I would check
your settings for tools->options->advanced tab. The "default open" mode
should be set to shared.

There's is something of a very minor nature that you're missing here, and
it's either folder permissions in the shared folder for the back end mdb, or
one of the options in the front end like the above setting that is opening
the file exclusive.