Recent content by darag2358

  1. D

    Need help to speed up my text import

    Thank you, that is an excellent tip and explanation!
  2. D

    Need help to speed up my text import

    Thank you! Appreciate both of your thoughts. I will put them in to place and see if it helps. At least it is good to know that my code is basically correct, since this is the first time I have tried to import a text file in this manner. Thanks again, Dan
  3. D

    Need help to speed up my text import

    I have a big messy text file that I need to import and extract information from to go in to two tables. These are our mainframe security access rules and I need to compile the information from this file in to a database so that I can see who owns and has access to what screens. The file is...
  4. D

    Reliability

    I don't think I have enough knowledge to have even thought about that. This is a bit of a jump for me, not that I couldn't learn quickly. The databases I have created in the past have been primarily just for me and a few others. Can you provide some basic information or maybe know of a...
  5. D

    Reliability

    We are developing an Access 2002 database that is going to be used as a problem tracker for technical system issues. It will be used by about 20-30 people. At normal levels, about 7-10 people will be actively using it. The database will be stored on a Novell shared server. The tables will be...
  6. D

    Help on table structure

    Yes, that does make sense. I will try to implement that logic. Thanks for the help and taking the time to respond.
  7. D

    Help on table structure

    I am doing a database that keeps track of mainframe security access. If someone goes to a certain screen on our mainframe, their ID must pass verification on some behind-the-scenes access "rules". I am documenting what each rule does, what mainframe system the rules are for, and what rules are...
  8. D

    Need help to shorten a query

    Yeah, I was thinking about that last night. The first field in the table should be broken apart further. That will probably solve my issues. Thanks for the post.
  9. D

    Table structure

    Thanks Fornation's response was very helpful and is what I used to get my table set up. Doc_Man, your information is laid out perfectly for me to understand. I plan to use this information so that I can more easily automate this. This text file changes sometimes daily so it would be much...
  10. D

    Need help to shorten a query

    I have a lot of "Or"s in my query. I know there must be an easier way to write this, but I'm too new to this stuff. I was able to save the query, but now I can't go back in to design view because it says I have exceeded the 1024 character limit. It just takes me to the SQL code (see below)...
  11. D

    Table structure

    Thanks again. I modified your Excel macro slightly to suit my needs and was able to get this in to a usable table. Appreciate the help. Dan
  12. D

    Table structure

    Thanks, Fornation, but I have over 80,000 lines which exceeds Excel's max. On second thought, maybe I could just split this in half and then try what you have. I'll let you know on Monday. I too like Excel better for manipulating data and getting it in the order I need. However I'll still...
  13. D

    Table structure

    One unit will have access to multiple screens, so a many to one relationship exists. Here's a sample of actual data. As you can see, HOIO*0269 is listed multiple places. The entire file is about 30,000 lines. The "Key" is the screen name on the mainframe. Field1 $KEY(TG03) TYPE(CKP)...
  14. D

    Table structure

    I'm trying to import a messy text file in to a table so that I can run queries. How should I cleanup and organize my table? The information is a data security report that shows what kind of mainframe access each area in the company can have. When I import the file, it comes in as one column...
  15. D

    Delete a record if certain text is not found

    Oh, duh...can you tell I'm new to Access? Thanks!:o
Back
Top Bottom