Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Access process no longer updating student info system (dbIV) table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vc - 25 Jan 2008 00:15 GMT
We have an Access 2003 process to upload state ids from a txt file into the
necessary file with the student info system (S.I.S.) at each of our school.  
It was working ok until around 12/10/07.  The process appears to work just
fine, erroring out if someone is in the file we need to update, and running
an adequate amount of time for each school.  The file we are attempting to
change a field in is getting a new time/date stamp when we run the process as
well.  But, when we log into the application, the field is not updated.  The
problem isn't that the field is view only...all records already containing a
state id are still viewable.  Also, we removed all of the security in our
student info system and ran the process...same results, so the vendor advised
us it is not the S.I.S. app's security stumping us (we're not logging into it
to do the updates, so that wouldnt' make sense anyway).  

I run the process manually an am logged in as an admin with all rights to
the files we are attempting to update.

As someone with minimal Access experience, I have no idea what else to
check.
Allen Browne - 25 Jan 2008 02:41 GMT
Not sure if this is the cause, but I'm wondering if Service Pack 3 for
Office 2003 was the trigger for this problem, given the timing of when it
occurred.

Go to Help | About, and see if it says SP3 after Access 2003. SP3 did block
lots of file types:
   http://support.microsoft.com/kb/938810

There is also a hotfix for sorting out some of the problems introduced by
SP3:
   http://support.microsoft.com/kb/945674

If that doesn't fix it, see if the software still works on a machine with an
earlier SP.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> We have an Access 2003 process to upload state ids from a txt file into
> the
[quoted text clipped - 22 lines]
> As someone with minimal Access experience, I have no idea what else to
> check.
vc - 28 Jan 2008 15:30 GMT
Thanks...this wasn't the case (still SP2), but it sure helps to rule out the
possibility.  

> Not sure if this is the cause, but I'm wondering if Service Pack 3 for
> Office 2003 was the trigger for this problem, given the timing of when it
[quoted text clipped - 37 lines]
> > As someone with minimal Access experience, I have no idea what else to
> > check.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.