access 07 help
i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database’forms’and reports..please help

Answer Question   |  May 5, 2008  1:18 PM
Access 2007, Database, Microsoft Access

How Can i restrict the user to insert next record
Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record [...]

Answer Question   |  May 29, 2008  11:23 AM
Access 2000, Microsoft Access, VBA, Visual Basic for Applications

Restricting the user to insert next record
Hai all, I have a subform which is in datasheetview mode , I have to validate the subform field s in such a way that if one of the fields is empty i will popup a msg like ‘must enter a value ‘ then the focus should goto that field and restrict the user to [...]

Answer Question   |  May 29, 2008  10:47 AM
Database, Database programming, Datasheet View, Form validations

Changing DB2 Short or Internal Names
We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001 and MAX_P00002 but no [...]

Answer Question   |  October 30, 2009  8:33 PM
Database, DB2/400

Grouping in a report
I want to group sets of data (from a query) in a report. The report will have a static header and footer (info from another query). I want a new page generated with each new grouping.

Answer Question   |  May 29, 2008  1:00 PM
Database reporting

MS ACCESS 2007 mass email list?
I was wondering is there a way to create a mass email from a query or table that would send out in MS OUTLOOK? I know of a way of extracting a table and importing it into OUTLOOK but my boss wants a more efficient way.

Answer Question   |  October 4, 2008  12:42 PM
Access 2007, Mailing lists, Microsoft Access, Microsoft Office 2007, Outlook

VSS
I am Using window2003 domain server and VSS. I have created a database for VSS and placed as Shared document. I found that it was deleted by one of our remote user. Now my question is that where i can check which user has deleted the data on network drives. plz tell me complete guidence [...]

Answer Question   |  September 28, 2008  6:18 AM
VSS, Windows Server 2003

Limiting characters in memo field
In Access how do I restrict the number of characters a user can enter into a memo field?

Answer Question   |  May 29, 2008  1:36 AM
Microsoft Access

What’s the best way to import an Oracle database?
I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each time [...]

Answer Question   |  August 23, 2008  2:16 PM
Database, Oracle, Oracle error messages, Oracle import/export, Oracle migration, Oracle replication

I need help with how to programmatically backup a database
I’m trying to programmatically backup a database using the following command: expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schema where “system_password” is the actual “system” password and “my_schema” is the name of the schema I want to export. How can I verify in an automatic manner that the export was successful? Searching the log file for the “successfully [...]

Answer Question   |  April 29, 2008  2:10 PM
Database, Oracle, Oracle backup

Running Procedures within the PL/SQL program
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

Answer Question   |  April 28, 2008  10:53 AM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures

Suggestions needed on continuing my Information Security Career
Hello………..I’m an IT professional with 5 yrs of experience in Software Quality Assurance and Information Security………….when I say InfoSec, I mean I have experience getting my organization ISO27001:2005 certified……………..mostly my job was concentrated on the Process Compliance part of it…………….and also the entire cycle of ISMS implmentation………………as my long dreaded dream I want to continue [...]

Answer Question   |  April 30, 2008  5:30 AM
Career in Information Security, Certifications, IT careers

Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we’re having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don’t know how to move the SQL database along with [...]

Answer Question   |  May 8, 2008  2:54 AM
ASP, Database migration, SQL, SQL Database, VBScript, Web development

What do I need to do to be a network architect?
Hi, I would love to embark on a career in network architecture. I am currently studying for the CCNA and I will be sitting for my exam in two weeks time. Apart from working towards being a network administrator (my short term goal), I have always had a desire to be involved in designing and [...]

Answer Question   |  February 26, 2009  8:01 PM
CCNA, Certifications, IT careers, IT jobs, Network architecture, Network design, Networking

bulk update in sql server 2005
hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance…

Answer Question   |  April 25, 2008  4:47 AM
BULK UPDATE, SQL Server 2005

SQL 2005 error code = 80004003: Invalid Pointer
After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following error when attempting to [...]

Answer Question   |  April 25, 2008  9:21 PM
Database, Servers, SQL, SQL Server 2005

Network design and infrastructure for a small business with on-site and remote access workers
My company occupies a small self-contained, single-story business unit (of which they are the sole occupants) which is part of a larger business park. They employ 24 staff comprising of a CEO, 5 administrators, 2 business development managers and 16 specialist consultants. The administrators and business development managers use PCs but the CEO and consultants [...]

Answer Question   |  April 25, 2008  9:00 PM
Database, Digital Private Circuit, Internet service providers, ISPs, Network design, Network infrastructure, Project management, Remote access, Servers, Small business (smb) technology projects, Small businesses, SMB, Storage

Bulk update in SQL Server 2005
I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?

Answer Question   |  April 19, 2013  9:49 PM
BULK UPDATE, SQL Server 2005

BLOB Data move from Oracle 9i to Oracle 10g
I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

Answer Question   |  April 24, 2008  3:58 PM
BLOB, Database, ORA-00942, Oracle 10g, Oracle 9i

How to restore MDF file as backup database
My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tired to restore as usual but it shows an error. Please help.

Answer Question   |  April 18, 2013  10:15 AM
Backup, Database, MDF, Restore