Multiple DataBase working on Local Network

[capsula4]

Hi! I work at a company where a same DB is being opened by more than one user, is there any way to allow many users be working on a same DB?

Actually I cannot even open it if its already opened. It appears another file with a "lock", which seems to be protecting the DB.

 

[boblarson]

For multiple users, you should be using a split (Frontend/Backend) database where the backend is on the network file server and each user has a copy of the frontend on their OWN computer.

Check out this post for more info about that:
http://www.access-programmers.co.uk/forums/showpost.php?p=660591&postcount=11

 

[capsula4]

Thank you bob!!

I've been reading a bit of everything but I have a lil doubt.

Once the db is divided, when I modify/add data in a form in the FE, is it automatically stored in the BE?

-------------------

Another big problem I found is that I have 3 tables with 1-many relationship.

TRANSACTION
_'-CONTAINERS
___'-PRODUCTS

I was using an auto-generated form by MS Access. This form included kind of a table inside of it showing containers->products like in the image i'm attaching.

The problem is that once divided, I see the table but not the "plus" icon, so I can't add products (tho I can add containers). In the image, I don't see the "red crossed" part.

 

[boblarson]

Once you have it divided you should be able to use the FILE > GET EXTERNAL DATA > LINK TABLES to link back to the backend if all of the tables aren't already linked. This should allow you to enter data. But, as for your other subform and datasheet, you may need to set up the relationships in the backend if they aren't already there. Plus the linked tables may not all be there, so just check to see.

 

[capsula4]

Thank you a lot bob!

But I gotta say...

I have the backend file where I have the tables with its relationships (i tried autoform and worked okay).

I have the frontend file where I have everything except tables, where I see this old autoform and can't expand information. I tried using the option you told me, I see the table relationships but the form still doesn't allow me to expand information.

I tried to make a new autoform in the FE file, but it's even worse since I can't even add "containers". I'm attaching my actual DB, it's in Spanish... but may be better for you to understand my problem probably...

 

[capsula4]

I couldn't really make it work with autoform, although I could make a new form using the wizard that MS Access features and now works okay.