Error on using MS Access 2003

W

William

Hi, in my office, there is a backend database to store our data and a
frontend database contains queries, tables, forms, macros and VB scripts that
let the users use about 6 applications involving filter data, print
documents, create or edit record, etc.

However, in recently, the Access is down from one day to couple of days.

The error can be divide into two types, some users can partially use the
applications; some users cannot open the Access database template; and some
users can work normally.

There are about 30-40 users to use this Access Tempate (frontend)
application and this is placed on a server to share.

I am wondering the problem is cased by:

1. Office version difference (SP1, SP2....)
2. Server problem
3. Setup problem
4. VB script unclean
 
J

Jeanette Cunningham

Hi William,
it sounds as if everyone uses the same frontend. If this is how you have it
set up, you will need to supply every user with their own separate copy of
the frontend. This is a common issue discussed on this newsgroup. You can do
a search on this topic and find lots of posts and lots of answers.

Jeanette Cunningham
 
W

William

Then is it means that if everyone create/copy a frontend template onto their
local desktop and link with the backend database where placed on the server,
the problem would be solved?

And I hear that MS Access can only allow 10 people to read or write at the
same time, is this true?
 
B

boblarson

William:

Yes, you should have a split frontend/backend with the backend on the file
server and a copy of the frontend on every person's computer. That should
take care of your problem and you should be fine even for concurrent users.

Now, if you don't want to manually copy frontends to everyone every time you
make a change to the frontend master, you can check out making your frontend
"auto updating" and I have a free tool on my website which will let you
enable your frontend to do auto updating. In other words when you make a
change to your frontend you would change version numbers in the frontend
master and the backend and then when anyone opened up their frontend they
would get a message saying that their frontend is out of date and it would
close, delete the old file, copy the new frontend to their computer and then
reopen automatically.

You can find the tool here:

http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx

and be sure to download the documentation too and follow the directions
carefully.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
 
T

Tony Toews [MVP]

William said:
Then is it means that if everyone create/copy a frontend template onto their
local desktop and link with the backend database where placed on the server,
the problem would be solved?

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.
And I hear that MS Access can only allow 10 people to read or write at the
same time, is this true?

Wrong. Theoretically up to 255. Realistically 20 to 40 doing updates
maybe more. But your network has to be very stable. Access is the
proverbial canary in a coal mine and is very sensitive to network
issues.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
T

Tony Toews [MVP]

William said:
Hi, in my office, there is a backend database to store our data and a
frontend database contains queries, tables, forms, macros and VB scripts that

Actually that's VBA code and not VB scripts. Minor but significant
difference.
However, in recently, the Access is down from one day to couple of days.

Hmm, let me guess. New server?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
W

William

Um.. The server is not new and also the Access template is not new.

The template has been updated to add more applcaition to the users since
Sep. However, in the mid Nov and Dec, the Access down for a day (auto recover
after one day) in Nov and still down (cannot recover, down for serveral days).

Some users can enter and use normally while some can partially use and some
cannot enter the Access. The error messages prompt out would be "Microsoft
Access has encounted a problem, Please close the program" and the two buttons
for send / not send the error report to Microsoft.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top