how to make a .mdb file an exe and also sharing

[jensonchandy]

hi friends

i have 2 .mdb extension files
one file contains the database,eg data.mdb
when i open it an automatic lock will appears and i'm able to make changes in that file.but when my collegue open it he is able to view the data but not able to save.how to make the file usable by more than one user and all the users(maximum of 3 users) can make changes in the database too...

the second file is reports.mdb...where the forms and reports are stored. i need this to be an exe file .how to do that ..need an urgent reply

regards
jenson

 

[Mile-O]

i need this to be an exe file .how to do that ..

Simple answer: you can't. Please search on this subject for more information as it is asked all the time.

 

[Pat Hartman]

Access will not permit database objects to be modified in a shared database. Users should NOT be allowed to modify objects for any reason. Sharing for data update is not a problem. Make sure that each person has the correct network permissions so that they can create and modify files in the .mdb's directory. When the first person opens the .mdb, Jet creates the .ldb file so that it can manage multi-user access. If the user does not have permission to create this file in the same directory as the .mdb, Jet locks the .mdb so that no one else can update it.

As for the .exe issue - not a chance. Seek and ye shall find out why.