Networking issues?

[Dossy]

Hey guys,
This database is going to give me the shits eventually. I have to look
at different ways to implement this accross the company network. As it
stands, the access database needs to be accessed by approximately, 6-8
users... just those in our department.

I tried to deploy it accross the network, leaving a back end in our
T:\SharedServices\LNAP folder... and leaving the front-end on the
local machine. It was unbearibly slow... it just didn't function. I
have the main form refreshing its data every 10000 intervals.. which,
at the end of the day has to happen.

I have tried making an MDE file, but access doesn't let me do it for
some reason?....

As it stands i do not have any forms that are bound by any table... i
use "currentdb.openrecordset("SELECT ...." to find the records for the
given data-set.

Are there are any suggestions as to how I could improve drastically
its speed?... i believe it may have to do something with my coding...
inevitably, i think i may be establishing a connection with every
openrecordset -- that said, i am completely oblivious as to how i can
make it faster. If anybody has any suggestions that would be greatly
appreciated... if somebody wants to take a look at the db you can get
me on ap***@tpg.com.au
Cheers!

[Deano]

Dossy wrote:

Hey guys,
This database is going to give me the shits eventually. I have to look
at different ways to implement this accross the company network. As it
stands, the access database needs to be accessed by approximately, 6-8
users... just those in our department.

I tried to deploy it accross the network, leaving a back end in our
T:\SharedServices\LNAP folder... and leaving the front-end on the
local machine. It was unbearibly slow... it just didn't function. I
have the main form refreshing its data every 10000 intervals.. which,
at the end of the day has to happen.

I have tried making an MDE file, but access doesn't let me do it for
some reason?....

There's a good link to a webpage containing advice re network issues though
i don't have it to hand - someone else will post it I'm sure.

What happened with the MDE though? That sounds interesting. Make sure your
app compiles ok then you should be able to create an MDE.

[Tony Toews]

ap***@tpg.com.au (Dossy) wrote:

I tried to deploy it accross the network, leaving a back end in our
T:\SharedServices\LNAP folder... and leaving the front-end on the
local machine. It was unbearibly slow... it just didn't function. I
have the main form refreshing its data every 10000 intervals.. which,
at the end of the day has to happen.
The three most common performance problems in Access 2000 or newer are:
- LDB locking which a persistent recordset connection or an always open bound form
corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

For more information on these, less likely causes, other tips and links to MS KB
articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
I have tried making an MDE file, but access doesn't let me do it for
some reason?....

If A97 then Ctrl+G to open the debug window >> Debug >> Compile and Save All Modules.
If A2000 or newer then Ctrl+G to open the immediate window >> Debug >> Compile.
Fix any errors which pop up.

While unlikely you may have a reference to an MDB which aren't allowed from an MDE.
You must make an MDE out of the referenced MDB and reference it.

Finally it is possible you have some corrupted VBA. In which case make a backup
first and then try the decompile command as documented at
http://www.granite.ab.ca/access/decompile.htm

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