MS ACCESS Database

[msaccess]

Hi all,
For my client I have to create an integrated MS database.But I have no clue.Could you help me plz?

Scenario is:

There is a standalone MS Access sales database on head quarter office and there are 4 sales regional offices.

What I have to do is to develop the database from a standalone system to an integrated system where 4 sales regional offices can do data entry and view the database locally. And also from the head quarter office my manager should be able to do data entry and view the database.

Basically I have to merge the standalone database on head quarter office to 4 regional offices.

Your help will be highly appreciated

thank you in advance



d

 

[DCrake]

Firstly, are the regoinal offices networked to the head office via a WAN or is it remote connections?

What version of Access is the current application written in? and do you have developments rights to it?

Answering these questions can trigger the next step in reaching your goal.

David

 

[msaccess]

Regional offices are connected to the head quarter via WAN.

MS access version is 2007.

Yes I have developments rights to it.

 

[HiTechCoach]

This may be helpful:

Using a wan with ms-access? How fast, how far?

 

[stopher]

This may be helpful:

Using a wan with ms-access? How fast, how far?

Very informative document

 

[HiTechCoach]

Very informative document

Glad to hear you found it useful.

 

[msaccess]

Sharepoint sounds like an easier option, isn't it.

I heard there are limitation with using ms access via sharepoint like users not being able to edit database concurrently etc.

do u have any ideas about these limitation and feedbacks please?