Access 2000

[judith]

I recently had a problem with a database loosing its focus. The data sits on
the server and the front ends sit in the users personal folder on the server.
The data was restored and then some front ends but not all were missing some
pieces of information although the data was OK in the data file. So a screen
showing address and tel number was missing the tel number, although other
people could see it OK and it was fine in the data file. Copying over a new
copy of the front end seemed to solve the problem but I would really like to
know what happened and how to avoid this in the future.
While all the machines run 2000 a couple of laptops have been added to the
system with Vista and Access 2007 although they normally log on remotely, is
this an issue

Could you also please tell me how many concurrent users Access 2000 supports
comfortably and is the number increased if i move to 2007

Thanks

 

[Jerry Whittle]

Same max number of concurrent users in 2000 and 2007 - 255. The 'real' number
of users is around 10% of that and depends a lot on how well the database was
designed. Note: This is the number actually in the database at the same time
actively using it.

Are the laptops wired into the network or using a wireless connection?
Access doesn't play well with wireless.

Except if using something like Terminal Services, the FE should be on the
end user's computer and not out on the server. You are missing out on one of
the best reasons for splitting the database. With the forms, reports, etc.,
on the computer, the network only needs to move the data and not everything
else when create a report for example.

Could the problem FE's been linked to the wrong BE? I've seen that before.

It's possible that the problem FE's were corrupt. The new FE fixed it.

 

[judith]

The remote machines log on through terminal services so the FE sits on the
server in the users My docs.

I am getting the idea that the FE for normal networked machines should be
physically on the user machine and not in their My Docs on the server. I can
see your point that it is only then the data that is moving. Thanks for this