How to Split an Access Database: Two Methods

[@sad9008]

This was the BEST video on splitting databases! Thank you!

[@shaileshnagpure817]

Thanks champ for keeping it simple and easy to understand..

[@amjithat]

Thanks for the information . But when i split data bases there come an error saying "cannot lock file as this is used by other program or user" i have got an excel power pivot running from my data base on network. I really need to split data base as we are moving to cloud - one drive - Could you pls help with this...

[@lisacalhoun306]

Super helpful! Thanks. I appreciate the explanation at the beginning as well.

[@KeffelewAssefa]

Thank you

[@gregheyman7368]

I have a problem where my users seem to be mapped differently so its not working as easily as its portrayed. Is there a way to do this when peoples PCs are mapped differently?

[@information88info]

Liked, commented and subscribed. Best ever.

[@22illingworth]

This is the answer to my dreams. One question, I have a main switchboard design which I navigate to different features and reports. When I try to split the database I get an error saying "Switchboard is still running" How can I get round this?

[@df4250]

What syntax would be needed to specify the path for a linked back end, if the back end is filed in (say) \\server\Backend (which is effectively my main computer's G: drive)? For example, if I have a G: drive (connected to my main computer) which directly holds the back end and I would like the front end on another computer on the network to access that back end - what would be the syntax for the path for the linked tables, both for the other computers as well as my main computer? Would it be necessary to map the \\server\Backend on the other computers?

[@abdelhaq975]

thank you very much

[@Bhaiagtech]

Hello, This is very Usefull Thank you so much sir!!!!

[@harisrg92]

Hi, What would happen if multiple people are using the same form. And if that form has multiple subforms as well. I am wondering how would the application behave if users are simply hovering over the records or one of them is editing it a record. I am assuming, I would have to be cautious in my programming to handle that kind of situation. But I can't find any guide which explains thoroughly how to manage record sets, which mode to use to open those recordsets . Can you recommend a guide ?

[@Accessjitsu]

If multiple users can use same form, and thus edit the same table at the same time, you need to deal with record locking. I would suggest record level locking. Under Access Options > Current Database > Client Settings you can set this value to no locks, all records or edited record. Edit record will lock a record once a user starts editing it, and will not allow another user to edit that record until the first user is finished. You can take a look at the error numbers the users might get on record lock errors to display a more friendly error message (the one Microsoft shows is a little cryptic).

[@konehotelsroblox6507]

Access Jitsu hello sir I am curious if you can split the form and take the data table and put it in nother form

[@syriacas]

Great video!

[@francinefranklin2120]

My database is on a network computer should I split it while its in the original folder and then move front end to employees computers?

[@Accessjitsu]

+Francine Franklin In my experience, the users will have faster response times from the application if you do that. I would only leave it as a combined database if you only have a few users concurrently using it.

[@francinefranklin2120]

+Access Jitsu I developed the database I have from a seminar and it works great but we now have 10 users and the database is getting really slow plus last week had a big crash thank god for backups! I did split he way you suggest and everything works great except the OLE objects that are linked to it where we scan in documents PDF and link them to the workorder file. I can add new PDF's to the file but the ones there it shows it can find the file. They are in a different folder on the network. Any help would be greatly appreciated!

[@Accessjitsu]

+Francine Franklin For the speed. Make sure you are compacting and repairing the backend every now and then. I don't understand how the PDFs are being stored. Are they embedded in a table as an object or are you storing the path to a set of folders and files? Did something related to the PDFs move when you split? Do you need to perform some sort of conversion to point to a new location for the PDFs? I would store any common files on the server with the backend.

[@francinefranklin2120]

I storing the path to a folder on the network. That's where the database is now in its own folder. I will try to split database where it is now and put front end on each workers computer and use the link manager and see if that works. It must be breaking the link for the pdf . In my workorder table it shows as acrobat document. In the form its a OLE bound. Thank you for your time! Its really hard to find local people that knows anything about Access.

[@Mary.Eliza.]

Francine Franklin my database gives me an error out of range

[@pacw1955]

how much can a backend database hold please?

[@Accessjitsu]

Microsoft says 2 GB.