When replicating datbase fields in tables disappear

Jet Replication works.. reliably.. _NEVER_.

I've done it, been there-- and it's just a piece of junk

Because it is so buggy, replication was removed from the Access 2007
format, the same thing with User Level Security.

It is best to move to SQL Server if you want true simple replication;
you can even do this with the freeware MSDE / SQL Server Express
database engines.

-Aaron

On Dec 28, 5:52 pm, "David W. Fenton"
wrote:
> =?Utf-8?B?VHJ5aW5nIHRvIGdldCBzdHJvbmdlcg==?= <Trying to get
> stron....DeleteThis@discussions.microsoft.com> wrote innews:13772F4D-6F49-4E7D-A430-09EC34E30AD9@microsoft.com:
>
> > Many controls in different tables disappear in relationship window
> > and design view of tables. In the form view they are still their
> > and all relationships still work. Why are not all controls being
> > dispaled so I can modify them?
>
> It's not clear what problem you're encountering.
>
> Are you using Jet replication?
>
> If so, what do you expect to see and what are you seeing instead?
>
> By definition, in a replica, you can't make any edits to table
> structures.
>
> It sounds like you're replicating a front end since you mention form
> view. This a huge mistake, as Jet replication works reliably only
> for pure Jet objects (tables/queries) and not for Access objects
> (forms/reports/modules/etc.). Secondly, it makes no sense to
> replicate a front end as you can distribute an updated front end by
> simply distributing a copy of the new front end. Third, it seems
> likely that you have not split your app, which is the most basic
> error anyone can make -- the data tables belong in a back end MDB
> and everything else in the front end with links to the back end. If
> you replicate, you would replicated only the back end data tables.
>
> --
> David W. Fenton                  http://www.dfenton.com/
> usenet at dfenton dot com    http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"a a r o n . k e m p f @ g m a i l . c o m"
wrote in

m:

> Jet Replication works.. reliably.. _NEVER_.

This is simply not true, and you know it's not. You are a liar,
Aaron, and you lie with full knowledge of the fact that you are
telling lies.

What, exactly, do you get out of that?

Again, you really need to seek medical help.

> I've done it, been there-- and it's just a piece of junk

You're a complete liar. You've never done even one production
project with Jet replication. I've been doing them since 1997. You
weren't even born then (or so it would seem from the content level
of your posts).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"David W. Fenton" wrote:

> ... You've never done even one production
> project with Jet replication.

No more'n he knows, he couldn't do a project of any kind.
 >> Stay informed about: When replicating datbase fields in tables disappear 

David;

I don't think that I've ever lied in this group at least-- and in the
real world, I can honestly say that I haven't told a lie in the past
decade in the real world.

So -- no-- just because you disagree with everything-- it doesn't make
me a liar, it doesn't make me wrong.
It makes you uneducated and unable to learn the worlds most popular
database

In Microsoft's own words....
The following comes from Microsoft article Q300216.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."
-----------------------------------------------------------------------------------------------------------------------------------------------------------


On Dec 30, 6:38 pm, "David W. Fenton"
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m"
> wrote innews:b5c603b9-82bf-4c48-a56d-5f282b89d557@i24g2000prf.googlegroups.co
> m:
>
> [a lot of obscenities]
>
> You are a liar. You've demonstrated that over and over again. No one
> believes *anything* you post. Even when you attempt to provide
> citations for your assertions, they are almost always cherry-picked
> and out of context, or taken from obsolete documentation.
>
> You are a liar, Aaron.
>
> Everyone here knows it.
>
> You've made your reputation and you can't escape by swearing at
> people.
>
> --
> David W. Fenton                  http://www.dfenton.com/
> usenet at dfenton dot com    http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"a a r o n . k e m p f @ g m a i l . c o m"
wrote in

m:

[a lot of obscenities]

You are a liar. You've demonstrated that over and over again. No one
believes *anything* you post. Even when you attempt to provide
citations for your assertions, they are almost always cherry-picked
and out of context, or taken from obsolete documentation.

You are a liar, Aaron.

Everyone here knows it.

You've made your reputation and you can't escape by swearing at
people.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"David W. Fenton" wrote:

>[a lot of obscenities]

Thankfully Microsoft removes those postings from their server.

Tony
--
Tony 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 >> Stay informed about: When replicating datbase fields in tables disappear 

The title to which Aaron refers to is:

How to keep a Jet 4.0 database in top working condition in Access 2000

Link: http://support.microsoft.com/kb/300216

Maybe you could find something more recent and pertinent?
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message

David;

I don't think that I've ever lied in this group at least-- and in the
real world, I can honestly say that I haven't told a lie in the past
decade in the real world.

So -- no-- just because you disagree with everything-- it doesn't make
me a liar, it doesn't make me wrong.
It makes you uneducated and unable to learn the worlds most popular
database

In Microsoft's own words....
The following comes from Microsoft article Q300216.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."
-----------------------------------------------------------------------------------------------------------------------------------------------------------


On Dec 30, 6:38 pm, "David W. Fenton"
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m"
> wrote
> innews:b5c603b9-82bf-4c48-a56d-5f282b89d557@i24g2000prf.googlegroups.co
> m:
>
> [a lot of obscenities]
>
> You are a liar. You've demonstrated that over and over again. No one
> believes *anything* you post. Even when you attempt to provide
> citations for your assertions, they are almost always cherry-picked
> and out of context, or taken from obsolete documentation.
>
> You are a liar, Aaron.
>
> Everyone here knows it.
>
> You've made your reputation and you can't escape by swearing at
> people.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

You lied about being declared guilty by the State of Washington

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message

David;

I don't think that I've ever lied in this group at least-- and in the
real world, I can honestly say that I haven't told a lie in the past
decade in the real world.
 >> Stay informed about: When replicating datbase fields in tables disappear 

"a a r o n . k e m p f @ g m a i l . c o m"
wrote in

:

> I don't think that I've ever lied in this group at least

What about "I was not convicted of a crime"? That was a lie, no
matter how you flail around trying to spin it.

You *were* convicted.

Period.

End of statement.

You have repeatedly *tried* to lie about that, but the facts are out
there for everyone to see.

Of course, the number of lies you've told about Access and SQL
Server are untold -- the only reason I mention your lying about your
criminal record is because it's the most memorable of your lies.

Get a grip, Aaron.

Seek medical help.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"Tony Toews [MVP]" wrote in


> "David W. Fenton" wrote:
>
>>[a lot of obscenities]
>
> Thankfully Microsoft removes those postings from their server.

Er, I really wish you'd gotten the attributions better there, since
it looks like you're saying *I* wrote a bunch of obscenities. While
I occasionally use one for effect, I very seldom use more than one
in a single post, and only very rarely more than a couple.

So, it would have been better if you had indicated that "a lot of
obscenities" was in reference to Aaron's post.

(not that anyone who cares about the subject would likely read it
wrong, though...)

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear 

"David W. Fenton" wrote:

>>>[a lot of Aaron's obscenities snipped.]
>>
>> Thankfully Microsoft removes those postings from their server.
>
>Er, I really wish you'd gotten the attributions better there, since
>it looks like you're saying *I* wrote a bunch of obscenities. While
>I occasionally use one for effect, I very seldom use more than one
>in a single post, and only very rarely more than a couple.
>
>So, it would have been better if you had indicated that "a lot of
>obscenities" was in reference to Aaron's post.
>
>(not that anyone who cares about the subject would likely read it
>wrong, though...)

You're correct. I'll attempt to remember next time.

But, <tongue in cheek> you should've put in a bit more text like I
just did in the attribution. <smile>

Tony
--
Tony 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 >> Stay informed about: When replicating datbase fields in tables disappear 

I wasn't declared guilty of anything I was charged with.
And again, I wasn't declared guilty of anything.
Which means that today -it-never-really-happened- and last year it
means that -it-never-really-happened- and it also means that next year
-it-didn't-really-happen-






On Dec 31 2008, 6:09 am, "Douglas J. Steele"
wrote:
> You lied about being declared guilty by the State of Washington
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no private e-mails, please)
>
> "a a r o n . k e m p f @ g m a i l . c o m" wrote in
> messagenews:bad77416-0644-417a-a2cc-5587e8a01831@w1g2000prm.googlegroups.com...
> David;
>
> I don't think that I've ever lied in this group at least--  and in the
> real world, I can honestly say that I haven't told a lie in the past
> decade in the real world.
 >> Stay informed about: When replicating datbase fields in tables disappear 

I was not convicted of a crime.
I was not convicted of a crime.
I was not convicted of a crime.
I was not convicted of a crime.


And that's not a lie.






On Dec 31 2008, 5:53 pm, "David W. Fenton"
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m"
> wrote innews:bad77416-0644-417a-a2cc-5587e8a01831@w1g2000prm.googlegroups..com
> :
>
> > I don't think that I've ever lied in this group at least
>
> What about "I was not convicted of a crime"? That was a lie, no
> matter how you flail around trying to spin it.
>
> You *were* convicted.
>
> Period.
>
> End of statement.
>
> You have repeatedly *tried* to lie about that, but the facts are out
> there for everyone to see.
>
> Of course, the number of lies you've told about Access and SQL
> Server are untold -- the only reason I mention your lying about your
> criminal record is because it's the most memorable of your lies.
>
> Get a grip, Aaron.
>
> Seek medical help.
>
> --
> David W. Fenton                  http://www.dfenton.com/
> usenet at dfenton dot com    http://www.dfenton.com/DFA/
 >> Stay informed about: When replicating datbase fields in tables disappear