 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / June 2006MS Access 2002 running on MS Office 2003 Professional
I have an Access 2002 database on a network server that allows multiple people to enter the dB. However, if both attempt to update data simultaneously, a 'disk or network error ' message pops up and the data are lost. I have checked the cabling and the network card and all appear to be working fine. If I run this same dB on another network that is running Windows 2000, the error does not occur. Does anyone know if a 'disk or network error' message will appear if the dB and the MS Office software are different versions? Currently the set up is an Access dB built in XP Office professional copied onto a network running MS Office Pro 2003... >I have an Access 2002 database on a network server that allows multiple >people to enter the dB. However, if both attempt to update data [quoted text clipped - 4 lines] >know if a 'disk or network error' message will appear if the dB and the >MS Office software are different versions? Disk or Network Error almost always indicates a hardware or connection problem of some sort. Is there only one particular computer on which you get this message. You can run A2000 MDB/MDEs in A2002 and A2003 so that's not your problem. Have you split the MDB into a Front end and back end? You want to split the MDB into a front end containing the queries, forms, reports, macros and modules with just the tables and relationships. The FE is copied to each network users computer. The FE MDB is linked to the tables in the back end MDB which resides on a server. You make updates to the FE MDB and distribute them to the users, likely as an MDE. See the "Splitting your app into a front end and back end Tips" page at http://www.granite.ab.ca/access/splitapp/ for more info. See the Auto FE Updater downloads page http://www.granite.ab.ca/access/autofe.htm to make this relatively painless.. The utility also supports Terminal Server/Citrix quite nicely. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Reply to this Message |
 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.