Home > IT Answers > Microsoft Windows > Edit .accdb from multiple workstations
Tdizzle342
30 pts.
 Edit .accdb from multiple workstations
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2
How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp Sp2 machine ?

Software/Hardware used:
Windows XP SP2
ASKED: December 6, 2009  3:14 AM
UPDATED: December 12, 2009  1:27 AM
RELATED QUESTIONS
Answer Wiki:
You do need a SQL server but rather you need a server where other persons have access. Then just place the Access database on that server. You can also set the options of Read/Write/Update authority for individual people who will be accessing this database. Hope I followed your question, if not please provide more details. SbElectric
Last Wiki Answer Submitted:  December 8, 2009  4:01 am  by  SbElectric   2,510 pts.
All Answer Wiki Contributors:  SbElectric   2,510 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You only need to separate tables from interface and place these on the shared drive.
Interface file must use linked tables. Use master in access to do that.

msi77
 1,610 pts.
 

Sorry big typo.

You do NOT need a SQL server but rather you need a server where other persons have access.
SbElectric

SbElectric
 2,510 pts.
 

The way i have it right now is just the .accdb file shared in workgroup. I opened the file on computer “A” and opened the same file on computer “B” tried inputing data on both at the same time and worked perfectly fine. If I continue to do this will there be any data corruption there only a max of 3 users inputting data at the same time. I don’t wanna split the table cause there nothing being changed for design just data entry. So will I be ok to keep doing what im doing ??

Tdizzle342
 30 pts.
 

> I don’t wanna split the table cause there nothing being changed for design just data entry.

This does not change design. Simply try it.

msi77
 1,610 pts.
 

Yes, you should be fine in this shared environment. The Access internal systems will ensure that only one person is updating the field. If more than one people are trying to update the same field then the system will automatically prevent it.
Be sure to take back up as needed — at least every day.

SbElectric

SbElectric
 2,510 pts.