Missing Database Name and toolbar
Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

Answer Question   |  May 25, 2009  3:54 PM
Database name

skills
how to improve my hardware and networking skill. how to get good job in it. how to prepare to that. my qualification is bsc degree.am present am working as a hardware i will looking to good job so how to improve skill.

Answer Question   |  May 23, 2009  10:27 AM
IT careers

Making two records into one
I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail [...]

Answer Question   |  May 26, 2009  7:16 PM
CASE statement, SQL Records

master-detail forms
In a master-detail form when I query the master it returns the data, then I query for the detail records and it returns the detail data. When I try to add a detail record the application is also trying to add the master. I only want the new detail record. The master already exist.

Answer Question   |  January 8, 2010  6:23 PM
Database, forms

Changing BCP format file collation
Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. [...]

Answer Question   |  May 22, 2009  5:28 AM
BCP Utility, Collation, Format file, import/export

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