Understanding ADP linked tables

M

Maury Markowitz

Can someone explain exactly what happens when I create a linked table inside
a ADP project? The wizard's help text isn't very clear, and I can't find much
more than that anywhere else.

Specifically, I have to provide access to a Pervasive-based DB. We currently
use linked tables in MDB's for this purpose, but my application is an ADP and
I'd like to keep it that way. When I step through the wizard it appears to
allow me to create the links without any sort of problem, but in fact this
should not be possible -- to access the data on Pervasive you need to have
software installed, Pervasive's SQL support is offered through a client-side
package.

So what exactly is Access doing here? Storing just the connection info on
the SQL Server? If so, wouldn't this have all the same downsides as using an
MDB?

Maury
 
V

Van T. Dinh

ADPs are specifically designed for MS-SQL Server databases and not other SQL
servers AFAIK.

Check Access Help topic "About an Access project" or your Access book for
more info.
 
M

Maury Markowitz

Van T. Dinh said:
Check Access Help topic "About an Access project" or your Access book for
more info.
Click to expand...

I did. It is essentially information-free.

Maury
 
D

dbahooker

maury

access data projects rock; i would reccomend using MSDE or getting a
copy of SQL Server.

the war is over and microsoft won
 
L

Larry Linson

access data projects rock; i would
reccomend using MSDE or getting a
copy of SQL Server.

the war is over and microsoft won
Click to expand...

Yes, if you looked at Clint Covington's PowerPoint presentation at the
recent Professional Developer Conference (Jens Schilling referred to it in a
post 9/16 -- http://216.55.183.63/pdc2005/slides/OFF307_Covington.ppt),
you'll see that Access now includes its own successor to Jet, fully backward
compatible, and updates to both DAO and ADO. Seems to me that everybody
won.

Interestingly, I did not see much about ADPs in that presentation on the
forthcoming version. They may "rock" for dbahooker, but my experience with
ADPs did not show any advantage. MS SQL Server or MSDE can be used quite
well from an MDB with ODBC, stored procedures and all.

Larry Linson
Microsoft Access MVP
 
D

dbahooker

Larry

just because you're an MVP doesn't mean that you're contributing

ADP are the best thing since sliced bread; and oh.. are you scared to
learn SQL Server?? lol

it rocks.. it is SOOOOOOOOOOOOOOOOOOOOOO much more stable and reliable
than MDB.. i mean-- how many locks must you get before you begin to
hate MDB?

how many times do you have to reboot a fileserver just because someone
didn't shut down an ADP?

how many records have you lost in MDB?

i've never lost any in ADP

MDB just isn't reliable enough
 
R

Rick Brandt

Larry

just because you're an MVP doesn't mean that you're contributing

ADP are the best thing since sliced bread; and oh.. are you scared to
learn SQL Server?? lol

it rocks.. it is SOOOOOOOOOOOOOOOOOOOOOO much more stable and reliable
than MDB.. i mean-- how many locks must you get before you begin to
hate MDB?

how many times do you have to reboot a fileserver just because someone
didn't shut down an ADP?

how many records have you lost in MDB?

i've never lost any in ADP

MDB just isn't reliable enough
Click to expand...

One doesn't have to use an ADP to utilize SQL Server as the data store and there
are many advantages to NOT doing so.
 
S

SusanV

Please don't feed the trolls

<grin>

Rick Brandt said:
One doesn't have to use an ADP to utilize SQL Server as the data store and
there are many advantages to NOT doing so.
Click to expand...
 
D

dbahooker

yes.. one does need to use ADP in order to utilize SQL Server.

if you use MDB; you're stuck writing the same code week in and week
out.. refresh tables here; add new linked tables there.. edit
Sql-Passthrough.

In Access Data Projects--- it is a
LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOT easier get off your
high horse and start using ADP.

once you learn how to use it; it is about 100 times more powerful than
good old MDB.
 
A

aaron.kempf

i mean.. seriously.

show me your MDB code for using a sproc with parameters.

give me the whole friggin code.

i can do it in what; without any programming in ADP?

you have to write 30 lines of code?

it's just time to grow up kids; lose the training wheels and start
using SQL isntead of that piece of crap query engine that you are all
infected with
 
A

aaron.kempf

you guys bother me all the time

you sit there and deal with a crap database engine; and you all talk
trash about ADP.

i'm just sick and tired of it.

SQL Server kicks the pants off of MDB. And it really irritates me that
I have to run around and fix the messes that you guys cause.

-Aaron
 
L

Lynn Trapp

Why must you troll? No one is bothering you.
He's not worth your time or effort, Susan.
 
A

aaron.kempf

Lynn

so play with you little baby MDBs and shiver in fear from a real
database

it's a fact that you kids could have much more reliable; high
performance apps from using Access Data Projects.

I'm sorry that every Access MVP i've ever met is a total wuss. I dont
think that it's their fault; I just think that some fat, drunk PM from
Microsoft chose all his college drinking buddies
 
Top