• Reduce database size for archiving

    I have one database thta have lage size,now i am trying to archive that database,I al ready reduce 40,000 documents from that databse to archive Dbase,but still the database size is same, some please guide me it very urgent

    772620 pointsBadges:
  • Editing legacy rich text data in a browser

    My customer is moving to a web-only Domino environment and one issue we need to be able to handle is legacy rich text data. We have tons of databases including rich text fields of mixed data types - i.e. text, embedded images, attachments, etc. Editors such as TinyMCE and FCKeditor just cannot...

    RobertLiberman5 pointsBadges:
  • Formatting a subform for printing in access 2000

    I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the name of...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • Allow Additions Property on Subform In Form View in Access 2000

    I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view and...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • How to Determine Database Access on AS/400

    I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

    DaCurryman5 pointsBadges:
  • database

    I want to create a sample database for a company with employee of 5000+. The employee data will include name, address phone etc. and also have photograph of each employee. In addition, I want to create a list of meeting that some managers have attended and the issue that they have raised during the...

    Ss1425 pointsBadges:
  • Copying our disaster recovery database on a SQL Server

    We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don't want to stop it and lose consistency between disaster recovery and the production...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Locking Forms in Access 2000

    I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going through and...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • Combining fields to create a unique ID in Microsoft Access

    I have been working on a database for my research job.For our research purposes we are trying to create a unique identifier that tells us 4 things: 1) what study they are a part of, [this will be “QQQ” for EVERYONE] 2) what group they are in, [this will be a four digit number, such as 2222] 3)...

    FSUResA15 pointsBadges:
  • Access 2003 using IIf statement on a form

    I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for 'current grade' and a field for 'target grade'. I also have a field 'progress' in which I am using an 'IIf statement' to compare the two fields (to show either 'under...

    Malcplant35 pointsBadges:
  • New Access user!

    I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there's about 12 -15 copies. ( Example: mdb12 ) Is there a...

    Tami8550 pointsBadges:
  • How do I display a clickable link from database in table using PHP?

    I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print "<b>Here is my Information on you. <br><br>E-Mail me with any...

    BigAL095 pointsBadges:
  • Database Connection Error

    When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant) ODBC Oracle 8 Driver ORA-06550:Line1,Column8,PLS-00201:identifier’xxx.PRC_RI_REPORT’Must be Declared...

    Sandeepk6660 pointsBadges:
  • MS Access 2007 Author credit

    I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

    Lwbadgr5 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Microsoft Access Drop Down List

    Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was wondering if there was...

    RoadDust390 pointsBadges:
  • access 03 sending emails

    I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

    Bent4lf5 pointsBadges:
  • Dynamic/Data-driven page creation and content

    Hello! Sort of a "newbie", so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information - storeable/retrievable as a "unit", representing a particular "view"...

    Galaxis5 pointsBadges:
  • Macromedia Dreamweaver Dataset problem

    Hi, I'm new to web development and I'm working my way through the Dreamweaver manual (also in the PDF). It was going well well until I hit the wall in "Chapter 5 Developing a Web Application" (Page 69-82). My problem.... I can't seem to get "Live Data View" to work (bottom of P.66 in the PDF) When...

    Thomas12345 pointsBadges:
  • Word and Excel

    In MS Access you can create a form so when its all filled out the data is automatically put into an Excel spreadsheet under the correct headlines. Is this possible to do this with a form made in word?

    AerospacePJ5 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