Database

Access 2003 default record locking

I'm working with a multi-user Access system. When I change the default record locking option via Tools/Options/Advanced and then save the database, the other users still have the original setting for record locking, i.e. the change I have made is not shown on their machines. Shouldn't the change I...

what is rack awareness of HDFS?

What is reck awareness of HDFS and how can i optimize the network bandwidth using replication factor 2 ?

Improving the initial speed of a SQL query

I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

How to pull a query on a particular table based on form selection

Ok this is not as simple as the title suggest, this is what I'm trying to do: I have a database with about 30 tables (which are actually linked to Excel spredsheets). I need to be able to query each table and make a report only showing certain information for it. I started by doing individual...

database saves to new file

Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.

converting single user foxpro 2.6 application in to multiuser application for use on local network

i have developed a single user application in foxpro 2.6.How can i use it as multiuser application on a local network.What commands should i use so that each workstation can acess data stored in d drive of server.

Advance database menagement system

How I secure my data

store image from a directory into oracle database using sql

i have a directory containing 1000s of photos which i have to upload into oracle 9i db. i need to use only sql plus for this. i want a simple material to upload all those photos..

SQL Server 2005 Query Very Slow in the first run

Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

Xml Reader in oledb

how can i get ExecuteXmlReader() in OLEDB? i used sql server databse in my project. but now i want to change it to OLEDB. but ExecuteXmlReader() is not in OLEDB. what can i do to solve this? pls reply.

Modify MS Access using iSeries RPGLE

I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

new to IT looking to improve & make career in networking

hello expetise , myself being a student of 3rd yr computer engineering , actually i m not good @ language so suggest me course detials in network or system management ,what kind of basic should i have that will help me in course + referr me some books online to bulit my base? , hope your reply as...

Access Switchboard Problem

The title of the switchboard changes to the title of one of the items. I can't figure out why.

certification help

hi which certification done is to be better either Oracle or Red Hat Linux? I dont have interest in programming so Is Administration is only field for me? please guide me Thanks

select parent where more than one child

I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

We are runing V5R1 OS400, how do I write to CSV file

We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

External document used as an Access Form?

I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...

table from gridviewwith sql vs2008

hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the...

Slow SQL Query

when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

Connection of Crystal Report 2008 with VB6.

Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..