Edit .accdb from multiple workstations

30 pts.
Tags:
Access Database
Microsoft Access
Microsoft Access 2007
Microsoft 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • msi77
    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.
    1,660 pointsBadges:
    report
  • SbElectric
    Sorry big typo. You do NOT need a SQL server but rather you need a server where other persons have access. SbElectric
    2,540 pointsBadges:
    report
  • Tdizzle342
    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 ??
    30 pointsBadges:
    report
  • msi77
    > 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.
    1,660 pointsBadges:
    report
  • SbElectric
    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
    2,540 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following