Hello again NeoPa, Stewart.
Thanks again for replying so promptly. You're making a really valuable contribution.
I'll check out the indexes situation, and whether I have indexes on those fields I'm looking to sort on.
Jon
jonnyboy
Last Activity: Mar 5 '09, 02:41 PM
Joined: Aug 6 '07
Location:
-
Thanks for replying, NeoPa.
When the form opens, it displays the correct records in both the main form and the subform almost immediately.
However, the form seems to be refreshing itself over and again for quite a while, with "Calculating... " in the status bar, which impedes data entry and slows the application right down.
If I select the main form and hold F5, there is a similar effect, although there's nothing in...Leave a comment:
-
"Calculating..." when form opened
Hello,
I have an Access application with a number of forms. On opening one particular form, the application will sometimes appear to get stuck in a loop with 'Calculating... ' in the status bar for some time. This is a problem when using the database on a server, since it seems to be running the same query over and over again.
There is one form in particular I have a particular problem with. Both its form and subform... -
I've also noticed this happens sometimes when changing data types in general. So, if you need to change a data type on a design master, ensure all of your replicas are checked in before doing so! If this isn't possible, you will have to create new fields and use an update query to copy the information over from the old field.Leave a comment:
-
Solved it - it came about by changing the data type of one of the fields from 'hyperlink' to text. I successfully replicated the problem. So, if you ever have a 'hyperlink' field in a replicated table, DO NOT change its data type!Leave a comment:
-
Synchronization failing
Hi,
I have a design master for a back-end database on the hard disk of my computer and a replica on a network share.
When I try to synchronize the database, I get an error 3008:
The table "|" is already opened exclusively by another user or it is already open through the user interface and cannot be manipulated programmaticall y.
Neither the design master nor the replica are open... -
Yes, the status bar at the bottom says 'This recordset is not updatable' and users cannot add new records or edit existing ones.Leave a comment:
-
Hi,
Thanks for the reply, Puppydogbuddy.
I'm a little confused as to how to start with this one; am I right that this bit of code actually monitors the inbox?
The database wouldn't always be open, so I wonder if there would be any way of passing arguments from a hyperlink in an email to start the database and then go to a specified record?
I'd rather not tamper with my colleagues' inboxes if po...Leave a comment:
-
Anyone else have any insights? The damn thing reared its ugly head again today!Leave a comment:
-
Hi,
What do you mean by the first record? Is it the first created, or the first in the record sequence? I think you may need to have an intermediate query that identifies the specific RecordNo you require from the "tblPend" table.
Let me know how you get on.Leave a comment:
-
Linking to an access record from an email
Hello,
I've developed an access database to track work against team plans and organizational objectives.
I'm trying to implement a feature but I'm not sure where to start. I'm wondering if there is any way of opening a database at a specific record by using a hyperlink in an email.
For example, I want users to be able to receive an email like
"I've assigned this task to you. Please... -
Hi,
Sorry for the late reply - the development has taken a different direction but I've got back to this line now!
Yes, all front-end deployments open a connection to a table in the back-end in a hidden form.
The problem is happening less frequently but it still occasionally rears its head and stops all users from editing the data.Leave a comment:
-
Hello again,
I wouldn't expect the ldb file to be absent in all cases: the database might have two or three people accessing it simultaneously, which works fine. Another user having the database open doesn't turn the back-end read-only.
The back-end seems to go read-only spontaneously, although it tends to happen when the database is first opened.Leave a comment:
-
Hello again,
Thanks for replying again, RuralGuy.
You're right, it's a weird situation! Since I've implemented the persistent connection, it seems to happen only now when I first open the database (before I did this, it could happen at any moment).
I start up the client (which is located on the local hard disk) and at the bottom of every form it will say 'This recordset is not updateable'.
...Leave a comment:
-
Hello again,
The persistent connection seems to have improved performance somewhat, but I still occasionally have the problem with the back-end becoming read-only.
I'm not completely clear about what might be causing this. The only way to make the back-end writeable again is to open the back-end on its own.
Once this database is deployed, this isn't an acceptable solution.
Can anyone help?Leave a comment:
-
I've solved it! I read up on using a persistent connection. Thanks RuralGuy!
I have the database open a hidden form linked to a dummy table in my database. This form is always open in the background, and it's the same as having the back-end database open at the same time.
I still have a minor problem if I close the database and then open it again quickly afterwards; this tends to make the back-end read-only. I guess this might...Leave a comment:
-
Microsoft Access read-only back end intermittent
Hello,
I'm having an intermittent problem with the back-end of my database.
On an intermittent basis, the back-end tables will become read-only. This only happens when the back-end is located on a network share.
It isn't a permissions issue because the problem occurs only intermittently when logged in as the same user.
If I open the back-end database on its own and then the front-end client... -
I've managed it... here it is in case anyone needs it!
[CODE=vb]
Sub replaceWithImag e(sResponse As String, imageRelativePa th As String)
origDocPath = ActiveDocument. Path
imageFullPath = (origDocPath & "\" & imageRelativePa th)
'Application.Sc reenUpdating = False
With Selection
.HomeKey Unit:=wdStory
...Leave a comment:
-
Alternatively, an approach I have thought of is a loop that will go through the entire document and repeating a 'find' action and inserting the same image at each point. I'm not quite sure how to do this iterative 'find' process though.
Any ideas anyone?Leave a comment:
-
Did you get any further with this?
JonLeave a comment:
No activity results to display
Leave a comment: