We have an access database that has multiple users for data entry. without fail, we end up with several "back-up" copies. Is this the result of the different users "saving" or is it from having shortcuts on their individual laptops?
Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.
How can I give database connectivity in code of C++, and my database is stored in Microsoft Access?
How to fill Combo Box at runtime in VB 6.0 ...I've used RecordSet object but rec.count of rs obj returns (-1). I have enough data in the DB. [Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL,...
How can I change the collation name of a specific database?
Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10...
I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
Can you please suggest me the code of how to connect Visual Basic6 and Oracle 10g, I am facing problems while connecting. Please do reply at your earliest. -Supriya
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?
Dear all, I like to calculate my database size. Can you tell me the views and formula to calculate my DB size please?
Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks
I am in charge of 10 computers and a server, I have them all on a workgroup and i can only use the database application installed on the server on the older computers. I try to use the same program on win xp but it says that the program is outside of the local intranet or on a untrusted source so...
I'm pretty new to database design so I'm trying to figure out how important foreign keys really are for the design. I know they aid the programmer to manipulate data but say the person already knows how to do that. Are they really necessary then? Thanks.
I've been designing a database table and I'm sorry if this is a stupid question but I need to know how long should a "firstname" be? For common fields (First name, last name and email address), what's a reasonable length for each? Appreciate the help.
I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...
When an application has been outsourced, Don't the software developer need to share the database structure with the client prior to development
Can someone tell me the importance of data modeling?
I tried to convert the text format to CSV format by USing internal table and the FM isSAP_CONVERT_TO_CSV_FORMAT. But wn i download to CSV format the file contains fields serepared by ';'.So becuse of this Im unable to Up load this file.
Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case. Each lawyer has a first and last name,...
I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.