Database

[MissyWen]

Hi,
Im creating a database but really need to know if two people can enter information on the database at the same time without conflict. Common sense tells me this is probably not possible, but is there a way two people can share the same database and extract information as contacts are being entered?

Im using Windows 7 OS - Access 2010

Thanks...

 

[bob fitz]

Hi,
Im creating a database but really need to know if two people can enter information on the database at the same time without conflict. ...

Yes this can be done.

Common sense tells me this is probably not possible, but is there a way two people can share the same database and extract information as contacts are being entered?

Yes this can be done.

The db would need to be split into a back end and a front end.
There would be only one back end which holds the tables. this would need to be in a shared folder on the network.
Each user would have a copy of the front end on thier machine. The front ends contain everything (queries, forms, reports etc) except the tables. Each front end would be linked to the tables in the back end.

This kind of setup is often used.
There are countless posts in this and other forums about this.

 

[MissyWen]

Thanks for this. I've been trying to work it out and then realised there must be a forum. I'll work on it. Many thanks - and I'll check out other forums too.
Cheers.

 

[Catalina]

Check other forums, but this one is the best.

 

[bob fitz]

Let us know when you need further help.