 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Synchronizing Access 97 db with Access 2003
Good Day, I have been charged with converting a group Access97 db to an Access 2003db. But before completely converting over to the Access 2003 db I would like to ensure that most of the functionality of Access97 is working properly in Access 2003, formatting, links, tables, etc. Is there a way I can have users continue placing data into forms in Access97 and the information synchronize with the data in Access 2003, while I continue to monitor functionality in Access 2003? Let me know and thank you for any assistance you can provide Access 2003 can work seamlessly with Access 97 data. It will also work if you upgrade the data format to the default suggested Access 2000 format. As far as forms, etc go. Upsize a copy to 2000 or 2003 format and link it to either the original 97 format or the newly upgraded format. There are very few issues.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Good Day, > [quoted text clipped - 11 lines] > > Let me know and thank you for any assistance you can provide Good Day Arvin Meyer, I certainly appreciate the quick response and I thank you for the advice. I hope you do not mind some additional questioning. I have converted an Access 97 db to Access 2003 and it works well, with few issues that are format related. I would like to replicate the Access 97 db to Access 2003, and in doing so, do you have suggestions as to a good source for step by step instructions for replication; perhaps an external tool as well. One other question while I am thinking; I have several user that to often attempt to enter data into a form at the same time only to have information missing. Is there a way I can prevent someone from opening the same record at the same time, with a message stating the record requested is in use? Let me know Thanks > Access 2003 can work seamlessly with Access 97 data. It will also work if > you upgrade the data format to the default suggested Access 2000 format. [quoted text clipped - 17 lines] > > > > Let me know and thank you for any assistance you can provide Here are some Replication sources: http://support.microsoft.com/kb/282977/en-us http://www.dfenton.com/DFA/Replication/index.php?title=FAQ Look at the locking options in Tools >>> Options >>> Advanced and experiment with which one works better for you. I usually leave "no locks" on which doesn't lock anything until a save. That works best when users are not likely to be editing the same record. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Good Day Arvin Meyer, > [quoted text clipped - 45 lines] >> > >> > Let me know and thank you for any assistance you can provide |
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.