Cold Fusion and Data base application
I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link [...]
Answer Question
| November 12, 2007 12:15 AM
ColdFusion, Database, Microsoft Access
I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link [...]
Answer Question
| November 12, 2007 12:15 AM
ColdFusion, Database, Microsoft Access
Open MSAccess database
Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; “msaccess.exe”; “C:\MyAppsTest.mdb” ) currently I am using Shell that does require MSAccess.exe path. The problem is [...]
Answer Question
| October 24, 2007 6:55 PM
file open, Microsoft Access
Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; “msaccess.exe”; “C:\MyAppsTest.mdb” ) currently I am using Shell that does require MSAccess.exe path. The problem is [...]
Answer Question
| October 24, 2007 6:55 PM
file open, Microsoft Access
Synchronizing Two Subforms in MS Access
In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for the year/term [...]
Answer Question
| October 11, 2007 3:28 PM
Microsoft Access
In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for the year/term [...]
Answer Question
| October 11, 2007 3:28 PM
Microsoft Access
MS Access database
I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It [...]
Answer Question
| May 9, 2013 9:59 AM
Microsoft Access, Microsoft Access database
I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It [...]
Answer Question
| May 9, 2013 9:59 AM
Microsoft Access, Microsoft Access database
Changing an existing Export Specification in MS Access
I have added 2 fields to a table that is being exported to a text file. The export is done via TransferText and uses an Export Specification. I would like to know how to change the existing Export specification to add the two fields. I have tried various things in the File->Export wizard but nothing [...]
Answer Question
| July 18, 2005 3:39 PM
Microsoft Access
I have added 2 fields to a table that is being exported to a text file. The export is done via TransferText and uses an Export Specification. I would like to know how to change the existing Export specification to add the two fields. I have tried various things in the File->Export wizard but nothing [...]
Answer Question
| July 18, 2005 3:39 PM
Microsoft Access
- DB2 – RPG
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
Loading CSV files into Oracle tables
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]
Answer Question
| April 19, 2013 11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]
Answer Question
| April 19, 2013 11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
REPORT WAIT TIMES
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT experise to build or maintain, and will deliver maximum performance in terms of response time and data [...]
Answer Question
| March 7, 2005 10:03 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT experise to build or maintain, and will deliver maximum performance in terms of response time and data [...]
Answer Question
| March 7, 2005 10:03 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Front-End Reporting Tools for Secure Web Service Application with MS-SQL server
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS SQL server and will [...]
Answer Question
| March 2, 2005 9:49 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Hi… We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS SQL server and will [...]
Answer Question
| March 2, 2005 9:49 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Access 2003 Options Group
Most of my work is with VB and I always use option buttons within a frame. I’m trying to do the same thing in Access 2003 and I get an error message: You entered an expression that has no value. For simplicity this is what I’m doing: If Me.Option3.Value = 1 Then Msg = “A” [...]
Answer Question
| March 2, 2005 8:59 AM
Microsoft Access
Most of my work is with VB and I always use option buttons within a frame. I’m trying to do the same thing in Access 2003 and I get an error message: You entered an expression that has no value. For simplicity this is what I’m doing: If Me.Option3.Value = 1 Then Msg = “A” [...]
Answer Question
| March 2, 2005 8:59 AM
Microsoft Access
Improve MS Access performance on a Win 2k LAN
We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the [...]
Answer Question
| March 2, 2005 7:01 AM
Microsoft Access, Performance/Tuning
We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the [...]
Answer Question
| March 2, 2005 7:01 AM
Microsoft Access, Performance/Tuning
unrecognized data base format
hi, i had an application written with visual basic 6.0 with ms access data base (dao connection). it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp. some times when the users enter data,suddenly [...]
Answer Question
| June 16, 2012 3:27 PM
Microsoft Access, Visual Basic
hi, i had an application written with visual basic 6.0 with ms access data base (dao connection). it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp. some times when the users enter data,suddenly [...]
Answer Question
| June 16, 2012 3:27 PM
Microsoft Access, Visual Basic
Microsoft Access: Append Query problem
I have a table with a surrogate key created by Autonumber. I have data (in a linked spreadsheet) which I wish to append to that table. I would like to have the new data appended with automatically generated keys, but I cannot find how to do it (without writing a specific macro). If I try [...]
Answer Question
| January 26, 2005 6:35 AM
Access, Microsoft Access
I have a table with a surrogate key created by Autonumber. I have data (in a linked spreadsheet) which I wish to append to that table. I would like to have the new data appended with automatically generated keys, but I cannot find how to do it (without writing a specific macro). If I try [...]
Answer Question
| January 26, 2005 6:35 AM
Access, Microsoft Access
How do I check for changes in a database on insert / update?
Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in [...]
Answer Question
| December 17, 2004 3:08 AM
Microsoft Access, SQL Server, VB.NET, Visual Basic
Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in [...]
Answer Question
| December 17, 2004 3:08 AM
Microsoft Access, SQL Server, VB.NET, Visual Basic
