Access 2007

[krishnanhemanth]

Hi
Can access 2007 database be used on a multi system.
Like in a small manufacturing unit with varios departments
If the database is on a single system, can users on different system on the same network have access to read,modify or enter data
Please help me on this
Thanks in advance

 

[pbaldy]

Sure; split the application:

http://granite.ab.ca/access/splitapp/index.htm

 

[gemma-the-husky]

access is really powerful - depending on the number of concurrent users however, and what they are doing, it can start to underperform - hard to be precise, but something like 10-15 users active is about the practical limit - if you use a JET (native access backend)

good system design can help

 

[oumahexi]

I like to install a runtime version of the fe on users' machines and limit their access through their user accounts.

Hope this helps.

 

[krishnanhemanth]

thank you for your tips and time.
could you please tell me how am i suppose to make the database multiuser
what i mean is
should i install the database on all the systems
is it ok if all the system has xp as their os or should it be server based

 

[pbaldy]

I guess you didn't read the link?

Yes (the front end) and yes.

 

[oumahexi]

I guess you didn't read the link?

Yes (the front end) and yes.

I did, and thought it was brilliant, thank you very much.

 

[krishnanhemanth]

thanks
that link was very informative

 

[shadow9449]

...hard to be precise, but something like 10-15 users active is about the practical limit - if you use a JET (native access backend)

I've read this before but I do want to state that I have a system with about 23 users on a LAN and it's been working perfectly for about 3 years now. It's a pretty complex application with about 100 forms and equal number of tables.

Same application has been deployed for a group of about 45 -50 people in 10 locations using a server with Terminal Services. I've logged in myself and used the system with 40 others and the performance is excellent. I've read people claim to have over 100 users this way but I've never tried it myself.

So, I guess it depends on the server and LAN environment. I'm not sure. I just know what I've experienced.

Cheers

SHADOW