?
Solved

Access database and DFS

Posted on 2009-02-23
8
Medium Priority
?
894 Views
Last Modified: 2013-11-29
Hi All,

I have been tearing my hair out with this one...

I have a totally bespoked Management Information System (which I am in the process of phasing out) that is built on access.
It has many database and uses linked tables to share the info betweeen each database.

Now here is the problem... We recently decided that it would be a good idea to move the database over to a DFS strucutre (Distributed File System). We have made all of the necessary changes to the linked tables and the system works..

But when I try and edit a report the speed is absolutley appalling.. In order to move a text box, I have to click and guess where I am dropping it...!!

Any ideas, Both the File Server hosting the solution and all of the clients have the KB from M$ concerning slow access for a workstation when accessing things via DFS...
0
Comment
Question by:JohnGerhardt
  • 4
  • 4
8 Comments
 
LVL 28

Assisted Solution

by:TextReport
TextReport earned 2000 total points
ID: 23714605
You can remoce the recordsource, make the changes and then put back the recordsource of the report for a temp quick work around.
Cheers, Andrew
0
 
LVL 17

Author Comment

by:JohnGerhardt
ID: 23723852
Thanks for the idea... That does work but I have users that make edit that I am worried about telling this "solution". As I am sure that they will forgoet to put it back or put it back wrong...?
Any other ideas..?
Cheers
0
 
LVL 28

Accepted Solution

by:
TextReport earned 2000 total points
ID: 23723893
With the OnOpen event of the report you can say

If Me.RecordSource = "" Then
   Me.RecordSource = "MyQuery"
End If

Cheers, Andrew
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 17

Author Comment

by:JohnGerhardt
ID: 23723943
Ah ha, good idea.. But that wont help if they put the wrong query back in...! Also it doesnt solve the problem if I need to add fields from the record source.. It is a useful work around though...
Thanks,
0
 
LVL 28

Assisted Solution

by:TextReport
TextReport earned 2000 total points
ID: 23724057
"But that wont help if they put the wrong query back in...!" then remove the If and End If so it forces it to MyQuery.
Cheers, Andrew
0
 
LVL 17

Author Comment

by:JohnGerhardt
ID: 23724072
Ok, brain not firing on all cylinders..
That would work.. Now, I have to do some training....>!
I will leave this open for a little while to see if any one else has any bright ideas...?
Thanks Andrew!
0
 
LVL 28

Assisted Solution

by:TextReport
TextReport earned 2000 total points
ID: 23724178
Another thing that might be worth looking at is the location of the MDW file it takes many hits and if this is on the network it can impact performance. This can be checked in the debug window with ?syscmd(acSysCmdGetWorkgroupFile).

Finally check the query if you have it to return no records then you can still have it as the recordsource so you still have the options to add the fields from the field list.

Cheers, Andrew
0
 
LVL 17

Author Closing Comment

by:JohnGerhardt
ID: 31550252
Thanks!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question