share access file

[kes]

hi,

I'm using access 2010. how should I share the access file I created that will be the best way?
there are 20 users that need to add/edit/view the data.
I read in some places that I need to do share on options and some said that I need to split the file to data and front file.
what is the right way?

 

[hkimpact]

With all the possible chances of corruption I choose to split my databases into a Front End and Back End.

Does your company have a terminal server?

 

[Rx_]

http://office.microsoft.com/en-in/access-help/split-an-access-database-HA010342026.aspx

Also search the access-programmers with Split - you will find a lot of discussion.
With 20 users - yes - it is something that needs to be done. (would argue 2 users justify it). If you have Terminal Server or Citrix - it get even better. But, TS/Citrix is not discussed by Microsoft because it might work better than the dot net version they try to sell. Read the article linked above - then ask questions. You are not the first to ask about this.

One Database on the back end (no forms).
Then each client (user) runs a personal copy of the version with the forms. Basically, use linked tables to the back end.
My back end is SQL Server. But, Access works great.

 

[boblarson]

Something good to read regarding this.
http://www.kallal.ca/Articles/split/index.htm