Slow Network Database

Feb 7, 2006

This problem is driving me nuts!!
I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow.
The design has a front end with all the queries, forms etc and a back end on a server containing the tables.
The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network.
The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run.
What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail.
Help please!!

View Replies


ADVERTISEMENT

DB Runs Slow Over Network

Sep 18, 2006

I have a 16Mb DB. The intention is for users to access this over the network without copying onto their local machines.

At present, many of the forms are located on 1 master form and they are all subforms on tabs. There are a lot of calculated control boxes on the forms, and these seem to be very slow to bring back the data over the network whereas on my local machine, the data is displayed in a couple of seconds.

COuld this be sped up somehow? Maybe using queries or other methods?

View 12 Replies View Related

Over Coming Slow Network Speed

Nov 6, 2006

Hello,
I have split a database useing the database spliter wizard. But I still have network speed problems. What I am wondering is if anyone knows if useing an ODBC connection between the front and back ends is more efficient than file sharing across the network?
Thanks for any information on this
Tim

View 4 Replies View Related

Startup Form Very Slow Over Network

Jan 16, 2007

Hi guys. I am stumped with a 45 second delay when I startup my application. I get the delay on networked workstations only when another workstation is up showing the Main "switchboard" form. Each workstation has their own copy of VBA (not compiled) with networked versions having linked tables to the server's .mdb

It seems like the workstations know that the main form is up somewhere else and need to negotiate with it. All have the (Access 2000) Default open mode to Shared, Default record locking to No Locks, and Open database using record-level locking On.
:confused:

View 6 Replies View Related

Linked Tables Running Slow Over Network

Oct 12, 2006

Hi

I have a couple of acces databases running on a peer to peer network (database A and B, which are housed on PC1). The database B has a link to a Customer table in database A. This was running fine until another user on the peer to peer network wanted to use database B on their pc (PC2). I had to change the the file location of the linked table to show it's location on the network so PC2 could open it. Unfortunatley this greatly slowed the operation of the database B on both machines.
If anyone has made it this far - Is there any way round this?

Regards

David

View 3 Replies View Related

Why Is Access Slow On Client Computers Across Wireless Network?

Feb 8, 2006

I have completed a database for a company with 60 000 clients and over 100 000 job records.

The database works at very resonable speeds on the Server computer, or the computer on which I installed the back end of the database.

Each of the other 3 computers on the wireless network, have a local copy of the Front End on their machine, and reference the Back End (BE) on the server computer.

Each of the Client computers have varing speeds when accessing the BE, some as slow as 10 minutes for a simple search, filter or just loading a form.

What can I do to improve performance across the network?

Do I need to install additional components on the other computers to improve the db performance?

Your help will be much appreciated.

Joseph.

View 10 Replies View Related

Slow Database? HELP!

Apr 4, 2006

Hi,

I have a database for booking equipment in and out.

I have the backend stored on a shared drive on our LAN, and the front end on each client machine.

The database has been working fine until just now, it runs very slow and my DCount functions have stopped displaying data.

I have no idea why this has happened, please help?

View 1 Replies View Related

MS Access Database Is Slow

Sep 16, 2006

Hi everybody,
I have an access database which is around 40 MB after compacting it and I feel that it is slow especially when I open cross table form. Is there any way to speedup the databse.
Note: my databse is on the share drive in my work.

View 1 Replies View Related

Database Response Slow

Nov 19, 2007

The database response is significantly slow when our application requests data over a network. Are there any settings to adjust network response? The network is connected via a T1 line.

According to information I've found online, our application is the front end to the database and the database sits open on the server.

View 1 Replies View Related

Database Slow To Open

Jan 17, 2008

I have two databases, one is much larger than the other, but both have the same start up code. The larger database opens quickly, but the smaller database takes forever. I tried compacting and repairing the front end and the back end of the database, but that did not help. Any ideas on how I can speed this up?

View 4 Replies View Related

Database Opening Slow

Sep 23, 2004

My database is opening much slower than normal just over the past few days. When I run a performance analyzer it is telling me that my database is only being compiled in a partial state. How did this happen and what do I do to fix it??

Thanks...

View 2 Replies View Related

Using A Database On A Network

Feb 14, 2006

I have two pc,s hooked up as a workgroup network( no server) I have a database on one of the pc,s and when I open the database in the other pc it says that it is "read only". So I cant enter new records.

How can I resolve this problem??????

Thankyou in advance

View 1 Replies View Related

Network Database

Mar 11, 2006

is there any way to use a same database in a network that if i entered some entery and some body else entered another entery it will show all data entered by every people in everyone's computer ?!

thanks

View 1 Replies View Related

General :: Database Running Slow After Changing To Design View

Dec 14, 2014

I am new to access.

On occasion my access database all of a sudden begins to operate very slowly, I notice the queries take a much longer time to run.

Last week it suddenly began to operate very slowly after idling in excess of 30 mins

Today when I change the screen to design view and then back to form view once again it begins to operate very slowly. (yesterday was working fine on my desktop at home, I have not made any changes to the database with exception to saving and using the file this morning on the shared drive at work) If I shut down and re open it operates well but once again changing to design view causes the same issue. Sometimes compact and repair rectifies sometimes not.

View 1 Replies View Related

Default Parameters Which Slow Down Access Database Linked Tables?

Jun 29, 2012

I recall reading somewhere (fairly recently) about a parameter or property in Access which is "On" by default and allows a form/query to identify when backend table field names or query arguments are changed and automatically looks for and "fixes" the renamed link. By leaving this switched ON, the database is slower than it could be. The db speed performance can be can be improved significantly by switching this 'feature' off. (i.e. Name of the property)

View 3 Replies View Related

Distributing A Database Across A Network

Aug 2, 2005

I have a database built in Office 2000.

The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.

The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.

They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's

I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.

In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?

Many thanks.

View 4 Replies View Related

Speed Of Network Database

Jun 5, 2007

Our office runs on a pretty large Access database (v2003). We are on a large hospital network and have about 15 users for our database. It tends to run VERY, VERY slow. Are there other options?

View 4 Replies View Related

Database On Local Network,need Help

Jan 24, 2005

i have done a database for a library that enables the user to enter the information about the books and search for it, the administrator have the right to enter the info about the books and edit and search the others have more limited rights depending on which group they belong, i used for the connection (currentProject) because i did all the forms and tables in one DB
a friend from this forum told me and i think he s right, that if i want to put it on the network i have to separate the forms and the tables ie save the tables and the queries on another database that i put on the network
i have a problem
1- im not sure how to connect to another database can i do it like this
Dim conDB as ADODB.connection
set conDB=new ADODB.connection
conDB=openDatabase("the path") or not
2-i have done the result form with a record source (search-query) and then inserted the fields into the form in the design view
can i do that with a query if it was from another database or i need to write it all in code (taking into consideration that i havent found how to insert datacontrols and do the binding, because im using french access, that s why i assigned automatically a record source for the form)
thanks in advance

View 6 Replies View Related

Accessing Database On Network

Oct 7, 2014

My boss cant access the database i made on his laptop at home.

The access database (.mdb) is on the company network.

View 3 Replies View Related

Showing Database Network Path???

Jul 28, 2006

I've got a database with several users and we've had two people recently who rather than creating a shortcut to the db on their desktop copied it and then proceeded to enter their data there instead of into the one on the network.

I would like to be able to add a field on the first page they see when they open it with the complete file name / path information. I know how to do it in Word by adding a field to a header or footer. However, I can't seem to figure out how to do it in Access.

My hope is that if I can display the path and then include a dialog box when the database is opened warning users to verify they have the correct version before they enter any information.

Alternatively, is there a script I could write that would have the db check that it's the V drive copy not a C drive copy?

Any and all help will be greatly appreciated. Thank you.

Charis Wilson
Denver, CO

View 3 Replies View Related

Creating A Social Network Database

Aug 7, 2006

Hi everyone, I am hoping someone will be able to help me with a problem I have. I am undertaking a social network analysis and in order to do this I need to be able to create a matrix with the following format:

Group Person
J Smith G Fowles M Jones
X 1 0 1
Y 0 1 0
Z 1 1 0

I also need to be able to store and retrieve personal and group level details. Note that people can be in more than one group and groups can have more than one person. My problem is that the data has been gathered by another institution and is only available in the following (Excel) format.

Group Person Role Group Characteristic .....
X J Smith Strategist Level One
X M Jones Supporter Level One
Y G Fowles Financer Level Three
Z J Smith Strategist Level Ten
Z G Fowles .... Level Ten

Any idea how I can go about doing this? I know how I could do it if I manually entered the data, but because there are literally thousands of individuals (and a whole heap of groups too) I am hoping hoping hoping that I can do it using Excel and Access. Any advice would be incredibly appreciated.

Thanks everyone!

View 1 Replies View Related

Database On Network Drive Won't Open

Oct 24, 2006

I was using the database when there was a network error and I had to close it. When I tried to reopen it I got the error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'. I logged off the PC and logged back on various others, but keep getting the same message. Can anyone tell me if this is terminal or is there a way around it. I do have a backup, but it's a few days old and a lot of work will need re-entering' so any help would be appreciated!!

View 1 Replies View Related

Cannot Open Access Database On Network

Oct 24, 2007

We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.

"Microsoft Access cannot open this File

This file is located outside your intranet or
on an untrusted site. Microsoft Access will not
open the file due to potential security problems.

To open the file copy it to your machine or an
accessible network location."


Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith

View 12 Replies View Related

Access Database Secured Across Network

Nov 1, 2007

Hi,

I have an Access database that needs to be secured and I have 2 problems:

1) How do I get it across a network so all users must enter their password?

2) How do I stop this from asking for a password for every database (i.e. I only want one database to require the password)?

Please keep answers simple as I am quite new to this!!

View 7 Replies View Related

General :: Sharing A Database Over Network

Jul 30, 2012

i have made a database in access 2010 . and i have put that in a shared folder . split that into fe and be. and on my network i am using access 2010 runtime on other computer to access it . on that computer in registry settings i have trusted locations as //server/database i.e. in database folder i have the fe and be.i can open the fe but with potential security warning i.e. of trusted locations i think . and when i click open on it it doesnt open my forms those are linked with tables from navigation form and displays the error that is something concerned with location g:database which is on my server computer.

View 2 Replies View Related

Access Slow To Load [really Really Slow!]

Dec 14, 2007

Hi All,

I'm having trouble with access. Basically it has been very slow to load
(over 30 seconds when not opening a database) and when opening a database it just crashes.

Has anyone any idea what could cause this as it worked fine before ?

also would a reinstall help ??

-Elfman

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved