Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pepperca

    Delete file in My Network Places

    I have a file located in a library on our server. It is linked to My Network Places. I can go into explorer and delete the file and it is removed from the server. Does anyone know how to do this programmatically? I have found code to remove the link, but this is not what I want to do. I...
  2. pepperca

    Database locked

    I have a split database in Access 2003. Users were able to use this database yesterday and 1 person used it this morning. Now the frontend will not allow them to get to any data. I checked the Backend and when I tried to open it I got the message Could not use databasename.mdb file already in...
  3. pepperca

    Data corruption

    All links are good and references seem fine. Any other suggestions would be appreciated. I think I may try to have her version of office reinstalled.
  4. pepperca

    Data corruption

    No names changed. This problem is happening for this one user. She has refreshed her copy of the front end.
  5. pepperca

    Data corruption

    There was no calculation involved for the data she was trying to enter. She was entering text in a comment field on a form. The data goes directly into a linked table. She had updated several records before this happened.
  6. pepperca

    Data corruption

    We tried this and we even gave her a freash copy of the front end and it happened again. Cindy
  7. pepperca

    Max No. of records - this is not a question

    I have a table with almost 3 million records in it. It is in a back end database. I link to this table. However, if the actual size of a database approachs or exceeds 1 gig. strange things begin to happen. You get error messages that have nothing to do with what the actual problem is. Cindy
  8. pepperca

    Data corruption

    I have a database in 2003 that has a front end on the individuals pc and the back end on a server. I have one user that has had the same problem a couple of times. When editing data the record she is working on looses her data and fields display ## or error or numbers that don't make since for...
  9. pepperca

    Slow on Server

    I can modify the program. The files are linked and based on an account selected from a form a portion of the information in the table is loaded to a temporary table to be used in code. The linked table contains many different accounts. I think I found the problem for one particular account the...
  10. pepperca

    Slow on Server

    The linked files are used for part of the process. I'll try to remove the link after that portion is complete. Thanks
  11. pepperca

    Slow on Server

    I have an Access database that is loaded on a pc but links a couple of tables from a server. Most of the processing does not use these linked tables. When I run this program from home with no links in runs in about 1 hour. With links to server it takes 4 to 6 hours. My machine at home is...
  12. pepperca

    Importing Spreadsheet

    I don't think this would help because I would have to know the sheet name and I won't always know this information without actually opening the Workbook.
  13. pepperca

    Importing Spreadsheet

    I have the following piece of code attached to a button on a form. It works great if you only have one sheet in an excel workbook to import. However, the particular workbook I am trying to import from has 2 sheets and I need to import both of them. The sheet names will change from time to...
  14. pepperca

    Pass data to Mapquest

    Thanks for the info. I just got around to trying it and could not get it to work. It does not like Application.FollowHyperlink. Cindy
  15. pepperca

    Pass data to Mapquest

    I have a form with a customers address. I would like to pass this information to Mapquest. Is there a way to do this? Any help is appreciated. Thanks, Cindy
  16. pepperca

    Losing records

    There are no delete queries that run at night. I'm supposed to go in and check it tomorrow I will know how big the backend is then. At what point do you start having corruption problems? How do you track deletions? Thanks, Cindy
  17. pepperca

    Losing records

    No there is no replication. All sites are connected to the main office server.
  18. pepperca

    Losing records

    I have a client who uses a program in Access XP at multiple sites. Occasionally, they say they are losing records. They enter an order one day and the next it is gone. They say they are not deleting the order. Does anyone have any ideas why this would occur? I appreciate any help. Cindy
  19. pepperca

    Pass data from form to internet

    I have an Order Delivery AccessXP database. When someone calls in for an order there is a delivery fee if they are more than 10 miles away. What I want to do is pass the customer address entered in the form along with our business address to something like MapQuest to get directions and...
  20. pepperca

    Unrecognized database format

    GDGarth, Thanks for the help I found the file. Cindy

Part and Inventory Search

Back
Top