database access across domains

[patj]

I am trying to access a centralised database from multiple domains. These sites are content managed and need to be able both to read from and write to the centralised access database.
Any ideas?
Any help would be appreciated.
thanks

 

[BukHix]

Are the connections between the domains all high speed?

 

[patj]

yes, they will probably all be high speed

 

[BukHix]

You should have no problem putting it on a network share then. Just make sure everyone has the correct network permissions. You will want to be careful when allowing more then 10 people at a time connect. Although I have never had that many I hear that Access can get quite slow with that many simultaneous connections so beware. I do regularly share my database with 5 people in two domains with no problems at all.

I should also mention that it is considered "best" practice to split your DB in half putting your back end on the centralized network share and your front end on the local domains of your users.

 

[patj]

thats great!!
could you explain the splitting the database some more and how i would do this. Also if possible the connection string I would use to connect to the database.
thanks