473,503 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Data Projects

I'm relatively new and am well below expert level in msaccess, but I'm
learning. My question is about a statement someone made in a post I
read recently. The person said "anyone using Microsoft Access in the
year 2007 should be using Access Data Projects"
Could someone tell me what Access Data Projects is and whether you
agree or disagree with this statement?
Thanks.

May 29 '07 #1
4 1298
rinmanb70 wrote:
I'm relatively new and am well below expert level in msaccess, but I'm
learning. My question is about a statement someone made in a post I
read recently. The person said "anyone using Microsoft Access in the
year 2007 should be using Access Data Projects"
Could someone tell me what Access Data Projects is and whether you
agree or disagree with this statement?
Thanks.
ADPs are a flawed experiment from MS in which you connect more directly to a SQL
Server (and ONLY a SQL Server) back end. They had some promise, but have lots
of problems that MS is apparently not planning on fixing.

Since Acess 2000 if you go to the file - new menu you have the choice of MDB or
ADP.

The person to which you are likely referring is a troll who gets his jollies
disaparaging MDBs and saying that ADPs are the solution to every problem.
Apparently a disgruntled former MS contract worker.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

May 29 '07 #2
Thanks Rick..

May 29 '07 #3
Baz
Rick is correct in that ADP's do have problems, but they are nonetheless
usable. I've found workarounds for every problem I've encountered with
ADP's and delivered a number of big ADP applications to various customers
over the past few years. I like ADP's.

However, the answer to the question you pose is that NO-ONE should now be
starting new developments using ADP's, because Microsoft has lost interest
in them and they are going nowhere. If you see anything to the contrary
posted by Aaron Kempf, ignore it - he is an idiot. Beware that he is now
apparently impersonating other, non-idiot posters in these newsgroups, which
tells you everything you need to know about him.

"rinmanb70" <em**********@gmail.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
I'm relatively new and am well below expert level in msaccess, but I'm
learning. My question is about a statement someone made in a post I
read recently. The person said "anyone using Microsoft Access in the
year 2007 should be using Access Data Projects"
Could someone tell me what Access Data Projects is and whether you
agree or disagree with this statement?
Thanks.

May 30 '07 #4
I appreciate it Baz.

May 30 '07 #5

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

Similar topics

0
5362
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
13
2889
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....
2
1624
by: Ebbie | last post by:
Hi, I wanted to know if Access Data Projects is a good option to choose for a SQL Server Database Frontend. The other option is C#. The database will be accessed by multiple users (around 100...
7
6259
by: damjanu | last post by:
Hi All; I need little help. I have a datasheet form. I allow user to do 'filter by selection'. My form contains a column with values. As user changes selections, I want to calculate totals....
20
3292
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
35
3178
by: deko | last post by:
Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 =...
0
3460
by: Sin | last post by:
> Xxxxx : error PRJ0008 : Could not delete file 'd:\xxxxxxx.dll'. > Make sure that the file is not open by another process and is not write-protected. > > LINK : fatal error LNK1168: cannot open...
15
4564
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
14
3849
by: ApexData | last post by:
I am considering building some distributable commercial applications. For about a year now, I have been using Access2000. This was my first venture into object oriented database development. ...
2
19396
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
7280
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6991
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7460
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...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3167
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3154
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1512
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 ...
0
380
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...

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.