copy 1.2 GB mdb from pc to network
When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?
Answer Question
| April 19, 2012 6:04 PM
Exchange MDB, MDB, Microsoft Access
When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?
Answer Question
| April 19, 2012 6:04 PM
Exchange MDB, MDB, Microsoft Access
The most-watched IT questions this week: Oct. 6, 2009
Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to remove [...]
Answer Question
| October 6, 2009 3:48 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Netwokring, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to remove [...]
Answer Question
| October 6, 2009 3:48 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Netwokring, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
DB Web Interface
What would be the best language to use if I want to create a web interface for an Access DB? Security will be important, and users will need to make electronic certifications and have graduated levels of accessibility to the database and database output files.
Answer Question
| October 6, 2009 5:37 PM
Database, Web site design & management
What would be the best language to use if I want to create a web interface for an Access DB? Security will be important, and users will need to make electronic certifications and have graduated levels of accessibility to the database and database output files.
Answer Question
| October 6, 2009 5:37 PM
Database, Web site design & management
The IT Blog Top 10: Oct. 1, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. 8. Does Larry care about Oracle customers? When [...]
Answer Question
| October 1, 2009 3:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. 8. Does Larry care about Oracle customers? When [...]
Answer Question
| October 1, 2009 3:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
not a valid Query Management variable.
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement 3500, instruction X’0021′. Can [...]
Answer Question
| October 8, 2009 11:32 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement 3500, instruction X’0021′. Can [...]
Answer Question
| October 8, 2009 11:32 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables
Working TRIGGER and TRANSACTIONS QUESTION
Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table, which fires an an AFTER [...]
Answer Question
| October 1, 2009 6:25 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table, which fires an an AFTER [...]
Answer Question
| October 1, 2009 6:25 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
General ODBC Error – Why
I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = “SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME, SCHED_TASK_EXEC.EXEC_STATUS_B, SCHED_TASK.DESCRIPTION FROM CPSLIVE.SCHED_TASK SCHED_TASK, CPSLIVE.SCHED_TASK_EXEC SCHED_TASK_EXEC WHERE SCHED_TASK.TASK_ID = [...]
Answer Question
| September 30, 2009 4:54 PM
ODBC, ODBC Errors, SQL
I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = “SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME, SCHED_TASK_EXEC.EXEC_STATUS_B, SCHED_TASK.DESCRIPTION FROM CPSLIVE.SCHED_TASK SCHED_TASK, CPSLIVE.SCHED_TASK_EXEC SCHED_TASK_EXEC WHERE SCHED_TASK.TASK_ID = [...]
Answer Question
| September 30, 2009 4:54 PM
ODBC, ODBC Errors, SQL
DB2 Web Query record count
Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?
Answer Question
| October 1, 2009 3:59 PM
DB2, DB2 Web Query
Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?
Answer Question
| October 1, 2009 3:59 PM
DB2, DB2 Web Query
Embedded SQL
In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field [...]
Answer Question
| September 29, 2009 9:29 PM
Embedded SQL, SQLRPGLE
In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field [...]
Answer Question
| September 29, 2009 9:29 PM
Embedded SQL, SQLRPGLE
HOW TO ADD REPORT IN MENU FOXPRO 2.6
HI I AM ANKIT, I HAVE MADE A SOFTWARE WITH REPORTS, SCREEN, MENU. BUT I DON’T NO HOW TO ADD REPORTS IN DIRECTLY MENU SO PLEASE TEL ME.
Answer Question
| September 28, 2009 11:32 AM
FoxPro, FoxPro 2.6, FoxPro 2.6 for WINDOWS
HI I AM ANKIT, I HAVE MADE A SOFTWARE WITH REPORTS, SCREEN, MENU. BUT I DON’T NO HOW TO ADD REPORTS IN DIRECTLY MENU SO PLEASE TEL ME.
Answer Question
| September 28, 2009 11:32 AM
FoxPro, FoxPro 2.6, FoxPro 2.6 for WINDOWS
Forms in Access 2007
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How [...]
Answer Question
| June 30, 2010 7:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How [...]
Answer Question
| June 30, 2010 7:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic
AS400, SQL and COBOL anomalies
I coded an update query in COBOL and included COMMIT=NONE so the update could go through. When the COBOL program executed it returned nulls, and coalesced the value to the default. When the query was executed either through qmqry or on-line on the sql screen it worked fine and updated the field properly. I also [...]
Answer Question
| October 28, 2009 5:31 PM
AS/400, COBOL, Embedded SQL, iSeries
I coded an update query in COBOL and included COMMIT=NONE so the update could go through. When the COBOL program executed it returned nulls, and coalesced the value to the default. When the query was executed either through qmqry or on-line on the sql screen it worked fine and updated the field properly. I also [...]
Answer Question
| October 28, 2009 5:31 PM
AS/400, COBOL, Embedded SQL, iSeries
Access for Windows 5.4
On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.
Answer Question
| September 25, 2009 5:11 PM
AS/400 printing, iSeries, Microsoft Access
On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.
Answer Question
| September 25, 2009 5:11 PM
AS/400 printing, iSeries, Microsoft Access
Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done [...]
Answer Question
| September 24, 2009 3:35 PM
AS/400, Embedded SQL, Microsoft SQL Server
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done [...]
Answer Question
| September 24, 2009 3:35 PM
AS/400, Embedded SQL, Microsoft SQL Server
Office 2007
I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I [...]
Answer Question
| September 23, 2009 2:38 PM
DB2, Office 2007, QMF
I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I [...]
Answer Question
| September 23, 2009 2:38 PM
DB2, Office 2007, QMF
Error 2282 in Microsoft Access
Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error “2282 – the format in which you are attempting to output the current object is not available.” on other users [...]
Answer Question
| October 6, 2009 4:26 AM
Access reports, Microsoft Access, Micrsoft Access reporting
Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error “2282 – the format in which you are attempting to output the current object is not available.” on other users [...]
Answer Question
| October 6, 2009 4:26 AM
Access reports, Microsoft Access, Micrsoft Access reporting
The most-watched IT questions this week: Sept. 22, 2009
Curious as to what the most popular IT questions and answers are on ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.
Answer Question
| September 22, 2009 2:32 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Curious as to what the most popular IT questions and answers are on ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.
Answer Question
| September 22, 2009 2:32 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
SQL join two counts on same table
I have two different SQL statements that each is a count on the same table, but a count of different columns. I’m trying to combine them into a single statement, but am having trouble doing so. The two statements are: SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw` WHERE 1 group by `photoIDWinner` and [...]
Answer Question
| September 21, 2009 6:17 PM
MySQL query, SQL
I have two different SQL statements that each is a count on the same table, but a count of different columns. I’m trying to combine them into a single statement, but am having trouble doing so. The two statements are: SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw` WHERE 1 group by `photoIDWinner` and [...]
Answer Question
| September 21, 2009 6:17 PM
MySQL query, SQL
How do I set decimal places with VB Access
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number of decimal places displayed in the [...]
Answer Question
| September 21, 2009 11:55 AM
Access 2000, Microsoft Access, VB, Visual Basic
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number of decimal places displayed in the [...]
Answer Question
| September 21, 2009 11:55 AM
Access 2000, Microsoft Access, VB, Visual Basic
dbcc checkdb error; object id 0
Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to [...]
Answer Question
| September 16, 2009 11:15 AM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to [...]
Answer Question
| September 16, 2009 11:15 AM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
