• Connect to Microsoft Access database

    I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value= "C:\Data.mdb" .Open .CursorLocation = adUseServer End With Can't i just change the...

    Blink.j5 pointsBadges:
  • Is this thumbnail made from which software?

    http://www.death-note.biz/up/img/770.jpg ↑ Is this thumbnail made from which software? It doesn't become this shape in Media Player Classic. Please teach me the software.

    Kaiten94820 pointsBadges:
  • RPG with Dynamic SQL Problem – SQLCOD 501/312

    I'm trying to do simple dynamic SQL in a program to select records for a subfile but it doesn't seem to be working. sSql = 'SELECT orderno FROM ordhdr ' 'WHERE custno = :scSrchCust '; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL...

    MMAGuy85 pointsBadges:
  • asp.net/c# session timeout

    hi , I am currently doing a login page. I would like to prompt the user by create a pop out text when the session is ending soon. After that the page will be redirected to the login page. can anyone help me with that. the following is my program. protected void Page_Load(object sender, EventArgs e)...

    Blue50 pointsBadges:
  • Object.MouseEnter and/or Object.MouseLeave

    I have built a program that is using 75 Control Buttons, laced in a Panel, on one form. Using a ForEach/Loop to loop through all 75 buttons, I am looking for the syntax (code) that will allow me to indentify which of the 75 buttons activated the ForEach/Loop by way on Object.MouseEnter and/or...

    PastorJ25 pointsBadges:
  • rows to columns

    I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny...

    Aabbccddee25 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • Problem in accessing menustrip items in VB.Net 2005.

    Hi everyone, I'm working with VB.Net 2005(.Net framework 2.0). I am having a problem in accessing the items in a menustrip of a form. Suppose there is an item in a menustrip named FILE. Under the FILE item there are 3 subitems- OPEN, SAVE and EXIT. Now, I wanna access and disable the 2nd subitem...

    Priyamtheone30 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:
  • SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • database sql,with vb coding,first time running not fast

    we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

    Micus20050 pointsBadges:
  • Using MAX data types in SQL Server

    I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

    Hank103925 pointsBadges:
  • Can I call upon the username of someone logged into the pc, and use it in a web link?

    Hi all, Basically, I've got a webpage I'm working on, and I'd like to be able to provide a link in that page, that will take a user into their home folder on the network. Since it'll be different for each user, but it uses their username as their home folder, I'm thinking there must be a way, to...

    Linger19740 pointsBadges:
  • Help with VBScripting – Beginner

    Attached is the script I'm working on for an assignment. I cannot get the count to work for the number of temps equal to the avgtemp. for each member in temps if member = avgtemp then count=count + 1 next What am I doing wrong? -------------------------------------------------------- Option...

    Chottenstine0 pointsBadges:
  • Lost Global Catalogue

    My Windows 2003 PDC recently died but prior to this I had transfered the operations master roles including schema master to my BDC. I was convinced my BDC was a Global Catalogue server but didn't get a chance to check before my PDC died. This happened just before I went away for 2 weeks and I only...

    ITBird15 pointsBadges:
  • API’s to copy data in physical volume to virtual hard disk(.vhd) file

    hi,i am using virtual server 2005.I need API's to write data into .vhd file..

    Neelu5 pointsBadges:
  • SQL Packages

    I have a query on SQL packages.Is it necessary to create an SQL package every time we connect to a remote system?Is there any other alternative?

    Sweta30 pointsBadges:
  • Query Criteria

    Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...

    Bec10 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following