Search results

What features would those be? So far as I know, multi-value fields and attachment fields (both of which were added for Sharepoint compatibility, not because Access users were clamoring for them) are the only real new features in ACCDB format. Multi-value fields are an abomination and nobody who...

But that doesn't in any way make replication impossible in A2007. There is no need to seek out some alternative simply because you're upgrading to A2007, which in no way, shape or form requires conversion to ACCDCB format.

Whatever you "searched in google" that told you that was WRONG. Many people have been blithely stating that A2007 drops replication support, but all of those people are COMPLETELY MISTAKEN.

THIS IS FALSE. COMPLETELY FALSE, WRONG, ERRONEOUS, TOTAL BS. Jet replication is fully supported by Access 2007 and the new ACE. What is *not* supported is replication of files using the ACCDB format. This is a limitation that Microsoft chose to implement, not one that they *had* to implement...

That's an ODBC driver that allows Notes to read ODBC data. I thought the question was about allowing Access to see Notes data.

The point of a wiki is collaboration. Why don't you sign up for the Jet Replication Wiki and start an article somewhere and I'll collaborate with you on working it up. Feel free to cut and paste anything I've said in this thread into the Wiki. I think Jet replication is going to be around for...

You might want to check the Jet Replication Wiki's article on things not to believe in the MS documentation (it's linked from the front page, http://dfenton.com/DFA/Replication/). Please provide a citation for that, i.e., where the docs suggest that indirect is the best choice. I expect...

No, a synch does not ping the other replicas. In a direct synch, you specify the remote replica, and your local instance of Jet (running in your computer's RAM) pulls that remote replica's data across the network into its RAM and performs the synch (likely using temp files on the hard drive of...

I would disagree with that. You use ADO when you want to bypass Jet entirely, so ODBC has nothing to do with it, since ODBC is a Jet data source (i.e., Jet is talking to the ODBC driver which talks to the ODBC data source). Thus, OLEDB is really useful only for databases that provide their own...

Do you by chance have Name AutoCorrect turned on? It shouldn't delete independent objects, but maybe it does. Name AutoCorrect as implemented in Access by Microsoft is a feature that never should have existed. It is broken, it corrupts databases and it makes changes without the appropriate...

This is only because you are editing the data in subforms. If you have the data on the MAIN FORM, there is no problem. I really can't see having the same table on two different subforms if both are editable -- this makes no sense to me. If there are more fields than fit on one page of your...

I don't see anything at all wrong with your design. It's just like dozens of apps I've implemented. Whether or not you want to load subforms only on demand, or preload them when the form is loaded is up to you. I'd try it the easy way, i.e., permanently assigning them to the subform controls on...

Yes, that's correct. If you mean: ID Source 1 1 1 2 Then, yes. But I'd actually use it in the other order, with the machine column 1st and the ID column second. But it really matters none at all, as this is just a way of a generating unique compound PK across multiple...

With replicated data tables, the Autonumbers become random (existing ones are not altered, but the new ones are random), which insures the smallest possibility of PK collisions between two replica sets. APPEND-only applications are absolutely the safest with Jet replication, as there are no...

Each day I come to this site and search for topics that have new posts in threads that include certain keywords. I failed to notice that the only recent post was one that is clearly not related to anything that came before. I'm not sure I feel any responsibility for this. I added content to the...

This is not an issue for an MDB that is converted from A97 to A2000 (the original references are retained), but only for newly-created MDBs. And even that is no big deal -- uncheck the ADO reference and add the DAO reference (if it's not already there -- can't remember it A2000 had both or just...

Using Replication for multiple sites is quite complex (even though basic direct replication is quite simple). If at all possible, I'd try to avoid it. The easiest solution for multiple locations where there's an always-on Internet connection is to host the app at one location on Windows Terminal...

I'm at the point where I'm forgetting the problems, but here are the three that have given me the worst problems: 1. form/subform unload events don't necessarily fire in the same order. I had a nasty bug in one app where in A97, the subform unloaded before it's parent, but in A2003, the form...

You may also need to check the permissions on both the folder on the machine acting as server and on the share defined for that folder. Also, on the "server" go to Control Panel | Administrative Tools | Computer Management, and then select Shared Folders and then Open Files. Perhaps there is a...

They always tell you they need complete freedom to do anything at all, but experience tells me that there are really only a finite number of tasks that they need to do in regard to data retrieval and report filtering. A robust query-by-form interface will probably take care of most such cases...