Retrieving Records based on Record Selection from another table
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables, equipment, etc that are in one table. For [...]

Answer Question   |  May 22, 2009  8:46 PM
Access Database, Microsoft Access, SQL Database

Q+A 5 Recover Database FAIL. Get File In Use
We are running Q+A 5 and cannot do a successful “Recover Database”. Get “FILE IN USE BY aaa, bbb, aaa, ccc, bbb, bbb, bbb” message. All users were out of Q+A. Also we had the users mentioned in message re-boot their XP PRO workstations. Please Note: UIDs repeat in the in-use message.

Answer Question   |  May 21, 2009  2:51 PM
Database Recovery, Q+A, Q+A 5

How can I synchronize three instances of MySql
I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.

Answer Question   |  May 20, 2009  4:25 PM
database synchronization, MySQL, MySQL Synchronization

Performance Issue with an Access File Updated through an .accde file with Linked Tables
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked tables [...]

Answer Question   |  May 19, 2009  6:27 PM
Access 2007, Access Database, Microsoft Access, Microsoft Access Performance

SQL or VBA code to loop through two columns of data
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product [...]

Answer Question   |  May 20, 2009  12:34 PM
Microsoft Access, VBA

Changing Database Collation
Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

Answer Question   |  May 20, 2009  9:23 AM
Collation, Database collation, SQL Server 2000

How a S/W in c# working in N/W accesses access database from other computer not having access
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn’t have ms-access, then how will i connect to it and run my project?

Answer Question   |  May 19, 2009  12:54 PM
Access Database, C#, Microsoft Access, Network connectivity

Database connectivity ASP.NET using C#
Hi, I’m new in ASP.NET so excuse me if this is a stupid question. I’m trying to connect a page to the database but there may be some problem. Please help me…… This the ASPEX file cod: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; [...]

Answer Question   |  May 8, 2013  5:41 AM
ASP.NET, C, Database connectivity, Web development

Unable to restrict the display to top N records in subform in Microsoft Access 2003
I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query “select top 10 * …”, it executes successfully in the query editor window [...]

Answer Question   |  July 16, 2009  4:27 AM
Microsoft Access 2003, Microsoft Access 2003 forms, Microsoft Access 2003 subforms

MSDTC Error with database/Windows Server 2003
I’m using two server 1.Application server(windows XP Pro SP2) and 2.Database server(windows server 2003). when execute an application that will connect to my machine for database access and next it’ll connect to DB server, at this time it produce “Communication Underlying Transaction has failed”.. then i searched so many forums, that says DTC error. Then [...]

Answer Question   |  May 29, 2009  7:17 AM
Database connectivity, Microsoft Distributed Transaction Coordinator, MSDTC, MSDTC error, Windows Server 2003

Paragraph marks in an ASP blog page.
My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but [...]

Answer Question   |  May 18, 2009  3:07 PM
ASP, Microsoft Access

AS400 RPG – last three digits of microseconds always zero!
We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits. However…pulling a microsecond(current timestamp) in an [...]

Answer Question   |  January 9, 2011  2:43 PM
AS/400, ILE RPG, RPG, Timestamp

Access 2007 removing completed data
I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

Answer Question   |  May 19, 2009  2:26 PM
Access 2007, Microsoft Access

Flat file to PF conversion
Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

Answer Question   |  May 15, 2009  8:40 AM
DB2 Physical File, DB2/400, DB2/400 primary files, Flat files, Physical File

Photo upload in a profile with PHP and MySQL?
Please help me by giving script for uploading and updating member photo in his profile using php and mysql

Answer Question   |  January 3, 2011  5:21 AM
MySQL, PHP, Web development

Free Chapter – Tuning database applications for performance
Another free chapter download is available on the IT Bookworm Blog. Written by: John Goodson and Robert A. Steward Book: The Data Access Handbook: Achieving optimal database application performance and scalability Overview: “Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the [...]

Answer Question   |  May 14, 2009  12:26 PM
Data access, Database applications, Database performance, Database scalability, Free Chapters, John Goodson, Prentice Hall, Robert A. Steward

How to implement row level security
implementing roe level srcurity

Answer Question   |  July 29, 2009  6:07 AM
Database security, Row Level Security

How to get delete history from schema
How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.

Answer Question   |  May 14, 2009  5:57 AM
Database programming, Database schema

After trigger select from other tables using joins
Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E…. even if those records had no action applied to them. I tried declaring variables from the [...]

Answer Question   |  July 30, 2009  3:48 PM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers

Multiple DELETE From Statements in Query Manager
How do I enter more than one Delete from …… where .. Statement from within Query Manager?

Answer Question   |  August 25, 2009  3:41 PM
DELETE statement, IBM DB2 Query Management Facility, Query Manager