|
|
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?
|
|
=?Utf-8?B?VHJ5aW5nIHRvIGdldCBzdHJvbmdlcg==?= <Trying to get
stronger[ at ]discussions.microsoft.com> wrote in
news:13772F4D-6F49-4E7D-A430-09EC34E30AD9[ at ]microsoft.com:
[Quoted Text] > 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/
|
|
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" <XXXuse...[ at ]dfenton.com.invalid>
wrote:
[Quoted Text] > =?Utf-8?B?VHJ5aW5nIHRvIGdldCBzdHJvbmdlcg==?= <Trying to get > stron...[ at ]discussions.microsoft.com> wrote innews:13772F4D-6F49-4E7D-A430-09EC34E30AD9[ at ]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/
|
|
"a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com>
wrote in
news:bcd3fc0f-83b0-4169-b83c-3c43833e86a3[ at ]b41g2000pra.googlegroups.co
m:
[Quoted Text] > 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/
|
|
"David W. Fenton" wrote:
[Quoted Text] > ... 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.
|
|
"a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com>
wrote in
news:b5c603b9-82bf-4c48-a56d-5f282b89d557[ at ]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/
|
|
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" <XXXuse...[ at ]dfenton.com.invalid>
wrote:
[Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.ke...[ at ]gmail.com> > wrote innews:b5c603b9-82bf-4c48-a56d-5f282b89d557[ at ]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/
|
|
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 [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> wrote in
message
news:bad77416-0644-417a-a2cc-5587e8a01831[ at ]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.
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" <XXXuse...[ at ]dfenton.com.invalid>
wrote:
[Quoted Text] > "a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.ke...[ at ]gmail.com> > wrote > innews:b5c603b9-82bf-4c48-a56d-5f282b89d557[ at ]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/
|
|
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> wrote:
[Quoted Text] >[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/
|
|
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 [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com> wrote in
message
news:bad77416-0644-417a-a2cc-5587e8a01831[ at ]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.
|
|
"a a r o n . k e m p f [ at ] g m a i l . c o m" <aaron.kempf[ at ]gmail.com>
wrote in
news:bad77416-0644-417a-a2cc-5587e8a01831[ at ]w1g2000prm.googlegroups.com
:
[Quoted Text] > 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/
|
|
"Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> wrote in
news:cn0ml4hbg1eesnd39hfprmbcd96dh0com2[ at ]4ax.com:
[Quoted Text] > "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 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/
|
|
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> wrote:
[Quoted Text] >>>[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/
|
|
|