I am currently creating a database to be used by many different people. I am the only person that makes updates to the database structure and design, but many people will be entering new data...
I have an existing Access Database that I use for my customer history and sales. What would be the best (and easiest) method of turning that into a totally online database. Basically we want...
I'm unable to connect to MSSQL 200O server remotely. I can connect to MySQL running in the same server without any problem. Also I dont have any firewall in the server. Plus i have enabled rem...
I have a database of 3,000 or so website urls that I want to be able to validate on a regular basis.
I don't have direct access, but can export the data in Excel, Access, or a similar app...
My understanding of :IN and :OUT in triggers is :old refers to a table before UPDATE and :NEW is table after UPDATE. If correct I'll need to emulate this behavior by explicitly populating a t...
Hello,
I need some advice with a query I have been working on. I have a query which appears to work, but I would like a guru's opinion as to whether it is the best way to go or not.
Sch...
Consider this scenario:
- You have a relational database holding 15 Gigabytes of data
- There are 18,336,325 transactions in just ONE table
- Analysis reports / queries take too much tim...
I have a table named ts_import_map with the following fields:
ts_userid (foreign key to the ts_users table)
ts_importsetid (foreign key to the ts_importoptionsets table)
The ts_user...
I've looked at this page:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
for Create Index... I'm trying to do this:
CREATE UNIQUE INDEX MyIndex ON MyTable(MyColumn) WITH IGNORE...
Hi Experts--
I have this so far and it returns the count of the top 7 . How do get the remainder in a single number?
Select TOP (7) Count (address1_state) as Expr1, address1_state
From L...
Just a general question.
I'm looking to build a database that houses rich text data. The key is that i need to be able to have a datasheet view in which the rich text formatting shows up c...
Here's a union statement I wrote:
SELECT convert(' Type or Select from Dropdown List', sql_varchar) AS DisplayLocNo,
convert(' Type or Select from Dropdown List', sql_varc...
Dear Experts
I wondered if anybody can help me with strange data that is automatically being added to the end of field values. For example i have a table that stores users login details wi...
Is there a change in Access 2003 where the hourglass no longer displays automatically when running a query? If I take a simple 2003 database (no forms, no vb code) with a rather large linked ...
I'm looking for a combination of cross-platform database and application development GUI to run on Windows to replace VB6/MsAccess. I'm looking at the Firebird and PostgreSQL databases to work...
Hi All,
Looking for a quick example of a SQL statement that will return all duplicate records in a specific table. Can anyone please post an example for this?
Appreciate any help.
Th...
I am trying to create a database of PC's on my network. I have the following fields:
ID
ComputerName
UserFirstName
UserLastName
UserDepartment
And several othe fields..
The Table...
i have a table in access the has the following fields:
date , time , area , loadvalue
and has some data as follows:
date time area loadvalue
1/1...
id group interval operation
1 a 1 1
1 a 1 2
1 b ...
I would appreciate if some one can direct me or provide information related to some standard data cleansing methods currently in use in data warehouse environment.
How do I do something like this:
I have a report which utilizes the page header section.
Page header section contains, patient name and address (from table PATIENT).
The report breaks for...
Hi all I'm using XP Tablet edition with Access 2007, I've tried using the Inkpicture ActiveX control in a new database (just to test/ play with it with a view to integrating into a larger data...
I have 3 questions
* Is there some function / command to check if the Fields of NCLOB, CLOB Datatype have Data or NOT(i.e. are empty)? NOTE - The respective Tables having these fields do co...
Hi, does anyone know anything about MS Access. We use a database which is designed in access 2000 I believe. This is located on a server - mapped drive f:\database
Clients connect to the da...
I am using access to reformat our online sales transactions so that I can export the data to a tab delimited file that is in the proper format for importing them into quickbooks.
I have a Que...
