I am not familiar with what features are available
with access to solve this problem. Basically here's the scenario, once my database is completed it will be stored in a central desktop. I'll also have a copy in my laptop and my partner will have a copy in his laptop. A client calls us, we open up the access database, we fill out a form. The form creates a record but that record is only on our separate laptop. We need away to combine the records to one database.
I suppose we could save each record on our own laptop and then transfer it to the central desktop and save it in the database on that desktop afterwards; however, problem with that is we have to constantly copy that database into our individual laptop to have the latest copy of the database.
Is there a better solution?
In an ideal world, we make the access run off the desktop (central computer) and we access that computer's information, therefore the database is always updated and accurate but in our case, I we have a few limitations as far as doing something like that.
Any ideas?
with access to solve this problem. Basically here's the scenario, once my database is completed it will be stored in a central desktop. I'll also have a copy in my laptop and my partner will have a copy in his laptop. A client calls us, we open up the access database, we fill out a form. The form creates a record but that record is only on our separate laptop. We need away to combine the records to one database.
I suppose we could save each record on our own laptop and then transfer it to the central desktop and save it in the database on that desktop afterwards; however, problem with that is we have to constantly copy that database into our individual laptop to have the latest copy of the database.
Is there a better solution?
In an ideal world, we make the access run off the desktop (central computer) and we access that computer's information, therefore the database is always updated and accurate but in our case, I we have a few limitations as far as doing something like that.
Any ideas?