Recent content by pepperca

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

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

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.

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

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.

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

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

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

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

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

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

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.

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

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

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