Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Overflow problem, please help

Discussion in 'Information Technology' started by SuzyQ, Oct 29, 2005.

  1. SuzyQ

    SuzyQ
    Expand Collapse
    Guest

    I installed several patches. It should be up to date now, but I'm still
    having the issue. We are planning to upgrade that system and the other 98
    systems to XP before the end of the year. The database is secured so I can't
    just send you a copy without unsecuring it first. Since I don't spend that
    much time in the office, I won't have the time to spend on doing that,
    although is was a generous offer. I may take you up on that in the future if
    the problem persists beyond the upgrade of the system. Thanks for you help.

    "SuzyQ" wrote:

    > The last new software installed on the machine was over 2 months ago, and the
    > database was fine every day until about a week or so ago. The reports that
    > she runs are run on a daily basis so it's also not a case of just not needing
    > that part of the system until recently either. When I get back on Thursday
    > I'll check out your other suggestion. If you think of any others please let
    > me know.
    >
    > "Tom Wickerath" wrote:
    >
    > > Hi Suzy,
    > >
    > > Sometimes something as innocent as installing a new software application can
    > > cause other applications to break. Was any new software recently installed on
    > > this PC?
    > >
    > > Also, you might want to run a chkdsk /f command, clear the temp. folder of
    > > garbage, compact any e-mail folders, and perform a defragment operation on
    > > the hard drive of this PC.
    > >
    > >
    > > Tom
    > >
    > > http://www.access.qbuilt.com/html/expert_contributors.html
    > > __________________________________________
    > >
    > > "SuzyQ" wrote:
    > >
    > > I did try with a fresh copy of the FE. I'll have to check the service pack
    > > with I get back in the office next week, however it is only recently that the
    > > problem has occurred with no changes to the FE, and no changes to the PC just
    > > prior to the problem.
    > > __________________________________________
    > >
    > > "Tom Wickerath" wrote:
    > >
    > > Hi Suzy,
    > >
    > > Do you have the latest service packs for operating system, Access 2002 (SP3)
    > > and the JET database engine installed on this user's PC (and on all user's
    > > PC's for that matter)?
    > >
    > > How to keep a Jet 4.0 database in top working condition
    > > http://support.microsoft.com/?id=303528
    > >
    > > You might try refreshing the copy of the FE app. on this user's PC. Perhaps
    > > it has suffered some form of subtle corruption. Grab a copy from another PC
    > > and try it on this machine.
    > >
    > >
    > > Tom
    > >
    > > http://www.access.qbuilt.com/html/expert_contributors.html
    > > __________________________________________
    > >
    > > "SuzyQ" wrote:
    > >
    > > Access 2002
    > > I have a split access database set up installed on several machines is the
    > > front end, the back end is on the server.
    > >
    > > The problem I'm having is with a windows 98 machine. It was working fine
    > > until just recently. Now when the user goes into the database, she can go to
    > > any of the forms back and forth without any issues. As soon as she runs a
    > > report, the report works, but when it is finished anything else she clicks on
    > > gives an overflow error message.
    > >
    > > I only work on Thursday afternoons so if you reply I probably won't be able
    > > to respond until next week, but please help me resolve this issue.
    > >
    > > I have one other user using a 98 machine, and all the other users use XP
    > > machines. None of them are having any issues. Nothing was changed on the
    > > machine in question prior to this happening so I'm at a loss as to what it
    > > could be.
     
  2. Loading...


  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Suzy,

    If you are talking about Access security, that won't present any problem for
    me. As you may or may not know, Access security is not all that secure. In
    that case, I'd just need a copy of the workgroup information file (.mdw) in
    addition to the front-end (FE) and back-end (BE) databases. As I mentioned
    before, you can delete all records from all tables in the BE database. I do
    not need to have the actual data in order to perform an analysis.


    Tom

    QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    "SuzyQ" wrote:

    I installed several patches. It should be up to date now, but I'm still
    having the issue. We are planning to upgrade that system and the other 98
    systems to XP before the end of the year. The database is secured so I can't
    just send you a copy without unsecuring it first. Since I don't spend that
    much time in the office, I won't have the time to spend on doing that,
    although is was a generous offer. I may take you up on that in the future if
    the problem persists beyond the upgrade of the system. Thanks for you help.
     
  4. SuzyQ

    SuzyQ
    Expand Collapse
    Guest

    Ok, I've already zapped the tables and packed them...oops foxpro lingo. I
    emptied the data tables and compacted the database. I'll zip it up next
    Thursday and send it to you with the workgroup file. Thanks for the help.

    "Tom Wickerath" wrote:

    > Hi Suzy,
    >
    > If you are talking about Access security, that won't present any problem for
    > me. As you may or may not know, Access security is not all that secure. In
    > that case, I'd just need a copy of the workgroup information file (.mdw) in
    > addition to the front-end (FE) and back-end (BE) databases. As I mentioned
    > before, you can delete all records from all tables in the BE database. I do
    > not need to have the actual data in order to perform an analysis.
    >
    >
    > Tom
    >
    > QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > __________________________________________
    >
    > "SuzyQ" wrote:
    >
    > I installed several patches. It should be up to date now, but I'm still
    > having the issue. We are planning to upgrade that system and the other 98
    > systems to XP before the end of the year. The database is secured so I can't
    > just send you a copy without unsecuring it first. Since I don't spend that
    > much time in the office, I won't have the time to spend on doing that,
    > although is was a generous offer. I may take you up on that in the future if
    > the problem persists beyond the upgrade of the system. Thanks for you help.
     

Share This Page