Assign Indicators to an Access Table
I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks

Answer Question   |  June 7, 2010  6:38 PM
Access 2003, Access query, Access Tables

DBFs into SQL Server 2008
Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once [...]

Answer Question   |  June 4, 2010  3:28 PM
DBF file, SQL Server 2008, SQL Server import/export

connectivity between c++ and ms access
hi, i have problem releted with ms acess and c++ programming languge sir cant get any information about connection between ms acess and c++ programming languge give me steps to connect ms acess and c++

Answer Question   |  June 1, 2010  5:15 PM
Microsoft Access, Programming Language, TurboC2

How to Set Active Period in a Table
There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this should [...]

Answer Question   |  June 1, 2010  4:46 AM
Access 2003, Access Records, Microsoft Access

Access restrictions based on MAC
I have developed a dbase system using MS Access and .net which is a multi-user system, database being intsalled in primary server. I would like to restrict access / usage by applying MAC address. Plz advise on steps and codes. Thank you.

Answer Question   |  May 31, 2010  8:29 AM
Access Database, Access database permissions, MAC address, Microsoft Access

How to Set Active Period in a table
I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of “ActiveDeactive” is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time

Answer Question   |  June 1, 2010  12:03 PM
Microsoft Access, Microsoft Access tables, Toggle buttons

MICROSOFT INTERCHANGABILITY
Does Word, Excel and Acess work together interchangeably?

Answer Question   |  May 27, 2010  6:20 PM
Interoperability, Microsoft Access, Microsoft Excel, Microsoft Word

Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010
Join us for the next Microsoft Live Chat on Tuesday, June 1 at 11 am ET. SharePoint 2010 allows your company to quickly respond to changing business needs. Your people can share ideas and expertise, create custom solutions for specific needs and find the right business information to drive your business forward. Sign up for [...]

Answer Question   |  October 31, 2011  2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Linking Access to SQL Server
Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

Answer Question   |  November 9, 2010  6:52 AM
Linking Access and SQL Server, Microsoft Access, SQL Server, SQL Server 2005

Trouble creating SQL statement from MS Access Form
I’m creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while using the single [...]

Answer Question   |  May 10, 2013  9:51 PM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista

anybody can tell me that how to create setup which will accept database name & server name
anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

Answer Question   |  May 24, 2010  10:23 AM
.NET, Database name, Setup and deployment, SQL Server, SQL Server name

alter database
HI, when i run the command alter database northwind set multi_user with rollback immediate the northwind database shows ACCESS denied and tagged as SINGLE USER i donot understand why it so .can u pls explain .

Answer Question   |  April 11, 2011  10:36 AM
Northwind sample database, Run Commands, SQL Server

Lotus Notes mailfile database deleted automatically
Hi, one of our user’s mailfile database has been deleted automatically in our server without any error in our server logs? Is there any way we can retrieve it? or is there any way we can trace its cause? We have server logs though but we cant find the cause in it. Please help

Answer Question   |  May 28, 2010  4:26 AM
Database Recovery, Lotus Notes 8.0.1, Lotus Notes errors, Lotus Notes Mail Backup, Lotus Notes Mail File

sql query
I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN’T NOT RESPOND??

Answer Question   |  September 2, 2011  9:33 AM
SQL queries, SQL Query

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite

Calculate Business Hours
I found a VBA code that fits the program I’m trying to create but I’m having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result = 0 [...]

Answer Question   |  May 21, 2010  6:48 AM
Access 2007, Access 2007 alerts, Microsoft Access, VBA

what is base 2 to base 10?
what is base 2 to base 10?

Answer Question   |  May 19, 2010  2:09 AM
Base 10, Base 2, Binary, Binary data, Hard drive space

What is a good OpenSource program for CRM?
We’ve been using Maximizer for years. Our company has sfound that we do not use all of the features of it. We are seeking a change to a less cumbersome CRM program. There are two people to use the program for Customer lists, contacts, e-mail, notes, calendar, word processing. Any thoughts to share? THANKS!

Answer Question   |  June 4, 2010  7:54 PM
CRM, Database import/export, Maximizer, OpenSource Software

MySQL brain teaser
This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “ [...]

Answer Question   |  May 19, 2010  3:00 PM
MySQL, MySQL query, SQL

How to get mutiple client lines to appear on a single line
I have a table in Access with mutiple rows of client information that I would like to see on a single line. Ex: Henry Ford in Q1 had 17 orders in Q2 he had 22 in Q3 had 11 orders in Q4 he had 35. Right now there are separate lines for Q1, Q2, Q3, [...]

Answer Question   |  May 18, 2010  1:33 PM
Microsoft Access