Access isn't really multiuser

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #350,102 by beepster 11/3/11 5:48:41 PM Reply	Access isn't really multiuser You can have multiple ppl accessing single tables...but it doesn't handle concurrent use well. Sure, understanding today's complex world of the future is a little like having bees live in your head. But...there they are.
Post #350,132 by crazy 11/4/11 7:28:11 AM Reply	Doesn't it have SOME piss poor locking? I seem to recall when our Access database use hit 3 or 4 people, we then had to push the tables out to SQL server and rewrite the access (fake sql->real sql) code. But this was years ago, and someone else's project.
Post #350,134 by drook 11/4/11 10:00:46 AM Reply	That's still a good use for it If you put Access on the desktop with read access to SQL Server tables, it's great for letting people do their own ad-hoc reporting. You can give write access, too, but you start getting back into the concurrency issues ... which are still not as bad as just sharing the .mdb. -- Drew

MS Access question - (jbrabeck) - (10) - Nov. 3, 2011, 12:32:07 PM EDT

No personal experience. - (Another Scott) - Nov. 3, 2011, 04:32:21 PM EDT

Access isn't really multiuser - (beepster) - (2) - Nov. 3, 2011, 05:48:41 PM EDT

Doesn't it have SOME piss poor locking? - (crazy) - (1) - Nov. 4, 2011, 07:28:11 AM EDT

That's still a good use for it - (drook) - Nov. 4, 2011, 10:00:46 AM EDT

Re: MS Access question - (altmann) - (2) - Nov. 3, 2011, 05:56:21 PM EDT

3 is the way - (scoenye) - (1) - Nov. 3, 2011, 09:16:14 PM EDT

Yep - (malraux) - Nov. 3, 2011, 10:24:35 PM EDT

Haven't played with Access in a long time - (S1mon_Jester) - Nov. 3, 2011, 07:48:42 PM EDT

Using temp tables - (jay) - Nov. 3, 2011, 10:35:51 PM EDT

Additional information - (jbrabeck) - Nov. 4, 2011, 07:46:06 AM EDT

Opportunities are rarely good news.
46 ms