• CPYF

    Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan't any data to be copied from LF1 to PF2 (dont want to use clrpfm after copying data) Is there...

    anuppdas105 pointsBadges:
  • Deleting a Table

    I have full permissions to a DB, but I can not delete a table.

    dshafer15 pointsBadges:
  • Modify Hexadecimal Flat File in AS/400

    Hi, I am working on a project, but have got stuck and I need expert advice. I received a flat file from another system (probably a Windows system) in AS/400. The flat file contains the data separated with hexadecimal (x'05') . The file I am receiving is through connect direct. My requirement is to...

    As400t10 pointsBadges:
  • Security

    Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.

    bgharrod5 pointsBadges:
  • Access Find the previous checkout record and add a return time

    I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record...

    TeaBone5 pointsBadges:
  • Database trends

    I am researching the following topic and need to find relevant articles. Database trends and their impacts on commerce.

    jms8420215 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 pointsBadges:
  • Basic O & M activities for any database server

    What are the basic O & M activities for any database server

    anshu4020 pointsBadges:
  • Difference between EAI middleware and TIBCO middleware

    Plesae explain difference between EAI middleware and TIBCO middleware.Which will be better useful for integration between two ORACLE database

    anshu4020 pointsBadges:
  • Are there any Pl/Sql like features in j2me?

    I want to deveplope a mobile game in which i want to use database and all its features which is possible in pc through oracle and sql...is there any way to use them in j2me? Is rms an answer? Can i use java db.?

    hussain22juzer530 pointsBadges:
  • SQL Server TempDB

    How do I clear data from TempDB?

    wertq5 pointsBadges:
  • Cannot find tables

    I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship....

    Chucky6665 pointsBadges:
  • Access 2003 Query

    I have a table (tblRents)with the following fields: RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the...

    kgonzales20 pointsBadges:
  • Date format in table

    I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show the age at death from...

    LostSpring5 pointsBadges:
  • Microsoft Access change

    I'm trying to add fields to a table that says it is read-only. I don't want that,  how do I turn it off?

    PG755 pointsBadges:
  • Access

    How do I change the selected columns to be required pieces of information?

    gooman5 pointsBadges:
  • Access field set to Scale =2

    How do I set a field Scale = 2?

    jcurry6510 pointsBadges:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • Problem with relating multiple tables

    access 2010 i'm not getting a good answer on my question on this form, i place the link here so i don't need to explane it againLink to forum

    Kwantakosta20 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.

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

Following