Excel To Access S’abonner

0
Avatar
Legacy Poster

Our company is currently using Excel as a database for Bartender, which is installed at a few PC's. The boss says he wants to be able to edit documents for everyone and save them to a central location. So we are migrating to Access. Apparently, with Access you can split it, create a front end, distribute it to eveyone with Bartender, and have a copy as a back end, put it on the server, and you can acheve the goal of having multiple users access and modify the file at the same time and have their changes saved as well.

When I tried this, I could not get Bartender to see the front end's database, which I had named 'UPC'

If I used the file for the backend it could see it fine. Is there something else I can do to try to make it so multiple users can edit a database and save changes at the same time? Is there some reason the Access database front end table does not show up?

 

Thanks

3 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Does Bartender not work with split Access databases designed to be used on a network? Should I manually try to split the database? Are there any suggustions for a network database I can try that works with bartender and allows real time updating between multiple users simultaneously?

0
Avatar
Sarkis Agasarkisian
Actions pour les commentaires Permalien

I'm using quickbooks POS 18. I exported the item files to Excel to make jewelry bar cod tags. With Bartender I did connect to quickbooks files but I couldn't do anything with it. I need help with this. Will appreciate if any one will help me with is. We are Jewelry Manufacturing company and this is very important. My phone number is 678 886 0175.  

0
Avatar
Peter Thane
Actions pour les commentaires Permalien

This may help

https://support.seagullscientific.com/hc/en-us/articles/204770598-Getting-started-with-database-connections-Video-5-20-

If you are using an older version of BarTender (not v2019) then you can sometimes encounter ODBC errors due the Microsoft driver that has to be used to form the connection between BarTender and an Excel document. If you are getting these these then the likely cause is that the is a "bit" incompatibility between the two pieces of software as they both need to be either 32 or both 64 bit as the ODBC driver will not allow a mismatch. 

One other thing to note is to make sure the Excel file is closed when BarTender tries to read from it as Excel will only allow one person to access the file at a time and BarTender counts as a "person". 

Vous devez vous connecter pour laisser un commentaire.