Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Splitting a database Hello, I am working with an existing database with many objects already built into it and am wanting to understand a litlte bit more about splitting the database. It will roll out to about 15 users and I want to be able to update the tables behind the scenes while still allowing them to process information as need be. My question is can I continue to add new tables to the back end of t... 3 5/24/2007 8:08:17 AM DAO Synchronizing in Access 2007 As many of you may know, the new file format in Access 2007 abandons replication support (as well as user-level security). But the MDB format still supports replication (whether created in a previous version of Access or in 2007). However, there is a bug in the initial release of A2K7 that causes a DAO synch operation to error out. Microsoft has released a hotfix for this. See: http... 2 5/24/2007 8:08:08 AM Switchboard Not Found Hi Groupies I have a Access 2003 database that I have replicated. I have used the Switchboard Manager to create a switchboard for the database. When I open one of the replicas, I receive the error message that the "....Jet Database Engine cannot find the object "Switchboard"....". If I say OK at this message, then the exact same message shows up again. If I say OK again my switchboard... 5 5/22/2007 5:01:24 PM Backend bloating We have used a complex Access (02-03) medical billing application for 18 months. The backend is replicated (2 global replicas and a design master) and direct synch has been used only. Roving laptops log onto network locally to sync. There are about 50 tables and there are ~ 700 patient's entered. The back end has crept up from ~12 mb after initial replica creation to a current ~150... 11 5/13/2007 5:03:49 AM Possible with no network? Hi Groupies So having read far too much and feeling a little overwhelmed, my question is this? Is it possible to work with replicas without a network? I want to have project managers out in the field with laptops and I would like to keep an up to date copy in our office that contains information from everybody. They have the ability to email via wireless satellite. Do we have any... 5 5/7/2007 1:58:45 AM JRO Synchronizer Failure I am working with a computer loaded with VISTA and Access 2007 to test one of my company's Access applications under the new platform. We use replicated db's on laptops and synch them with the design master db located at our home office via the Internet. This particular application works fine on WindowsXP and Access 2003. When I try to syncrhonize the programs throws error -2147667259... 6 5/6/2007 10:14:07 PM Ϊ´ó¼ÒËÍ֪ʶ²Æ¸»À´ÁË ´ó¼ÒºÃ£®ÄúÏëÈÃ×Ô¼ºº¢×ÓѧºÃ֪ʶÂð£¿ÓиüºÃµÄδÀ´Âð£¿Ï£Íû¾ÍÔÚÓÚÄãµÄÁ˽⣬ÇëµÇ½http://hi.baidu.com/bainaojy5£® ... 1 5/6/2007 9:28:50 AM Do I need Replication or TransferDatabase? I have a database which will reside on the user's computer. Every few months or so I'd like to have the user be able to click a button to export all the tables to a file as a backup and have the users email that file to me. Also, every few months the user may need me to edit their data (i.e., append new records to the list) so again, they could send me their data, I manipulate it, then send... 11 5/4/2007 4:19:39 PM Replication newbie, please help. Dear all, I have a web application that uses access database. And a local windows application that uses exactly same access database structure. I want to synchronize databases. When new record added from web I want them into my local db. When my local db changes I want them to go my server database. Is this "replication" concept for this kind operation. there are many resources on the ... 2 5/3/2007 9:13:48 PM Error message 3167 record deleted and synchronisation Hi, I have a be end database which multiple users connect to via a front end. Users who have a laptop also have a version of the be database on there lcoal drives, which they synchronize with before going offline so they can use the database offline. Laptop users can no longer synchronize their be with the server be. New records from 5/4/07 are not added and I have found a record that h... 4 5/1/2007 1:51:22 AM Why do I keep getting the failure entries in the log? Time = 2007-04-26 04:00:09 PM Log Type = Refreshing the list of managed replica set members Time = 2007-04-26 04:00:16 PM Log Type = Managed replicas Replica = \\lc2000\LifeSeniorCaseManagement\ReplicatedDBTest\LSSCMReplica.mdb Replica = D:\Data\LifeSeniorCaseManagement\ReplicatedDBTest\LSSCMReplica.mdb Replica = \\Lifeba\LifeSeniorCaseManagement\ReplicatedDBTest\LSSCMReplica.mdb... 4 5/1/2007 1:48:53 AM Access Replication and Vista We have a custom application that is working just fine on XP. (Access XP with applicable service patches) Got a new system with Vista. The application installs without problems and runs fine; until we try to sync. The application does a dialup to our ISP, then initiates the sync via JRO. During the sync, we get the message: --------------------------------- Microsft Visual C++Runt... 10 4/30/2007 9:46:00 PM Runtime error I have created a frm that has the following code below associated with a cmd button: Before replicating the db and changing all of the autonumbers to random assignment, this button worked fine and took me to the correct form. After replicating, I now get the following error: "Error 6 (overflow) in procedure Begin_Interview_Click of VBA document Form_frmInterviewInstrument." I have re... 6 4/27/2007 7:56:07 PM FileDateTime I've written a VB.NET application that will automatically replace a client.ade application on a workstation with the one on the Server if the server is newer. It replaces the file based on the Modified Time using FileDateTime function. While testing this I've discovered a problem with this. The Modified time always changes and thus cannot be used. I need to due this on the Create Date ... 5 4/23/2007 5:34:06 AM how to remove "replicated" mark It is very easy to remove mark "replicated" from tables, but I don't know how make it for forms and modules? Ths ... 4 4/22/2007 3:56:34 PM Replication Steps Help Hi all, I have a backend/frontend environment on a LAN with speed of 100MBps. I now want to replicate the be so I can put a replica on a laptop that will be connected to the LAN but will be taken offline and into the field to enter data and then brought back into the office at the end of the day and synchronize the data (daily). I have been reading several postings on this newsgroup about r... 6 3/27/2007 7:58:28 PM ³ö¹úסË޾ƵêÊ¡Ç®ÇÏÃÅÓë·½·¨ "Ó¼ÙÆÚ" Ϊͬҵº£Íâ¾Æµê¼´Ê±Ô¤¶©Ó뼴ʱȷÈÏ£º ¢Ù άҲÄÉ - 3ÐÇ 42 Å·ÔªÆð ¢Ú ºº ±¤ - 3ÐÇ 55 Å·ÔªÆð ¢Û ¶¼°ØÁÖ - 3ÐÇ 59 Å·ÔªÆð ¢Ü ²¼Â³ÈÕ - 3ÐÇ 66 Å·ÔªÆð ¢Ý ÈÕÄÚÍß - 3ÐÇ 73 Å·ÔªÆð ¢Þ ²¨Ê¿¶Ù - 3ÐÇ 73 ÃÀÔªÆð ¢ß ŦԼÊÐ - 3ÐÇ 99 ÃÀÔªÆð ¢à θ绪 - 3ÐÇ 85 ¼ÓÔªÆð µç»°: 010-64892689, 010-64987025, ÍøÖ·: www.cosmosholidays.net, ÔÚÏß MSN : hotelwholesaler@hotmail.com, eurohotels@hotmail.com, sh... 1 3/27/2007 12:26:01 AM RepMan Won't Load All of a sudden, one of my remote computers won't load the synchronizer or the RepMan. I get the error that the "Replication Manager can't initialize the Microsoft Jet database engine, possibly because the VBA libraries can't be loaded." The box is running XP Pro, Access 97 SR-2b, Jet 3.51 SP3, ODE SR2. Access runs just fine. We uninstalled ODE completely and reinstalled - as well as Jet... 4 3/26/2007 4:26:56 PM Some but not all data synchs I have multiple users whose replicas (tables/queries only; forms etc. in separate mdb) were created on a shared drive then copied to laptops for data entry. The replicas are then copied back to the shared drive for replication with the design master. For some users, no data was synched. For other users, some but not all data was synched. For other users, all data was synched. Have any of ... 3 3/25/2007 9:18:07 PM Can I undo replicated front-end? IT person went out with terminal cancer and employee mistakenly replicated the front-end of our main database. No current backup as it just so happens our IT guy was working on system tape backup and it has been down for months. Is there a way to undo the replication of the front-end? ... 2 3/22/2007 2:10:44 PM Max locks per file when synching Hi all, I've got a database splitted between back-end/front-end, both secured. The back-end is replicated because I need to be able to work from a laptop and other users from the network. I think I followed all the good practices that I know of (secure-split-replicate, only tables in replicas, etc.). I just made a change to the design master (added two fields), and I want it synched to the... 4 3/20/2007 8:16:15 PM Replication and Runtime Hello All, I've developed several applications that use a mdb back-end and an mde front end that run using the access runtime license. I have run into a problem that I think might be solved by using replication on the back-end - but I'm not sure if that is even possible with a runtime application. Here's the problem: The client currently using my product "upgraded" his network to ex... 4 3/20/2007 8:14:23 PM Flopyy Access while running replica I am just starting to review the issues with Replication. I have replicated a file and created a Design Master. The replica was sent to my c: drive. I made some changes in the Design master (data only), then made changes to the replica. Everything updated properly when I synchronized. I then changed the same fields in the same table to check on conflicts. I am just working with my ... 8 3/20/2007 8:11:47 PM Distributing a replicated database over email I've read about some of the issues around 'illegal' movement of replicated databases, but I've been thinking about a different scenario for a while, and I thought I'd put it out for some input from the group. Here's the situation: I have around 50 remote users, most of which are not highly technically savvy. I need to get the replicated back end of a database out to these users. After i... 2 3/19/2007 7:19:58 AM Replication multi-field index problem In my Access 2K database, the users recently requested to make sure that the combination of a number of fields in a table (TblA) were unique. Therefore, I removed all the duplicates in my Design Master and created a multi-field index on these fields that makes sure that the users cannot enter any new duplicate values. Then, I tried to synchronise this backend (the Design Master) with the anot... 3 3/7/2007 8:28:43 PM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12