Random Shutdown Of Access Application
Mar 31, 2007
Help !
The MS Access 2000 application I have developed for my remote client, when deployed, occasionally shutsdown with no error message and no clue as to why.
There is no common pattern that I can establish. Compact and Repair makes no difference. Have tried re-writing objects that I suspect may cause this. I have tried creating new front end and back ends and re-importing all the objects. Have tried programatically deleting and replacing all queries. Have tried converting to Access 2003 and back again.
Is there any third party trace tool that I could use, or expertise that I could engage?
My London based client is losing patience and I am staring down the barrel of 4 weeks worth of work going unpaid.
Thanks in anticipation...
--
Richard
View Replies
ADVERTISEMENT
Apr 26, 2006
Hi everyone,
Is there a way to automatically shut down Access after a given amount of time?
I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database.
Some of the users forget to close their application at night when they leave for the day. When I come in in the mornings, I like to run the Compact and Repair, but can't because someone is still logged in. So then I have to go to each and every computer to see if they are still logged in. By the time I vist each computer, the morning is almost started and people ARE logging in for the day.
So I'm hoping to find an application that will automatically either log each computer off across the network, or that will log the application off of each individual computer after a given amount of inactivity.
Thanks for your help...
View 2 Replies
View Related
Jan 5, 2014
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
View 4 Replies
View Related
Jun 11, 2007
We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
View 2 Replies
View Related
Nov 8, 2007
Hi
Does anyone know if it is possible to create a macro (or whether there is another function) so that a database will automatically close after a period of inactivity.
There is only one form that users will see (or use) but if this form remains inactive for say 20-minutes the program shuts itself down.
My initial thought was to use Form>On Timer facility but I would need to be reset the timer after every update. This seems particularly longwinded and I'm not 100% sure it would work.
Any suggestions would be gratefully received.
Thanks.
View 2 Replies
View Related
Jan 10, 2007
I have an access2000 db. Many tables, forms, reps ect... at random times it will just close. Don't know why. No errors, no reason why. It just closes. Is this common and is there any fix?
View 3 Replies
View Related
Jan 24, 2007
Hi,
I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time.
My idea is to kick-off all users every 12:00nn, Monday to Saturday and then compact / backup database after.
I hope someone could assist me.
Thank you!
Sheila
View 1 Replies
View Related
Dec 21, 2007
I recently got a corrupt backend with the standard "unexpectedly quit Microsoft Access" message. This type of corruption (backend) has never happened before so I'm a little worried. I think I've taken the standard preventitive steps, but I'm hoping I can do more.
I guess I have two questions but my main one is, what's the most graceful/ideal way to close an Access database as to reduce chances of corruption?
My other question is, does the size of the database have any bearing on it's corruptibility?
View 1 Replies
View Related
Mar 28, 2005
I am still learning access and have been helped alot by this forrum so I thought someone may be able to help me here. I am trying to experiment with security from a few different angles, privileges to folder, to database, inactivity shutdown, ect. I know that my office shuts down at 1630 hrs every day and noone comes back in till 0730 the next morning. Is it possible to ether load a script/macro on start up that will query the time every so often, and if the time is between 1700 - 0700, automatically close the program? If so could the inactivity timer sample supplied by petersoft be modified to accomplish this? If not possible, could a conditional statement be loaded on start and at a set interval after that to do something like (iif (time())<1,docmd.quit,"").
Thanks all
Narack
View 2 Replies
View Related
Jan 22, 2007
I download the database from this thread http://www.access-programmers.co.uk/forums/showthread.php?t=103278 and I copy the table, form, macro and module to my database but and error is appearing showing that missing shutdownform.
Pls can any one help me.
View 1 Replies
View Related
Aug 20, 2004
Is there a way to shutdown an particular db when multiple users are logged on from my pc?
i.e. - When I need to get into design mode and can't because of other user's being logged on.
Or at least be able to send them a friendly message from within access to ask them to get out?
View 2 Replies
View Related
Feb 14, 2008
I have been using access 2003 at my work place.
When I bring back my access 2003 project from work back home, i open the project at home, I am using access 2002 or 2000 format.
Then I notice if I save a copy of my work using access 2002, while initially using an access 2003 database, the file size decresaseas dramatically, from like 3mb to 800 kb?
any reason why?
No data seems 2 be lost.
Cheers!
View 4 Replies
View Related
Mar 8, 2014
I've got an Excel sheet with +700k rows and 20 columns that I wanted to import to Access. All fields are text except the field that I want to use as a primary key, but I planned to import that as a text as well.
When I used the import wizard, I set all fields to import as text except for three that I set to memo. The wizard didn't say there was any error after importing the data, but when I checked the table, I noticed there were *a lot* of records where many fields where blank. Some fields where completely unaffected by this problem throughout the entire table, but in the rest of them, there is data missing in many records, and when there is data missing, it is not always the same fields that are missing. I have been unable to find any pattern that explains why sometimes the records were imported correctly, and why sometimes they were not.
View 2 Replies
View Related
Jun 15, 2014
The code works perfectly except that a random "0" appears in the body of the email. How to correct the code to remove this annoying little "0"?
Private Sub Command62_Click()
Dim strSubject As String
strSubject = Me.LoadNo
DoCmd.SendObject _
[Code] .....
View 1 Replies
View Related
Jan 10, 2007
Hi
I have this Access application. Now I want to see the databases and fields defined.but when I open the access file, it straight opens the access application.
Then when i press Alt+F11, it opens VB Editor. Then when I click on Design mode it comes back to access in the design mode, but still does not shows the design mode for databases and reports and all.
I can remember there is one more step I need to do after getting into the design of the form.But I cannot remember that
Could anyone please help me out
thanks
namit
View 1 Replies
View Related
Oct 9, 2014
I use a timer based event that shuts down the frontends after some idle time.
1. How to disable the timer as it causes some weird bahaviours while editing the code? is shuting down the hidden form enough?
2. Is there a way to add regular maintenance intervals, i.e. every wednesday at 20.00.? how?
View 2 Replies
View Related
Aug 5, 2005
I have done my access application. I will give it to my friends to use but dont want them to modify my program. So, plz help me to lock the design view(like some access application) so every using my program can't access it to modify.
Or who can tell me the way to hide everything in design view. Just show the interface. Eventhough when user hold "Shift" button while openning but still cant view a design view part.
I'm not goood at security in Access. Plz help me to show this problem.
Thank you everyone.
:)
View 3 Replies
View Related
Oct 10, 2005
I am developing an application in access xp (2002) and want to distribute it as a runtime application. I do not have the Office xp Developer version and thus need to buy the MS Office Developer. It is still available and if so, where can I buy it? Or can the Visual Studio Tools for the MS Office System make a runtime version from access 2002?
Any help would be appreciated.
Niels
View 1 Replies
View Related
Feb 1, 2006
hi
i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop
application in acess.Thanks in advance.
View 3 Replies
View Related
Feb 1, 2006
hi
i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop
application in acess.Thanks in advance.
View 4 Replies
View Related
Feb 24, 2006
Hi
I have created a website that includes an Access database providing a directory of manufacturers and suppliers to complement a magazine version.
The requirement now is to distribute the catalog on CD as well and the challenge is how to supply a query function?
I created a cd version of the website and it works fine - except if the user does not have Access installed the queries dont work.
I know the MS Developer Edition is the preferred route but it is very expensive for a simple application like this - does anyone know of an alternative approach?
Regards
Tony Randell
View 1 Replies
View Related
Mar 14, 2006
Hi all..
I need to open an application when user clicks a command button...From this forum I have learnt that I can use SHELL command..but when I use this command to open an application, it opens a new instance of the application everytime...Can I bring the application to the foreground if it was already open?
Thanks in advance.
View 2 Replies
View Related
Jul 20, 2006
Hello,
I have an Access application which was written on Access 2.0. I need to run it (as is). I saw that it was possible to run it using some kind of Access 2.0 runtime environment - my client uses the following command to run the application:
Msarn200.exe application.mdb /ini application.ini
Where can I get this MSARN200? Do I have to find the Access 2.0 installation itself?
View 5 Replies
View Related
Oct 30, 2006
Hello everyone. This is my first post (for not asking help :) )
I look at topics for start up options etc and I think all of this it’s ok but there is a smarmiest way to start your application. So here we go..
We make a vbs Script
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.Run """C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE""/RUNTIME ""C:Documents and SettingsEvalDesktopDataBaseUI.mdb"""
And we start The Access In runtime and open your Db
Note this working with Access 2003 .If you have an other version just change the access directory “C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE”
Where is your Office Access
Then you can make a shortcut of your .vbs script and rename it ass you like
You’re Application Name. You can change the Icon (If you have a Program File’s Folder Place your icon) Right Click Properties/Change Icon
Then your app is starting in Access /Runtime and everything is fine :)
View 1 Replies
View Related
Dec 6, 2007
Hello Forum members
Am an ardent access user and have a small problem that am Requesting for help.
I have designed an application software using access and I would like to peddle it to a few prospective clients. I want to package it as a trial software to run for thirty days and after that if the clients is not satisfied,I want it to disable but store the data. How is this possible.
All help is appreciated
View 1 Replies
View Related
Jan 18, 2008
Using the MDE-menu function in MS Access it returns an error. MS Access is not able to make a MDE-file of my database. I prefer to make a runtime of my database, but surfing the internet I can not find a way to do this. Can you give me directions for this?
View 4 Replies
View Related
