Citrix, Opening A Database, Incurs Delay?
Jun 13, 2006
Hi Guys,
Got something which has been bugging me like mad for weeks now;
We have a MS Access Database on a Citrix server and a local copy is downloaded to the clients directory when they log on.
When they actually double click and load the database(frontend) it loads for approx 4/5mins before it eventually opens. After that it is fine, unless they log off and back on again, then the same thing happens when they double click to open the database.
The Backend is stored on a seperate server with over 5million records on it.
Before we attempted Citrix we had a normal network and the frontend has always loaded fine on this.
Any ideas?
Thanks.
View Replies
ADVERTISEMENT
Sep 4, 2013
I am building a faux Electronic Medical Records database for the purpose of training med students. I need a command button to pull up a report , but i want to delay the opening of the report (as if waiting for "tests" to come back or be uploaded) is there a way to do this with VBA? i read about the sleep api but i dont know how to get it to work or where to put the code
so what would i add and where would i add it to delay opening the report that is called EKG W/ Subreport ...
View 3 Replies
View Related
Dec 22, 2014
I have a command button (well, I have a few) that I would like to open a report, first opening a form that allows the user to enter a start and end date.
The code so far is:
On Error Resume Next
If Err = 2501 Then Err.Clear
DoCmd.OpenForm "DateSelect", acNormal
DoCmd.OpenReport "All Events Report", acPreview
Now, when run, this code opens the form (DateSelect), but the report starts to run immediately - the On No Data event of the report kicks in (message box along the lines of "No data, closing report", so before the user has the opportunity to enter the dates, the report has decided that there is no data an closes.
Is there a way to pause the opening of the report until after the OK button is clicked on the pop up form?
Just for the sake of clarity, the pop-up form DateSelect is used to open various reports, so I can't add the open report command to the code for the OK button (that I know of?)
View 8 Replies
View Related
Feb 12, 2014
"how to COMPACT the DB by introducing delay of 10 seconds and then close the DB".In the Database, I'm able to accomplish the "Compact" the database using the function below.
Function Compact()
SendKeys "%(FMC)", False
End Function
As my DB is quite huge, the Compact action takes around 10 seconds to complete.Now, i would like to Close the Database after Compacting the DB. I tried including "DoCmd.Quit" in the function. The commands in the function, closes the DB but the Compact function doesn't seem to have executed as it needs 10 seconds to complete.
Function Compact()
SendKeys "%(FMC)", False
DoCmd.Quit
End Function
how to introduce this delay of 10 seconds and then close the DB.
View 3 Replies
View Related
Dec 28, 2005
Has anyone ever used an Access on a Citrix platform?
I don't know anything about it, other than the cottage people that access the database from home, using Citrix constantely corrupted my database.
Was it the internet correction or was it Citrix?
All pros and cons would be great.
View 9 Replies
View Related
May 4, 2007
Hi
I am in the middle of developing a DB which will be multi user.
My boss wants to install a Citrix server over the next few weeks.
He has now asked me if we can pilot this database with the citrix server.
Can anyone advise what (if any) pit falls I may be in for as we head down this route?
Many thanks
Batt
View 14 Replies
View Related
Mar 23, 2007
thank you all for your help.
i haved searched and i did not find an answer.
i have splitted my database which is on the citrix server and put the b/end on the shared drive and put the front end on my document on the users desktop. my question when one is using the form the other cannt use the same form? why is that?? how can i fix that. i would like users to use the same forms to enter data at the same time.
thank you
View 7 Replies
View Related
Jan 18, 2006
Hi.
I developed a db on a local verison of Access 2003 (saved in Access 2000 format). It works great thanks to much help from this forum.
I recently moved the db to a server and tested how it worked when using Access 2000 on a citrix platform. This is important since the users of the db will be using this accursed platform. A few things (vba functions) broke but I deleted the affected code. However, one thing 'broke' that I can't eliminate.
When I click a button on one form I have a transfer spreadsheet command run to export the output of a query to a particular xls file/location. However, in the citrix environment I get an error message "Formats that enable export as html, xls, or rtf are missing from the windows registry".
I'm guessing this has something to do with the citrix server setup. Is there anything I can do on my end to avoid this problem or, as I fear, am I stuffed?
Cheers,
Craig
View 2 Replies
View Related
Oct 7, 2005
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
View 4 Replies
View Related
May 27, 2013
I currently have the following setup for my database which is working as desired when only being used by one user at a time:
Front end: Access 2010 database in Citrix
Back end: SharePoint List
The problem is that only one user can open the Access Database at a time since this action locks the database for other potential users. The locking occurs due to this link to the back end SharePoint list.
allow multiple users to update the SharePoint list through the access database at the same time?
View 2 Replies
View Related
Apr 6, 2005
I'd appreciate it if anyone could tell me how to edit the control tip delay in form design: ie: so as the controltip comes up much sooner than the default set by access?
many thanks
View 2 Replies
View Related
May 22, 2005
I have a large Access application with several forms and modules. The form works fine and quickly. I have a combobox which queries the database containing 30,000 entries. This combobox is delayed in populating. So that if the user types into it the characters don't display for a couple of seconds. Is there anything to do to spped up the combobox? There is a join in the query so I removed it. It did not improve the delay.
Any suggestions?
Thanks
View 1 Replies
View Related
Jun 8, 2005
Is it possible to delay the Form_Current event? I use the code below to duplicate records, ask for a change in teh reference number and then resort the database according to the reference numbers. This works fine until I introduce some code into a Form_Current procedure. Now whenever I activate the macro below to copy a record the data in the copy record is wiped out and the form rendered with its defaul values. I am assuming this is because the code in the Form_Current section is rendering the form whilst something else is trying to paste values in it so is ther a way to delay either the pasting of the new data or the activation of the Form_Current procedure?
I have tried using a few basic counters but to no avail! Any help would be greatly appreciatted.
Cheers
_______________________________
Private Sub cmdCopyPrevRec_Click()
On Error GoTo Err_cmdCopyPrevRec_Click
Dim TestNum As String
TestNum = Test_Number
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70
NewTestNum = InputBox("Please enter test number:", "Test Number", TestNum + ".1")
Test_Number = NewTestNum
Test_Number.SetFocus
DoCmd.RunCommand acCmdSortAscending
DoCmd.FindRecord NewTestNum, , , , , acCurrent, True
Exit_cmdCopyPrevRec_Click:
Exit Sub
Err_cmdCopyPrevRec_Click:
Display = MsgBox("Copied without updating Test Number", vbOKOnly)
Resume Exit_cmdCopyPrevRec_Click
End Sub
View 1 Replies
View Related
Aug 1, 2007
Is there any function to delay the system processing for a number of seconds.
For the time being I am do it indirectly by using loops, however, it is un proper way, as it is not scalable.
Also I dont want to use the timer control.
Thanks,
View 4 Replies
View Related
Sep 30, 2005
I have some code that is running in a FOR NEXT loop. I am calling another form each pass of the loop. For some reason the form does not fully come up, the box and header text come up but nothing inside the Form.... Any thoughts.....
At the end I want to display another Form that confirms the updates/calculations. But I want the Form to close after say 2-3 seconds. I tried a wait function but that does not allow the form to fully open as above....the wait function is waiting for the time i want but it again does not allow the form to open....it waits and then the form closes, never showing what is in the form?
Does anyone know how I could open a form display some information and then have it automatically close after a few seconds.
I call the Function TIMEDELAY below which is calling the Function Wait....Once in TIMEDELAY it opens the form and then supposed to wait then close....but the form never fully opens? .....
View 1 Replies
View Related
Dec 16, 2013
When moving to a new a record in my form, i will click on a text box and the following happens:The black line will flash much faster than normal (This will happen on any text box i click on) No text will appear while this is happening When it stops al the text that was typed in that period will appear After this 5 to 10 second text delay the text box and all other textboxes will work fine, until i move to a new record and the process starts again
View 2 Replies
View Related
May 15, 2015
I want to make delay, for example 2 minutes when the code is within the loop.
Example
Code:
For i = 0 To 100
Debug.Print i
'Before go to the next to make the delay
Next
View 12 Replies
View Related
Sep 27, 2005
Hello,
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
View 5 Replies
View Related
Aug 9, 2006
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
View 5 Replies
View Related
Dec 15, 2004
A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?
Tawain
View 2 Replies
View Related
Jun 15, 2015
I have a continuous form with an SQL query as its record source, it is a dynaset. Each row on the form is for a specific picture, containing a unique ID, a pre-generated caption field, and an official caption field. The idea is that users will edit the pre-generated caption field, hit a button, then their changes to the pregenerate caption will be made to the value of the official caption field.
My VBA code for the button works fine, in that it doesn't return any errors. The problem is that there is some sort of delay between when the button is hit and when the official caption field is updated. After the first press, the form requeries and the official caption field is the same, but after a second press the official caption field will display the user's changes.
First, a recordset clone is created using an SQL query, the pre-generated caption column is selected and then the results are filtered to the single record that shares the picture ID of whatever row the user was working in. Next, an SQL update runs, replacing the value of the official caption field with the value of the pre-generated caption that is contained in the recordset clone. Then the form is requeried.
I've tried adding a change of focus at the beginning of the code and a 15 second pause between when the update statement runs and when the form is requeried, neither solves the issue. The problem can't entirely be my code, because a second press of the button will make the appropriate changes.
I know what you're thinking, why have divide the captions into pre-generated and official in the first place - why not use pre-generated caption as the caption source? There is a separate feature that allows a user to mass edit captions and I decided to retain the original pre-generated caption as a field, in the event that the user makes a mistake or decides to reference the content of the pre-generated caption.
View 1 Replies
View Related
Jul 23, 2015
I am using Access 2007 & trying to update a database to include a check & balance.
Currently a user enters their name into a form, selects a check box (Pass or Fail) & clicks a save button. Real simple form. The actual testing is performed on a standalone piece of equipment separate or outside of the MS Access database.
Here is the challenge, if someone does select Fail, I want to ensure this person comes back into a blank form (new entry) & confirms they have eventually passed. I want to give a time limit of 10 minutes before an email is sent out to their superiors. (I have the email portion figured out already).
Other entries will take place before the failed user comes back to the entry form so the form needs to be available for other people to enter their results.
I believe this can be done using some VBA and a query but I am not sure where to start especially with the 10 minute allowance to recheck the test status.
View 8 Replies
View Related
Jul 16, 2005
The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob
View 1 Replies
View Related
Dec 28, 2005
Hello everybody,
I have a question.
I have a button on a form.
When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database
Dim rsMyRS As Recordset
Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb")
Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
But it didn't work.
Thank you very much in advance...
View 3 Replies
View Related
Aug 8, 2006
Good afternoon,
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
View 6 Replies
View Related
Oct 2, 2006
Hello,
I have a wierd problem I am hoping someone can help me with. Our company database is stored on the server.
The problem is that I can open it when no one is in at and then they can all get in after I open it.
If everyone else is in it, I cannot access it at all until they close out, I open the file and then they can get back in.
Can anyone help me resolve this issue?
Thanks,
Dianne
View 4 Replies
View Related
