How do I share a database

[dinadvani via AccessMonster.com]

Hi All,

I have a database which I want to share with my collegues.

My first question is how do I make a database as shared database?

Second - My office collegue is in US and I am in India. How can make it
shared so that all the details entered by him is visible to me and vice versa.


Please let me know if this is possible.

Any help would be appreciated.

Thanks,
DA

 

[Albert D. Kallal]

Hi All,

I have a database which I want to share with my collegues.

It depends on where they are? By sharing, do perhaps you mean to email them
a copy to use?

My first question is how do I make a database as shared database?

ms-access databases are multi-user ready right out of the box. However, that
"sharing" is usually limited to your local area network (LAN).

Second - My office collegue is in US and I am in India. How can make it
shared so that all the details entered by him is visible to me and vice
versa.

Now, the above is talking about a WAN (WIDE area network). This is a
considerable different (and more difficult) challenge.

Please let me know if this is possible.

For you LAN, you simply need to split your database. I explain how and why
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

For you WAN, between you and a far away location, then you can read the
folwling article:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[Guest]

Hi dinadvani,

The best way to share a database is to split the file into a back end
containing the data tables and a front end containing everything else. You
can use the database utilities from the tools menu to impliment this split.
Once the application is split, each user has a copy of the front end. Each
copy is linked to the same back end data file. Using this approach each user
can work independantly and share the same data. This will require that all
users have access to the network location of the back end data file.

Where a user does not have access to the network location of the shared data
file, an alternative is the replication facility. Again you can find a
function to facilitate this under the tools menu. However, I recommend
further investigation of replication before implementing this stragegy.

Luck
Jonathan Parminter

 

[dinadvani via AccessMonster.com]

Thanks a lot for your help.

But what I need is a procedure to create security and split database. If you
have any documentation please forward that link to me.

What I need is I have a database in India, I want to grant my collegue in US
some access so that he can add data view some reports just that. And once he
adds data I can view it.

Please provide your inputs on this.

Regards
Dinesh

Hi dinadvani,

The best way to share a database is to split the file into a back end
containing the data tables and a front end containing everything else. You
can use the database utilities from the tools menu to impliment this split.
Once the application is split, each user has a copy of the front end. Each
copy is linked to the same back end data file. Using this approach each user
can work independantly and share the same data. This will require that all
users have access to the network location of the back end data file.

Where a user does not have access to the network location of the shared data
file, an alternative is the replication facility. Again you can find a
function to facilitate this under the tools menu. However, I recommend
further investigation of replication before implementing this stragegy.

Luck
Jonathan Parminter

Hi All,

[quoted text clipped - 11 lines]

Thanks,
DA

 

[John Vinson]

What I need is I have a database in India, I want to grant my collegue in US
some access so that he can add data view some reports just that. And once he
adds data I can view it.

Access databases work well linked over a fast, stable local area
network.

They emphatically do NOT work over the Internet or other lower-speed
connections.

Consider using a terminal server connection (Windows Terminal Server
or Citrix or the like), or implement the application in SQL/Server
with a Web interface. A split database using Access to connect from
India to the US is simply *NOT* feasible.

John W. Vinson[MVP]