Crashing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey
So Ive designed a data base for the company that I work for
I have a section for work orders a section for service calls and reports on each..
I think it has gotten very complex. Unfortunatly I am new to access.. and although I was capable of making a alrge data base that imports data into the system and then scrubs data, I find I am stumped.
It works fine for me..It works fine for about 4-5 people..after that I loose control..Meaning I dont know whats crashing it
Its getting frustrating. 1 person yells out its crashed again.. Its giving me issues with people having it locked and so on
The I get it needs to be repaired..
Do I have to create user IDs for it or something. I need 20 people to have a consistant access up dating work orders and service calls as we take phone calls...
Any ideas
Email me if you can help..
thank
 
Did you split it? Does each user have the front-end on their desktop?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

DARYL said:
Hey,
So Ive designed a data base for the company that I work for.
I have a section for work orders a section for service calls and reports on each...
I think it has gotten very complex. Unfortunatly I am new to access.. and
Click to expand...
although I was capable of making a alrge data base that imports data into
the system and then scrubs data, I find I am stumped..
It works fine for me..It works fine for about 4-5 people..after that I
Click to expand...
loose control..Meaning I dont know whats crashing it.
Its getting frustrating. 1 person yells out its crashed again.. Its giving
Click to expand...
me issues with people having it locked and so on.
The I get it needs to be repaired...
Do I have to create user IDs for it or something. I need 20 people to
Click to expand...
have a consistant access up dating work orders and service calls as we take
phone calls....
 
Again im new to it.
Ive had a week to learn it and impliment something..Not much time I know.
So I have 3 main forms all linked to the same tables.example installer names installer numbers and say amount of work they can do
It can calculate these totals as well for the day letting us now to book for another day
BUt what I have done is created a sub folder to hold the data base and created a short cut to it
Every one has dragged a short cut to their desk tops.
Does that help
How it works..
Info is imported in from excel..not linked..The excel data is in the sub folder with the data base
1 for work orders 1 for service calls
Then another report for outstanding scrubs with the info in the data marking all that is dup as complete.
then its updated through another form.
hopw this helps.
 
So everything is all in one file? That's likely your problem...you need to
use the database splitter to put the tables in one database(back-end) and
everything else in another(front-end), then connect the two. Each user gets
their own copy of the FE on their local machine.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Daryl said:
Again im new to it..
Ive had a week to learn it and impliment something..Not much time I know..
So I have 3 main forms all linked to the same tables.example installer
Click to expand...
names installer numbers and say amount of work they can do.
It can calculate these totals as well for the day letting us now to book for another day.
BUt what I have done is created a sub folder to hold the data base and created a short cut to it.
Every one has dragged a short cut to their desk tops..
Does that help?
How it works...
Info is imported in from excel..not linked..The excel data is in the sub folder with the data base.
1 for work orders 1 for service calls.
Then another report for outstanding scrubs with the info in the data
Click to expand...
marking all that is dup as complete..
 
 
Back
Top