Hi. I have been fixing up some access 97 programs on the computer systems at my work. The main changes I made was creating a search function using a query behind a form to search the database (no more than only 90,000 records). I am running a novell server. The data tables are in a database on the server. The access program on the desktops have their own access database program that use linked tables to the data tables on the server. The following is my issue:
Apparently, some of the changes I made to the searches caused the server buffer to become full and not flush itself. Anytime I was working on creating the fixes, it seemed to make the server crash. I 'm just wondering if anyone has had a similar problem with access 97 running on a novell server and causing any buffer issues. Any ideas on how to prevent the server from crashing?
I don't know if this is caused by Access (2003) itself, or somethign else, such as the JET drivers. Whenever I load up anything in Access it crashes saying I can repair it and restart access... no matter what I load.
Also, it seems other programs that connect to a database only retrieve 'nothing' from the tables and queries. I'm quite confused, any help would be wonderful right now.
on a small scale this code works, but when my inventory table has all of the 2000 records it crashes, any ideas. I can ftp my database if needed
Code: Dim ColorDim StartPointDim RsItem As DAO.RecordsetDim RsNewItem As DAO.Recordset 'Grab the inventorySet RsItem = CurrentDb.OpenRecordset("select ItemId,Description1,description2,quantityonhand from item")'grab the table that will have the new item and description addedSet RsNewItem = CurrentDb.OpenRecordset("select * from newitems") With RsItem While Not .EOF StartPoint = 1Start:'find out if the last numbers is numeric or notIf IsNumeric(Mid(Right(.Fields!itemid, StartPoint), 1, 1)) = True Then'see if the start point is the last letter or notIf StartPoint = 1 Then 'meaning there is no colour indicated at the end of item Else'add the quantity and the color to the newItem tableColor = Right(.Fields!itemid, StartPoint - 1)RsNewItem.AddNewRsNewItem!Description = .Fields!quantityOnHand & ColorRsNewItem!itemid = .Fields!itemidRsNewItem.UpdateEnd If Else'move the startpoint to the next letter in itemStartPoint = StartPoint + 1GoTo StartEnd If .MoveNextWendEnd With
My MS 2000 Access application is crashing and returns a msg something like this: "Your Access application caused an error and Access must be closed" This occurs only when I execute some forms; always the same forms cause the problem. Somebody told me to copy the .mdb to another place in my HD and change the names of the forms. I did it and it always works well! Any good reason for that? My app is not yet splited in FE and BE. Splitting would help?
Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this?
Hi all, 1st post. I'm and Access n00b I'm afraid, so take it easy. I normally use php/mysql, but have been roped in to fixing a broken access database.
I've got an Access database, and a fileserver is holding the data (mdb file), but I've got around 10 machines which access the database thru a frontend (mdb file).
Now, this has been working fine until today, where I am trying to view one table (Orders), and access bombs out. It shuts down instantly with no warnings. It does this on every machine, so I think it is a database problem. I can view the data if I open the standalone data file, but I cannot view the data thru the frontend.
I need to fix this asap... what's causing the crash? I didn't make the front end, but if I could look at the code, I may be able to see where it's failing.
I am trying to build an event when I double click a field. As soon as I click on Code Builder, access crashes. It does this with every access database I open.
I have a simple calculated field (As "Ratio") that is readable in Access 2010 query, but crashes in Excel upon importing/running the query in an .xlsx table.
ERROR MESSAGE in EXCEL: "The query did not run, or the database table could not be opened...check database server..contact your database administrator.."
I am simply taking the cost amounts of each project record (shown as "Record Cost") and dividing it by the "Total Cost" of that project to render "Ratio".
The Total Cost is retrieved from another table.
Testing scenarios: If we exclude Ratio, the whole query import just fine. If we filter the query to one project (i.e. "Project A") the ratio field imports fine.
However, the whole unfiltered query does not with the ratio!
Other testing scenarios:
If we use a constant for the denominator AS "1" in Ratio (i.e. recordcost/1) the whole unfiltered query and ratio field imports fine.
If we use a constant for the numerator AS "1" in Ratio (i.e. 1/totalcost) the whole unfiltered query upon import crashes in Excel.
This is a mock example of the dataset, the actual query has 50K+ records:
Project Service Date Record Cost Total Cost Ratio A Welding 1/1/2012 $100 $120 83% A Plumbing 2/1/2012 $20 $120 17% B Welding 1/1/2012 $50 $75 67% B Plumbing 2/1/2012 $25 $75 33% C Welding 1/1/2012 $40 $61 66% C Plumbing 2/1/2012 $21 $61 34%
So here's my situation: Tonight I opened the file I was working on this morning (which was in perfectly fine state)...
I opened a form - CRASH!! I press ALT+F11 to go to the VBA editor - CRASH!! I open another form - it works fine... So i select a button and tried to edit the action script - CRASH!! I relinked the backend file - CRASH!! It seems everying I do makes the darn thing crash. :mad:
I tried compacting/repairing - no luck there. This is not the first time it has happened to me. I forgot how i managed to fix it the first time. Anyone with experience with this? Any suggestions?
I tried opening an older db file, and was able to access the VBA editor for that file. But it crashed again when i tried going back to the bad file.
If i recall correctly, I think this morning, when I closed my access file, I closed the Access Program long before I finally closed the VBA editor (didn't realize it was still around because the taskbar was a bit cluttered). Wonder if that caused it to go hay-wired.
I've come across a problem with my database, I’ve tried everything I can think of, and I’m still no wiser as to what’s causing the crashes. I hope someone can shed some light on what the problem might be.
I've created a database that uses a switchboard to navigate through the various forms, the switchboard is loaded (using the start up options) most of the database objects are switched off (like display database window), apart from 'allow full menus' and 'allow default shortcut menus'.
This reason I’ve given you the above information is that the error only occurs when the database is loaded through the start up options. If I open the database bypassing the start-up options this error doesn't occur.
Now to the error:
I have various forms that have a button that will attempt to send an e-mail, its set up that the email doesn't send automatically but allows the user to edit the email before sending. When the e-mail is created using the code below, and the user decides to cancel sending the email by pressing the 'close' button on the email, the database will lock up.
The first error message I get is:
The sendobject action was cancelled You used a method of the DoCmd object to carry out an action in visual basic, but then clicked cancelling a dialog box. For example, you used the close method to close a changed form, then clicked cancel in the dialog box that asks if you want to save the changes you made to the form.
The second message is my error trapping for cancelling the email, and then after that the form loses focus and I can't do anything to the database. It's still running because I have a clock on my form that’s still ticking away.
The only way I can close my database is to 'ctrl alt del' and 'end task' it. When I do this I get another error message saying
You can't exit the database now If you are running a visual basic module that is using OLE or DDE, you may need to interrupt the module
And then the database closes. I've noticed the crash only occurs when the 'display database window' option is turned off. When its on then my error trapping deals with the closing of the email.
Private Sub MailCreditReport_Click() On Error GoTo Err_MailCreditReport_Click Dim stDocName As String
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord Else End If
Exit_MailCreditReport_Click: Call ReportError Exit Sub
Err_MailCreditReport_Click:
Select Case Err.Number
Case "2501" MsgBox "User cancelled Sending E-mail(s). Please Resend", vbExclamation, "Sending Stopped" Exit Sub Case Else Resume Exit_MailCreditReport_Click End Select
End Sub
I've tried various things with the code like DoCmd.CancelEvent, but nothing seems to make any difference.
Anyone, I posted at the begining of this month with an URGENT post and had a lot of help off some of you guys. My database was corrupting and crashing and I had a lot of help of rural guy and others. By the finish of the two days I had compiled and decompiled my database and lots of other little tricks to try and make it a bit better.
At the end of the two days the database was up and running but I had to delete three of my forms because the VB Script that was attached to them forms would not delete. I managed to get it working but I am now having further problems.
Althought the database is useable without these forms I can not re-create them. I have tried importing them into a new database, compiling them then importing them into the FE, but it still crashes. I have also tried just creating a new form and starting from scratch but it will not let me create a new form from scratch. It runs very slow and still crashes on development. my Back-end is working fine.
Does anyone know of any common errors that may be causing these problems. I am now in discussions with my boss because the only thing I can think of doing is starting my FE front scratch.
I am a novice database user and I built a small job tracking database for a small construction company. For the last 2 days, Access has become very unstable and I am getting the "Sorry but Access has to close" message shortly after opening. I have tried the "repair and compact" utility but no change and it still crashes. Is there other troubleshooting procedures that I can use or can you recommend someone to do the repair work?
I've redeveloped my DB so that all forms are unbound. I did this due to a multiuser environemt of 30 or more users.
I left all reports bound because there were fewer than 10 concurrent users running them at any one time.
But... I'm finding the DB crashes when a second user runs the same report concurrently. Maybe its data binding overload?? Would setting the underlying query recordset type to snapshop overcome the problem??
We're currently looking at changing a couple of my more complex Access 2003 databases to Access Front End with a SQL Server Back End. This should give us better stability and reduce network traffic loads. I was looking at the Access help file on Upsizing and came across the following paragraph. On face value to a novice like me this would seem the easy option - but is it?
"Create an Access database front-end to an SQL Server database back-end so that you can create a front-end/back-end application.
This approach requires very little application modification since the code is still using the Jet database engine. "
I am importing an Excel file into a table in SQL Server that was created by an AS400 program.
I linked this table in MS Access. The date fields from the SQL Server table are split out. DSREQM is the month and day. DSREQY is the year. When opening the table it looks like this:
DSREQM DSREQY 215 6
I need to be able to convert this is a field to 2/15/06. However I cannot get this to work. For some reason when I execute the query it comes out as 8/02. Here is what I have:
I am attempting to write an application, using Access2003 as the front end. The Backend May be either Jet (ie an MDB), or SQL Server.
I am trying to make it so that the same code works regardless of the back end.
My approach has been to set the forms recordset to an ADO recordset like so:
Set Rs = New ADODB.Recordset 'Rs.CursorLocation = adUseClient Rs.CursorLocation = adUseServer Rs.Open strSQL, gcn, adOpenDynamic, adLockOptimistic ' Set Me.Recordset = Rs
Anyone done this, and willing to sahre information/pitfalls.
First problem I am encountering is that Jet only seems to like .CursorLocation = adUseClient, and SQL Server only seemns to like .CursorLocation = adUseServer
I'm attaching the code for a function that's attached to a button that allows the users to export data from a form to the directory and file of their choice.
This code works when we're just running Access, but we need it to function in runtime, and it just crashes with an entirely uninformative "runtime error" message.
I didn't write this code, but looking at it, it seems to be just a copy of what's in the MS knowledge base about the filedialog function.
I also never write my own applications using runtime (the program we're running this is was contracted for our lab), so I have no idea why this would be failing in runtime but not in Access. Can anyone help?
Hi to everyone Im not sure which thread i should be in, but here goes :confused: i want to create a members database for members on my forum with HTML! Ive been told to make the database with ACCESS ive played for 2 days and im now acctually getting somewhere, i would like members to interacte with it ie....add there own details to it. How do i do this and how do i get it to my server, well i did upload a tester but no one could see it and its says they need to have MS installed or something like that :eek:
I'm trying to help someone with Access on a CITRIS Server. I'm working with them VIA email. They say they're having problems communicating with printers and would like to utilize their email with Access. Can someone fill me in on common problems using Access with CITRIS Server as far as printers or email or anything else?
To be perfectly honest, I know nothing about CITRIS servers. Is CITRIS a hardware system or computer type of is it an operating system???
I need to be able to add a feature to an Access project that will select a group of records based on an area code( user will have to be able to select a desired number like 100, or 1000), mark those as selected, and create a single csv file...The area codes are stored in the SQL SERVER database...right now they just export groups of #'s based on area code to excel select the amount they want and cut and paste into a flat file for another application to use...they would like to be able to select a number from a list box or type it in...like 100 ( which means take a 100 #'s from all different area codes) then have them automatically noted in database as being selected..and then export all selections to one csv file... should I do part of the work in the Sql Server behind the scenes..the format of the csv file also needs to be specific in that the first row is the columns separated by commas and then the data follows all text fields enclosed by qoutes.. Thanks for anyone's help ..Im very inexperienced with VB and Access
I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures. I finally had to give them permissions as db_owner so they could use my forms. Do I have to give them db_owner permissions to execute my stored procedures? I know I can go in and assign them execute permissions for my stored procedures, but there has to be a better way. Does anyone know how to give users execute permissions on stored procedures without having to give them db_owner permissions or having to grant execute permissions for each stored procedure individually?
I am still in the development phase of my project and having to assign users or groups with each stored procedure I create could really be a pain. Can someone please help me?
I am accessing a SQL Server 2000 database from MS Access. While I can view the tables and can add records, I cannot edit or change them. How do I get around this?
I am trying to build a form to make deletes from our sql database easier for some of my coworkers.
They have a combo box that they select a patient name from, then based on that patient id, they have a second combo box that shows all appointments that patient has been to. All right so far, yes?
I want, after the first two selections are done and we have a patient and an appointment selected, to have a textbox that returns the count of the number of medical documents based on that appointment id.
I am trying to use a text box for this. Code: "select count(appt_id) from template_audit where appt_id = " & Me.cboAppointment
I don't know what property of a text box to use to return a single sql statement into it. Anyone have any ideas?
The database that I have on MS Access has tables, queries, forms (VB code), reports and functions (VB). I could migrate the tables and queries through the Enterprise Manager. I want to have the forms and reports in html. Is there any software tool that can help me with over all migration?
I've create an ms access security workgroup and put .mdb and .mdw file to a folder under any acount on a server. When these files in my local machine it work properly. But when these files on server I myself cannot open .mdb file. How to make ms access security on a server ?
I know and have worked with MS Access for over 3 years now. Just would like to know if there is very much difference between MS Access and SQL Server. Are they similiar or are they completely different . In terms of designing forms, reports, sql.
Appreciate some feed back and also where I could view or look at sql server.
