Search results

  1. G

    Access has encountered a problem and needs to close

    I experienced the exact sort of problem just last month. The fix for me was the latest Windows XP Service Pack (I believe it is 3)... our IT dept had not updated any of the machines so I snuck it in out of desperation and installed it on my machine only- the problem has not recurred.
  2. G

    Security Error 3033- MSysTables?

    Hi all- I thought I had successfully created workgroup security! I created a workgroup for a split database (front end on user's pc/ back end on shared network) containing 3 groups- Developer, AppUser, AppViewer. I also created a single user for each group. Everything works fine on my pc...
  3. G

    Silly Question- Verify a File Path?!

    Thanks... I couldn't see the forest for the trees!
  4. G

    Silly Question- Verify a File Path?!

    All, I have been looking through the board and just can't seem to find this simple thing... At setup, my users can specify a filepath to save various things to. I would like to verify that the filepath is valid. I know how to look for a specific file in a folder, but I'm just not getting...
  5. G

    Help with SQL Join Query

    Well, here is what I did: I made the few queries I needed in SQL and then used code to change the table sources in the SQL and save the new querydef (if it was different). This worked like a charm for the new forms I added to the application, but the existing forms seemed to lose their...
  6. G

    Help with SQL Join Query

    Thanks for the clarification- sounds like a querydef is where I want to end up. So it sounds like I have 2 options: 1- Create a working SQL and save it as a querydef 2- Use the query builder & build a query for each clone, then assign the correct one to a querydef via code depending on the...
  7. G

    Help with SQL Join Query

    Thanks for the input... I have not used querydefs before so I need to do some reading.
  8. G

    Help with SQL Join Query

    Thanks neileg... that option was considered when this app was first created. I decided to use clones for several reasons- the backends reside on a very slow network & there are several fields of the memo type, etc. As the databases grow, I am confident single tables would bog it down. The...
  9. G

    Help with SQL Join Query

    Hi all, this is my first post to the board. I’ve been searching through the forums but haven’t been able to put all the pieces together on my problem. First some background on my application: I have 3 tables ISSUES, UPDATES, and PRTS. Each record in ISSUES has several records in UPDATES, and...
Back
Top Bottom