Slow when people using Database (Microsoft Access 2007)

[Nikki]

Hi,

I create company database by using Microsoft Access 2007. I have splited our
database to be back end and front end database. We have 4 computers that link
together (all computers can share data or files together) and I put the back
end in my computer (my public folder) and the front end to each computers (in
document folder). The problem is when people try to access the database,
sometimes it takes so long or the whole database gets freeze. I'm not sure
that I suppose to have a web server or reset networking. Is there anyways
that people can access the database at the same time? Please advise what I
should do.

Thanks for your kind help.

 

[Damon Heron]

Under Access Options, Advanced, do you have the db set to "shared"?

Damon

 

[Gina Whipp]

Nikki,

So what you are sying is YOUR computer is acting as the Server, while you
are also working on your computer. Yes, this is going to be slow to the
other users. Is there no network/server to put the back-end on? If there
is no 'real' Server then expect slowness. Of course, make sure you have
AutoNameCorrect unchecked and the each table has the Subsatasheet set no
[None] AND your using queries on forms to only pull the data you need and
not open the entire table. However, short of getting a stand-alone machine
to act as the Server I belive slowness is going to be part of the program.

As for accessing at the same time, make sure you have your database set to
'Shared'.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Nikki]

Thanks Gina and Damon. Yes, it seems like my computer has set as a server for
database. We are a small business. My husband set networking himself and I
did database myself. We're not computer guru (we're just beginners and try to
save our cost as much as we can). How do I set my database to Shared? and for
the server. I don't know much about it. Should I have another computer and
set it as a server or should I use web server to do it--Please advise.

Thanks,
--
Nikki

Nikki,

So what you are sying is YOUR computer is acting as the Server, while you
are also working on your computer. Yes, this is going to be slow to the
other users. Is there no network/server to put the back-end on? If there
is no 'real' Server then expect slowness. Of course, make sure you have
AutoNameCorrect unchecked and the each table has the Subsatasheet set no
[None] AND your using queries on forms to only pull the data you need and
not open the entire table. However, short of getting a stand-alone machine
to act as the Server I belive slowness is going to be part of the program.

As for accessing at the same time, make sure you have your database set to
'Shared'.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I create company database by using Microsoft Access 2007. I have splited
our
database to be back end and front end database. We have 4 computers that
link
together (all computers can share data or files together) and I put the
back
end in my computer (my public folder) and the front end to each computers
(in
document folder). The problem is when people try to access the database,
sometimes it takes so long or the whole database gets freeze. I'm not sure
that I suppose to have a web server or reset networking. Is there anyways
that people can access the database at the same time? Please advise what I
should do.

Thanks for your kind help.

 

[Gina Whipp]

Nikki,

To set your database to Shared...

1. Open your database
2. Go the Options button (the big button upper left hand corner)
3. From the selection on the left click Advanced
4. Set the Default Open Mode to Shared

You would not use a web server for your server. For what a server is and
does take a look ... http://en.wikipedia.org/wiki/Server_(computing)


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks Gina and Damon. Yes, it seems like my computer has set as a server
for
database. We are a small business. My husband set networking himself and I
did database myself. We're not computer guru (we're just beginners and try
to
save our cost as much as we can). How do I set my database to Shared? and
for
the server. I don't know much about it. Should I have another computer and
set it as a server or should I use web server to do it--Please advise.

Thanks,
--
Nikki

Nikki,

So what you are sying is YOUR computer is acting as the Server, while you
are also working on your computer. Yes, this is going to be slow to the
other users. Is there no network/server to put the back-end on? If
there
is no 'real' Server then expect slowness. Of course, make sure you have
AutoNameCorrect unchecked and the each table has the Subsatasheet set no
[None] AND your using queries on forms to only pull the data you need and
not open the entire table. However, short of getting a stand-alone
machine
to act as the Server I belive slowness is going to be part of the
program.

As for accessing at the same time, make sure you have your database set
to
'Shared'.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I create company database by using Microsoft Access 2007. I have
splited
our
database to be back end and front end database. We have 4 computers
that
link
together (all computers can share data or files together) and I put the
back
end in my computer (my public folder) and the front end to each
computers
(in
document folder). The problem is when people try to access the
database,
sometimes it takes so long or the whole database gets freeze. I'm not
sure
that I suppose to have a web server or reset networking. Is there
anyways
that people can access the database at the same time? Please advise
what I
should do.

Thanks for your kind help.

 

[Albert D. Kallal]

The list of things to check is here:

http://www.granite.ab.ca/access/performancefaq.htm

The above link is for previous versions of access (But still applies to
access 2007). As you work your way through and find what fixed a performance
issue, then post back here so people in the future can also benefit and
learn what was actually slowed your application down....

I also not sure why several other people have added comments here to the
effect that you need to enable sharing, as it is obvious that you do have
sharing and have a correct setup for multiple users. You issue you seem to
have is that of slow performance.

 

[Gina Whipp]

Albert,

The sharing came into view because of her first posting/question. It wasn't
clear as to whether there was a sharing issue a performance issue or both.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Denise]

Gina wrote: make sure you have each table has the Subdatasheet set no [None]

Where do I find that setting option in Access 2007? I've looked and can't
find it. Thanks.
Denise

Nikki,

So what you are sying is YOUR computer is acting as the Server, while you
are also working on your computer. Yes, this is going to be slow to the
other users. Is there no network/server to put the back-end on? If there
is no 'real' Server then expect slowness. Of course, make sure you have
AutoNameCorrect unchecked and the each table has the Subsatasheet set no
[None] AND your using queries on forms to only pull the data you need and
not open the entire table. However, short of getting a stand-alone machine
to act as the Server I belive slowness is going to be part of the program.

As for accessing at the same time, make sure you have your database set to
'Shared'.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I create company database by using Microsoft Access 2007. I have splited
our
database to be back end and front end database. We have 4 computers that
link
together (all computers can share data or files together) and I put the
back
end in my computer (my public folder) and the front end to each computers
(in
document folder). The problem is when people try to access the database,
sometimes it takes so long or the whole database gets freeze. I'm not sure
that I suppose to have a web server or reset networking. Is there anyways
that people can access the database at the same time? Please advise what I
should do.

Thanks for your kind help.

 

[Tony Toews [MVP]]

Gina wrote: make sure you have each table has the Subdatasheet set no [None]

Where do I find that setting option in Access 2007? I've looked and can't
find it. Thanks.

See the Subdatasheet Name property set to [Auto] at
http://www.granite.ab.ca/access/performancefaq.htm for links to KB
articles with code.

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/