Ask Experts Questions for FREE Help !
Ask
    Micromax's Avatar
    Micromax Posts: 22, Reputation: 1
    New Member
     
    #1

    Mar 17, 2011, 03:35 PM
    Can more than 1 user use an .mdb file at a time?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Mar 17, 2011, 03:50 PM

    By using it. Access by default is set up as a multi-user platform. If the Access app is stored on a network share, multiple users can open it simultaneously. Nothing more needs to be done, but more should be done.

    EVERY access app that will be used by more than one user should be split into a back end (the tables) and a front end (everything else). The back end goes on the network share and the front ends are stored locally on the users computers. Access includes a Splitter wizard that will create the back end for you and create the links in the front end.
    Micromax's Avatar
    Micromax Posts: 22, Reputation: 1
    New Member
     
    #3

    Mar 17, 2011, 04:02 PM
    Comment on ScottGem's post
    Hi Scott. Nice to hear from you and thanks for replying. I haven't used the splitter thus far. I guess If people are not on a network and I split the database, I'm assuming I can tell prospects that the database.mdb file, is allowed on a multi-user level. If I understand this correctly, the buyer needs not to worry about anything once the database is in their possession, because I would split the database from my end. Hope I'm right?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Mar 17, 2011, 04:06 PM

    If you are creating a database for sale to someone else it also NEEDS to be split. Its OK to not split it during development, but before you start user testing it needs to be split. And ESPECIALLY before it goes into production.

    You may need to support or enhance it. Working with a split database makes it easy for you to work on it and then send the user a new front end so they can co9ntinue to use it and store their data.
    Micromax's Avatar
    Micromax Posts: 22, Reputation: 1
    New Member
     
    #5

    Mar 18, 2011, 04:36 PM
    Comment on ScottGem's post
    Thanks again Scott. I won't be supporting it. It sounds bad, but it will be sold as is. I hope If I split it and test it, that will be the final test. I would have to use a Delete Query and reset the autonumber fields back null. I have this Menu Manger Add on from a book I purchased "Access Inside Out 2002" I have to read the instructions about the .mda I'm still not decided if I will go that route. I hope splitting the database is easy on Access. I saw the code on Northwind where it uses a Public Function for forms. I'm not very Visual basi oriented and it's a hit and miss type of programming I'm doing with code that is available. I'm scared a little bit, but I hope this databsae works properly on other computers from Access 2002 and up. Why am I telling you this? You would be my go to guy, for a fee(your fee) if you wanted to review the database before I can distribute it. No obligations on your part. I know you know Access and VB . Better than myself.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Which user is locking an excel file [ 2 Answers ]

Hi all, Over a TCP/IP Network or other Microsoft similar networks, Is there any utility or a way to find who is using or locking an excel file? Much appreciated Joe

How to convert mdb file to exe file [ 4 Answers ]

How to convert MS office Xp Access mdb into an exe file

First time user [ 2 Answers ]

I'm a finance major working for a large investment firm who are the individuals answering questions from and are they in the profession.

First time clomid user [ 1 Answers ]

I have been trying to get pregnant for over 1 year so my doctor has put me on clomid because my body will not ovulate. I was just wondering what the success rate is? And does it increase my chances of having twins, etc.


View more questions Search