473,787 Members | 2,798 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

CDaoDatabase Field Limit?

Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.

Jul 22 '05
17 2007
Gav

"Mike Wahler" <mk******@mkwah ler.net> wrote in message
news:yS******** *********@newsr ead2.news.pas.e arthlink.net...

"Gav" <ga************ @nospam.btinter net.com> wrote in message
news:cc******** **@hercules.bti nternet.com...
Tell you what. Here's the link too. :o)


Gareth and Gav:

*Please* cease discussion of this topic on this newsgroup.

This newsgroup is for discussion of ISO standard C++ issues
only. Gareth, how you decided that MS Access is topical here
is beyond me.

Purpose of comp.lang.c++:
http://www.slack.net/~shiva/welcome.txt

If you want to find a forum where MS Access is topical, visit
www.groups.google.com and/or www.msdn.microsoft.com

Thank you.
-Mike


Sorry 'bout that. Just thought it better to give an answer, rather that let
it drag on for ages.
Jul 22 '05 #11
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them. I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question. To answer your (sarcastic) point -
I decided that my question was 'topical' because I am a C++ developer with a
problem in C++ and this seems to be listed as a C++ newsgroup. I had
exhausted my usual sources of information, therefore I presumed that a C++
question in a C++ newsgroup would be 'topical' - forgive my mistake!!! Sorry
to have bothered you - here's a thought - why don't you just read the
postings that are of interest to you and ignore the ones you don't have
anything useful to contribute to. I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on them
instead??

Thanks for the info Gav, you have been most helpful.

I'll go back into my shell and disconnect myself from newsgroups world now.

GT
"Gav" <ga************ @nospam.btinter net.com> wrote in message
news:cc******** **@sparta.btint ernet.com...

"Mike Wahler" <mk******@mkwah ler.net> wrote in message
news:yS******** *********@newsr ead2.news.pas.e arthlink.net...

"Gav" <ga************ @nospam.btinter net.com> wrote in message
news:cc******** **@hercules.bti nternet.com...
Tell you what. Here's the link too. :o)
Gareth and Gav:

*Please* cease discussion of this topic on this newsgroup.

This newsgroup is for discussion of ISO standard C++ issues
only. Gareth, how you decided that MS Access is topical here
is beyond me.

Purpose of comp.lang.c++:
http://www.slack.net/~shiva/welcome.txt

If you want to find a forum where MS Access is topical, visit
www.groups.google.com and/or www.msdn.microsoft.com

Thank you.
-Mike


Sorry 'bout that. Just thought it better to give an answer, rather that

let it drag on for ages.

Jul 22 '05 #12
Gareth Tuckwell wrote:
I'll go back into my shell and disconnect myself from newsgroups world now.

Oh, no you don't. You stay here and try to answer some questions. (Try a DAO
newsgroup, too.)

You see how cheerful you remain after the billionth off-topic question!
Gav wrote:

Sorry 'bout that. Just thought it better to give an answer, rather that
let it drag on for ages.


When you answer off-topic, advise the newbie that other newsgroups are "more
qualified". That means their best interests are served by going there.

--
Phlip
http://industrialxp.org/community/bi...UserInterfaces
Jul 22 '05 #13

"Gareth Tuckwell" <co*******@hotm ail.com> wrote in message
news:fs******** *******@newsfe2-win.ntli.net...
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question.
Your question was not about C++ at all, but about MS Access.
To answer your (sarcastic) point -
My point was not sarcastic at all, simply accurate.
I decided that my question was 'topical' because I am a C++ developer with a problem in C++ and this seems to be listed as a C++ newsgroup.
I don't understand how one couldbelieve that MS Access and C++ are
the same thing.

One is a platform-independent programming language, the other is a
proprietary programmable database product.
I had
exhausted my usual sources of information,
Everything one could want to know about MS Access is available from
it's author, Microsoft Corporation, at www.msdn.microsoft.com. Included
at that site are links to newsgroups which discuss various Microsoft
products and technologies.
therefore I presumed that a C++
question in a C++ newsgroup would be 'topical'
There were no C++ questions asked, only MS Access ones.
- forgive my mistake!!!
I suppose I can do that. But now you've been informed that C++
and MS Access are not nearly the same thing at all. The former
is topical here, the latter is not.
Sorry
to have bothered you
No bother at all.
- here's a thought - why don't you just read the
postings that are of interest to you
I do.
and ignore the ones you don't have
anything useful to contribute to.
I contributed to the group as a whole by trying to educate you
about its topic, hopefully with the result that you'd refrain
in the future from posting off topic material here, thus reducing
the noise/signal ratio.

The other contribution (to you and possibly others) is the
actual information I gave, that MS Access is not topical here,
and what the actual topic is. How you will use this information
remains to be seen.
I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on them
instead??
1. Keeping this group on topic is a group effort. Typically the
regulars will take turns with this task.

2. The messages appearing on on news server won't necessarily be
the same as for others (including yours).
Thanks for the info Gav, you have been most helpful.
But not to the group, he simply helped to continue an
off topic thread.
I'll go back into my shell and disconnect myself from newsgroups world

now.

No need to do that. All you need to do is educate yourself.

No hard feelings, really.

-Mike
Jul 22 '05 #14
Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.

If you are only interested in 'pure' C++ then you had better dissuade all
those people who need help linking to DLLs, coding for networks (TCP-IP is
not C++), programming in C++ for windows etc. In fact you will probably
alienate most people who use C++.

If you read your own answer regarding VB6 on the 6/6/04, you will notice
that you talk about Fortran - now how you can possibly think that either
Fortran or VB is 'topical' in a C++ forum is beyond me. If you check with
someone who knows about matters other than pure C++ (unlike yourself), you
will find that Fortran and VB are both other programming languages and I
don't think you should be talking about them here. Perhaps you should go
away and 'educate yourself'. You have let the group down and therefore let
yourself down.

You recommend that I should educate myself - I did say this was the first
time I have used newsgroups and there is a reason for that - in 9 years of
C++ programming, I have never needed to come to a newsgroup for help as I or
my colleagues have either been able to solve any problems we have
encountered, or found a solution in books or computer based reference
materials.

For your education, I repeat that am not programming in MS Access, but I am
using the CDAO library classes as bundled with Visual C++. The error
messages being generated at run-time are from this library of CDao classes.
These classes provide the programmer with access to the Microsoft Database
Access Objects. Whilst it is the same underlying functionality as sits
behind the MS Access tool, MS Access is not even required on the same PC to
write the code I am working with. Perhaps you should get your facts straight
before you start comparing C++ to MS Access - something you have clearly
shown that you are ignorant about. This technique is called reuse - a
technique whereby a number of programmes share the same DLLs or libraries,
reducing testing time, development time, disk and code space etc, but of
course you wouldn't know about that because you only know purely about the
C++ language - perhaps you should broaden your horizons and join the real
world rather than wasting everyone's time berating newcomers in the world of
newsgroups.

I think you are rude and abrupt and I do not want to have anything more to
do with this newsgroup. Quite how you managed to be placed in charge, I
don't know, but I think it was a mistake as your knowledge is obviously
extremely limited. I will be disconnecting from it once I have posted this
reply, so as not to give you the satisfaction of knowing that I am reading
another of your snotty replies.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I think you should go away and read the part about being courteous!

I hope you enjoy fielding off other future experts.
GT BSc Hons PGDip MSc MCSE SSE BCS
"Mike Wahler" <mk******@mkwah ler.net> wrote in message
news:SZ******** *********@newsr ead2.news.pas.e arthlink.net...
"Gareth Tuckwell" <co*******@hotm ail.com> wrote in message
news:fs******** *******@newsfe2-win.ntli.net...
Mike,

I didn't know there were rules about newsgroups - this is the first time I have used them.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question.


Your question was not about C++ at all, but about MS Access.
To answer your (sarcastic) point -


My point was not sarcastic at all, simply accurate.
I decided that my question was 'topical' because I am a C++ developer with a
problem in C++ and this seems to be listed as a C++ newsgroup.


I don't understand how one couldbelieve that MS Access and C++ are
the same thing.

One is a platform-independent programming language, the other is a
proprietary programmable database product.
I had
exhausted my usual sources of information,


Everything one could want to know about MS Access is available from
it's author, Microsoft Corporation, at www.msdn.microsoft.com. Included
at that site are links to newsgroups which discuss various Microsoft
products and technologies.
therefore I presumed that a C++
question in a C++ newsgroup would be 'topical'


There were no C++ questions asked, only MS Access ones.
- forgive my mistake!!!


I suppose I can do that. But now you've been informed that C++
and MS Access are not nearly the same thing at all. The former
is topical here, the latter is not.
Sorry
to have bothered you


No bother at all.
- here's a thought - why don't you just read the
postings that are of interest to you


I do.
and ignore the ones you don't have
anything useful to contribute to.


I contributed to the group as a whole by trying to educate you
about its topic, hopefully with the result that you'd refrain
in the future from posting off topic material here, thus reducing
the noise/signal ratio.

The other contribution (to you and possibly others) is the
actual information I gave, that MS Access is not topical here,
and what the actual topic is. How you will use this information
remains to be seen.
I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on

them instead??


1. Keeping this group on topic is a group effort. Typically the
regulars will take turns with this task.

2. The messages appearing on on news server won't necessarily be
the same as for others (including yours).
Thanks for the info Gav, you have been most helpful.


But not to the group, he simply helped to continue an
off topic thread.
I'll go back into my shell and disconnect myself from newsgroups world

now.

No need to do that. All you need to do is educate yourself.

No hard feelings, really.

-Mike

Jul 22 '05 #15
Gareth Tuckwell wrote:

Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.
If this 'expert' doesn't understand what this group is all about and
what rules it has, I would say: let him go.

If you are only interested in 'pure' C++ then you had better dissuade all
those people who need help linking to DLLs, coding for networks (TCP-IP is
not C++), programming in C++ for windows etc. In fact you will probably
alienate most people who use C++.
Not at all. There are groups for all of the above. In this group
none of the above is on topic. There is enough left in the C++ language
to talk about and help people with things that *are* on topic.

If you read your own answer regarding VB6 on the 6/6/04, you will notice
that you talk about Fortran - now how you can possibly think that either
Fortran or VB is 'topical' in a C++ forum is beyond me. If you check with
someone who knows about matters other than pure C++ (unlike yourself), you
will find that Fortran and VB are both other programming languages and I
don't think you should be talking about them here. Perhaps you should go
away and 'educate yourself'. You have let the group down and therefore let
yourself down.
We all make mistakes from time to time.

You recommend that I should educate myself - I did say this was the first
time I have used newsgroups and there is a reason for that - in 9 years of
C++ programming,
Nobody questioned your C++ expertise. You got that in the wrong throught.
You say for yourself that this is the first time you have used a newsgroup.
Newsgroups have rules. Mike suggested to educate yourself about how
things are working in a newsgroup. But with no word did he questionize your
C++ knowledge.
I have never needed to come to a newsgroup for help as I or
my colleagues have either been able to solve any problems we have
encountered, or found a solution in books or computer based reference
materials.
No problem with that. You just picked the wrong newsgroup for your question.
That's all that is to say about it.

For your education, I repeat that am not programming in MS Access, but I am
using the CDAO library classes as bundled with Visual C++. The error
messages being generated at run-time are from this library of CDao classes.
Which is a strong hint, that your problem is not about C++ per se, but about
how to use this library. This library is not part of standard C++, thus
it is off topic in this group.

[snip]
I think you are rude and abrupt and I do not want to have anything more to
do with this newsgroup.


Fine. The only one who is rude now is you.

--
Karl Heinz Buchegger
kb******@gascad .at
Jul 22 '05 #16

"Gareth Tuckwell" <co*******@hotm ail.com> wrote in message
news:SR******** *******@newsfe1-gui.ntli.net...
Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.


Gareth, you made a mistake, its no big deal, this is your first time in
newsgroups. Questions about CDAO are not on topic in this group, its as
simple as that. I'm sure there is an appropriate group, why not find out
what it is instead of complaining to this group. You could even ask this
group, that would be perfectly acceptable.

So people have been more abrupt than you would like in pointing out that
mistake. It's par for the course in newsgroups, its not personal.

John
Jul 22 '05 #17
In message <fs************ ***@newsfe2-win.ntli.net>, Gareth Tuckwell
<co*******@hotm ail.com> writes
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them. I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title.


Did the list include news.announce.n ewusers ? I'd recommend reading its
contents before proceeding any further with your Usenet adventure.

--
Richard Herring
Jul 22 '05 #18

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2086
by: Neven Klofutar | last post by:
Hi, Is there a limit on bcc field in CDONTS ? I'm trying to send mailing list using CDONTS and bcc field, so I would like to know what is the limit. thanx, Neven
2
1739
by: J. Marshall Latham | last post by:
I would like to know if anyone knows the limit of email addresses that can be put into this field or the limit on the number of characters that can be put into this field. Are there any other limitations that I need to consider? I am trying to set up a newsletter with a subscribe and unsubscribe page. I need to know if I need to monitor the number of email addresses in the list to make sure that all people on the list receive the...
3
1675
by: Julien | last post by:
How do I set reference to a Foundation Class Library from VB.net? I'd like to get access to the CDaoDatabase Class... Dose anyone know if I can even do it with VB.net Small code snip would be cool... Remember VB code not C Thanks
4
2303
by: subaruwrx88011 | last post by:
So I pressed tab-enter and posted an incomplete topic, sorry. I have imported information into a database using a file. It is tab delimited and for NULL fields I have NULL. example file.txt 1<tab>Hello World<tab>NULL<tab>5.56 1) Is this a correct way to make sure that this field will be NULL
0
1329
by: josh.23.french | last post by:
Here's the code i have: $db = array(); //main array $db = array(); //table `main` $db = array('id'=>0, 'username'=>'joshfrench','userpass'=>'password','userlevel'=>'admin'); //row $db = array('id'=>1, 'username'=>'bob_smith','userpass'=>'psswrd','userlevel'=>'user'); //row
1
1711
by: Riun | last post by:
Hi, I'm trying to run an update query in vba and i'ts not working. It does the update but the field is updated to "-1". here's the query: Dim stDocName As String Set rst = New ADODB.Recordset stDocName = "SELECT * FROM WHERE =" & txtID.Value & ""
5
7036
by: TechyGal | last post by:
Hi there, I really hope someone can help as I have been trying for two days now and to no avail. I am trying to add a validation rule to a memo type field in MS Access 2007. I need to limit the amount of text that can be entered into this field to about 1000 characters. I have tried using the following validation command but it is not working! Any ideas would be very greatfully recieved! :) Validation Rule =Len("Specification")<1000 ...
9
2391
by: plumba | last post by:
Hi all I have a pretty cool script which, on the click of a button, sticks in a extra text box and gives it a unique name/id so it can be munipulated and sent through on a form. Problem is, I dont know how to remove a text box when added, simplistic terms - a script to reverse what the add button does. Here's a simple break down of the code... <script type="text/javascript"> <!-- function addField(area,field,limit) {
0
2007
by: mokoujan | last post by:
Hello all I am currently developing a WCF REST service. One of the requirements is to allow the users to search data via the rest interface. As such key field information is passed in the URL. The number of key fields can vary and as such a request string format is used to collate all the required fields into one URL parameter. This means I am hitting the limit of 260 characters for each url parameter
0
9655
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9497
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10169
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9964
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7517
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4067
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3670
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.