Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Linked table somehow became local? Has anyone ever experienced this? I can't imagine how it happened. I've been working with a front end called IM.mdb which points to a replica on the network callled InterfaceUpdate.mdb incidentally, there is a local replica in c:\IM with the same name InterfaceUpdate.mdb... The only code that I can think that would have caused this is my synchronizing code which goes like this: ... 4 12/9/2005 1:04:44 AM 3703 Error due to DAO 3.6 / Jet 4.0 when running the following code: Set dbLOC = OpenDatabase("C:\IM\InterfaceUpdate.mdb") dbLOC.Synchronize "R:\QUEST\Bridges\InterfaceUpdate.mdb", dbRepImpExpChanges I receive the following error: Run-time error 3703 Operation not supported on replicable databases that have not been converted to the current version This is the code I have in my linked Front-End in C:\Windows\Desk... 6 12/9/2005 1:04:03 AM A good book or reference source for Replication in Access 2003 Can any one suggest a good book or reference on Replication in Access 2003? I have "Access 2000 Developers Handbook" by Litwin, Getz and Gilbert and also "Access 2000 Development Unleashed " by Forte, Howe and Ralston which are both good books. However I'm sure there have been improvements since the 2000 version. (or have there been? - can anyone fill me in on the improvements?) Any... 2 12/8/2005 10:46:11 PM Best stategy Hi, I'm trying to get familiar with the concept of replica's, but it still confuses me a bit. Here's my situation: 1) my database application, *.mdb file, should be distributed from time to time to a friend of mine. His copy of the database is completely detached from my database (no connection through shared networks, internet etc). 2) I'll keep the design master, my friend should only... 4 12/8/2005 10:18:44 PM A linked concept for synchronization Just thought I'd check here in case I haven't covered all my bases. I have a front-end /backend model that is working quite nice right now. Our company has two working situations, 1) at the office with our laptop connected to the network 2) remote access (at home connected VPN to the network) my front-end/backend model is extremely slow when using remote access, so I have decided to ... 4 12/6/2005 4:05:00 PM "cannot read the system clock" error When I start the synchronizer, it throws the following error. "The Microsoft Jet database engine could not read the system clock on your computer." I have seen references to the system clock being set to a year higher than 2038, which mine is not. Anyone know of other reasons for this? Thanks, Jack H ... 2 12/4/2005 9:48:52 PM Error: Not enough free space I tried to convert a 249 MB Access 2k database to design master. Access reports an error, that there is not enough space in the temporary folder. Although there are several GBs free on C: where the environment variable points to. Does anyone know this effect? Lothar Geyer ... 5 12/1/2005 6:52:08 PM Installing TSI Synchronizer for jet 4.0 I've downloaded the synch40.zip file from Trigeminal's site and now have a zip file containing a dll, a header file, a help file and a rich text file in my hard drive. The version for 3.5 comes as an exe so I assume that it installs these files correctly. What is the correct way to install the TSI Synchronizer 4.0 version? Thanks ... 4 11/30/2005 8:37:07 PM Replication problem Hi NG, I have some strange problems with replication and synchronization. First, I had two MDB-files, one with the UI, some reports and queries, the second one with only tables. The first file, let's say the front end, had links to the tables of the backend. Replication worked fine with the backend. I had two replicas based on the backend file, did some changes and startet synchro... 2 11/28/2005 11:03:08 PM GUID default value Greetings We are developing a complex system, which will run on Oracle, MS SQL Server and MS Access databases. All the databases are to be replicated. We are using a single common database scheme. For each table we have a GUID column, which is filled once a new record is inserted. We have default values for the GUID column in Oracle DB and MS SQL. Could you please tell me which is ... 8 11/17/2005 3:14:15 AM Operations Master Replication Issue Event ID 13562 I have a Windows 2000 Server which is the Operations Master for the domain. This server and others are having problems with replication. This Operations Master server has an event ID 13562 Following is the summary of warnings and errors encountered by File Replication Service while polling the Domain Controller morecambe.screen-finance.com for FRS replica set configuration information... 2 11/16/2005 11:28:22 PM Wrong ID assigment at subscriber Hi, all. I'm running SQL Server 2000 and using Access 2000 as front end. I created a transactional replication (for the moment I have 2 computers, one is distributor and publisher, the other subscriber) In my tables I have an IDxxx field, and for the replication, SQL Server has added a GUID field. To avoid collisions I chose "NOT VALID FOR REPLICATION" option and define range for the IDs ... 2 11/15/2005 8:17:29 PM Removing old data from Rep Mgr When I open Replication Manager 4.0, I get an invalid path error. this is left over from an old replica set that existed on a defunct share. How can I stop getting this message? TIA Dean ... 7 11/14/2005 1:05:10 PM Replicat mdb 1.first. Can I make a replica mdb runtime? I mean if I have the XP developer edition and the file to be installed is replica will it work? 2. second. I noticed that XP replica file doesn't work in Access 2000. Is there anyway to run mdb wich the format says access 2000 when I run Access XP and it is replica to run in Access 2000? ... 3 11/8/2005 9:05:47 PM Contracting Hello! I am looking for MS ACCESS programmers using Visual Basic and C++ in India or off shore. Anyone out there interested in work? Experience with MS Word, WinFax Pro, Windows XP Fax Solution, and Outlook 2003, is required. Any takers? www.daleallen.com Dale ... 1 11/8/2005 4:30:05 AM Internet replication via Router Firewall Is it possible to synchronize replicas via Internet even if the server connects to the internet through a router? What are the settings for router and Repl Manag -- Gabi Munteanu ------------------------------------------------------------------------ Gabi Munteanu's Profile: http://www.hightechtalks.com/m216 View this thread: http://www.hightechtalks.com/t2279026 ... 2 11/8/2005 1:47:44 AM Is Replication a vaild means to avoid Data Corruption I've learned incredible amounts from the nice folks in these forums,,but really would like to clarify this. I did post this question in Access General Questions last week but no response yet. The Local Intranet connecting my station to two other stations is unreliable to say the least. I decided to replicate so I can synchronize via the shared folder. I do this manually and during a ... 9 11/8/2005 1:44:28 AM Exclude a table I want to exclude a table from replication. How can I do this? Thank you In Advance... Kon ... 4 11/5/2005 3:57:12 AM can't save arrangement of synchronizer icons Does anyone know why we would get the message "Microsoft Replication Manager can't save the arrangement of the Synchronizer icons on the map. The arrangement of the Synchronizer icons may be different than you expect." This message comes up everytime you open a database in Repl Mgr and after synchronizations are complete. The icons are always moved around and it is really annoying. We've used Rep... 1 11/4/2005 4:31:33 PM Unreplicate A97 using Graham Seach utility Trying to use Graham's utility from http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm Had problems getting the A97 form to import correctly, so I used the A2002 version and downgraded it to A97. I removed references to CurrentProject properly on lines like: If (Me.chkDeleteExistingObject = True) Or Len(CurrentProject.AllForms(rsX!Name).Name) = 0 Then Starting from a fresh database,... 6 11/3/2005 7:21:53 AM howto copy data from one Access database to another hi i have Access 2000 database. All id is guid, so it is always unique. several users add data into own copy of this database. then they send .mdb files to me (by e-mail). how to copy the new data in my database from this e-mailed copy? i have just 2 tabes in db, schema is always the same... thank you ... 2 11/2/2005 9:41:41 PM Removing Replication Manager How can I remove replication manager from a windows 2000 machine? I installed it using a vb package. TIA Mary... 2 10/24/2005 7:19:53 PM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12