With ColdFusion and MSAccess 2003, the following query :
SELECT A.*, B.entry_id
FROM A.blog_entries, B.blog_subscriptions
WHERE B.blog_id = #variables.blog_id#
AND B.user_id = '#variables.userInfo.user_id#'
AND A.user_id = B.user_id
returns this error :
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:WINDOWSsystem32B.mdb'.
1/ I occasionally run into this error: "The instruction at "0x77fc823" referenced memory at "0xfffffff8". The memory could not be "read". Click on OK to terminate program."
Do you know if this error message occurr ONLY on certain computers using Access 2000? Since this error popped up on one of my co-worker but NOT on mine. I even tried to re-install Access 2000 again, but the error message still pop up when tried to open a report. Also, the last three digits of instruction number "0x77fcZZZ" change everytime. Please help!!
2/ For some reason, I was coding VBA on one of the procedure on Form_Load, then certainly Access 2k does NOT let me go in the code of any control. WHY!! I am frustrated!! I tried to go in different way, but does not work
I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.
Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.
I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?
We are having Access 2000 application with frond-end in separate Access 2000 resides on each user's computer and link to tables in another Access 2000 resides on Server. Lately we have problem of the Access db on the server asking to be repaired. As it is in the process of repairing, this following error popped up and shut down the Access app.
"MSAccess.exe has generated errors and will be closed by Windows. You need to restart. An error log is being created."
I can't find the error log, and am unable to determine the cause of the problem and solve the problem. Pleaes help!!
I need to use various activeX controls in MsAccess2003. I downloaded a few activeX controls but I am having a problem with licensing. I registered the controls and the registration succeeded but when I try to add this ActiveX control on a form in MSAccess, I get the message that I don't have the license required to use this ActiveX control and that I should obtain the appropriate licence from the company that provides the licenced OLE object or ActiveX control. Any ideas on how to overcome this problem?
I am a newbie in ms access. I am ask to do some coding to help me with massive duplicate datas in my database in access. But i do not know where to start from? Im very confuse. As i do not know if ms access itsself can be program using codes? or am i suppose to use SQL? or VB? or VBA?
I'd like to know when a user has modified their records on my site. Is it possible to include code to stamp the datelastmodified per record? And if so, how?
the compact and repair on Access enable us to compact or database bec when we delete records the space consumed is not removed. in ASP my Access is increasing rapidly almost 10MB and sometimes downloading this file takes a lot of time for a slow internet. is there a script i can use to automatically compact the database?
my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.
I'm trying to import a tab delimited text file into MSAccess and its driving me nuts!! How hard can this simple thing be? I have a text file thats rather large (300Meg in fact) and it has a field that is a date/time but msaccess refuses to import it as such. If I import as text and then change the field to date/time it will work but I can't do this on my file because access reports that its run out of memory in converting the field type (2.5M rows).
I've tried setting up the table prior to importing the data and setting the field type but it make no difference. Any help here appreciated because this should be simple!!!
The format of the data that I'm trying to import is.
28/08/2005 10:31:11 PM
You can even make this a single row and try importing it and access drops it so obviously I'm very dumb!!
I am using msAccess to develop a small application. I have 2 tables, student and course, and I need to create a form with 3 fields - by_id, by_date, by_course_id
This form can generate a view only table according to the field the user entered.
Can anyone help me on this? What's the step to do so?
How I can store scanned object in Access. Becuase I have a employee database. I have to store all employees signature in the database Also I have to verify thier signature with the previously stored in database when they are trying to log .
I have a database which among other things records how jobs are received i.e.: Telephone, Email, Mail, Facsimile or Web.For each client I want to identify the percentages of each method of receipt against the total of jobs received and during different time periods.I have created a make table query for all jobs received between variable dates for a client entry of the name of the client and the start and finish dates are required to run the query.
I have a crosstab query set up to count each method of receipt and a final query to work out the percentages using the total from the crosstab query fields divided by the total of all methods.I have a macro set up to replace the table with new data when I want the stats for a different client between new dates, therefore the different methods of receipt may vary for the less active clients i.e.: they may only have telephone and email .
My problem is if I choose a client where we have not received a job by a particular method (say web or facsimile), the last query working out the percentages has fixed names to cover each method but naturally produces an error when it cannot find a corresponding method of receipt. I have experimented with NZ() without success.My question is can I either have preset standard names of the column field in a crosstab query? Alternatively in the query calculating the percentages, can I include code to ignore a non-existent field in the crosstab query.
I am really stuck. I have spent two days searcinh different forums trying to solve my problem. I am trying to create an UPDATE q to my Access database. But I get either the: "Syntax error in query. Incomplete query clause" or "Syntax error in UPDATE query".
First of all here's the URL: www.innotec-as.no/login/Kunder Login U/P either: "alfen" or "thomas".
The page opening up shows the user info, U/P and adress. viewing the information is working perfectly - but editing it..no way.
When editing and submiting the data the above errors occour. Try that and you'll also see the SQL I am trying to execute. The CODE is as follows:
All I'm trying to do is a make table (table name to overwrite: "TBL_5_7_RFCs") query via VBA so I can loop through a set of VARs in a table. Here is my code:
Code:
Public Function test_sql() Dim Conn As ADODB.Connection Dim RS As New ADODB.Recordset Dim MySQL As String Set Conn = CurrentProject.Connection RS.ActiveConnection = Conn
[code]...
I'll add the loop and array once I get this working but I'm stuck.
querycompany ="SELECT distinct company_id,company_name,location_id FROM appointment_detail,company where appointment_detail.location_id="&request.querystring("location")&"ORDER BY company_name"
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'appointment_detail.location_id='.
here is my query Code:SELECT FormatPercent(COUNT(ThreeWeekStatus.Status)/subQuery.Total) AS OnTimeTasksFROM RawData, ThreeWeekStatus, [SELECT COUNT(ThreeWeekStatus.Status) AS Total FROM RawData, ThreeWeekStatus WHERE RawData.OutlineNumber=ThreeWeekStatus.TaskId]. AS subQueryWHERE RawData.OutlineNumber=ThreeWeekStatus.TaskId And ThreeWeekStatus.Status="On Time";
and get the error "you tried to execute a query that does not include the specified expression....
basically have two tables ThreeWeekStatus (has TaskId and Status as columns) RawData (OutlineNumber, OutlineDescription, Category, etc)
RawData. Category has values like planed tasks, milestones, unplanned tasks, etc. ThreeWeekStatus.Status has values like on time, delayed, completed, late TaskId and OutlineNumber are the same
now I want to take all the tasks that are in both ThreeWeekStatus and RawData and get a percent of of which tasks are completed. also want to group this by category so in the end have it as 80% of the tasks marked as milestones have been completed thinking of the following for the percentage... (count number of tasks in both tables and marked as completed in ThreeWeekStatus table)/(count total number of tasks in both tables)
want to have similar queries for tasks that are on time, delayed, and late so there should be four
What I am trying to do is select the Max value in a field in a table in Access and set it to a variable. If I run the query from below in the query window it runs....when I try and launch if from code it bombs out....gives me an error:
ERROR: Run Time error '2342' A RunSQL action requires an argument consisting of an SQL statement.
I have other SQL queries in my code and they are running fine...whats differene about this one. How can I run it from the Query window and not from code?
CODE:
strSQL5 = "SELECT Max(POINTS_TO_PLOT_SQL.ID) AS MaxOfID FROM POINTS_TO_PLOT_SQL;"