Database

Best way to create a large access databases.

I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live with it. ...

Data Dynamic Activ Report Version 2.0

I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble ...

S/W course

hello sir/madam recently i m studying B.E final year but anyone plz suggest me latest s/w course which will be helpful if done b4 placements.... thanx Software/Hardware used: s/w

JDBC connection to DB2/400

Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...

start career

sir, I have completed my MCA in 2004,but not working after studies because I was in abroad with my family.Recently return back to chennai looking for good opportunity.I would like to start my career in ORACLE DBA.Which course in that will help me to start my career.Also can u suggest me any way to...

CONNECTION VB WITH ACCESS

how to connect visual basic 6 and msaccess 2003 by using connection string Software/Hardware used: VISUAL STUDIO 2005 WITH MSACCESS 2003

Msg 102, level 15, State 1, Line 14

Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

The IT Blog Top 10: Nov. 19, 2009

10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...

Access Tab Control Problem

I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

PHP and MS Access Database

I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...

SQL

is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible  with SQL to be able to have a box pop up that would ask for a specific input to the...

inactive timeout different for one user

can I set a different inactive timeout (logoff) for one user? Software/Hardware used: i5

To trap the item name of more than one item selected in list control

1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...

Datasheet view sorting question

Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list.  This is a repeatable problem.  Has anyone else experienced this problem? Software/Hardware used: Sharepoint 2007

foxpro 2.6 on windows 98

I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :-      " DO NESTING IS TOO DEEP " there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me the solution.   ...

Database being auto duplicate when exit.

hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...

Composite foreign Key in SQL Server

I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...

how to migrate repository from SVN to VSS version control in Linux based server

Hi Experts, I would seek the help to know how to migrate from SVN to VSS for version control in Linux based machines Which is better out of two,already we have svn setup

DECFLOAT - Internal Format

Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: "Convert and return a DECFLOAT representation of a number or string representation of a number", (Appendix A. Writing exit routines). There is an example there: Internal...

Erro in Subform in Ms Access Reports

Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...