What are the differences in MDB and ADP?

[Ashfaque]

Hi Gentelmen,

As I am venturing from mdb files to ADP I would like to know the followings:

1. What is the major difference in MDB and ADP other than the back end of ADP are SQL Server.

2. Are the sizes of ADP always lesser than MDB?

3. Do the ADP have much more speed in opening forms, running queries and generating data rather than MDB?

Thanks in advance.

With kind regards,
Ashfaque

 

[Crilen007]

Look. It's on Google.

Here is another.

 

[Crilen007]

2. Are the sizes of ADP always lesser than MDB?

- not always. Nothing is ever "always"

3. Do the ADP have much more speed in opening forms, running queries and generating data rather than MDB?

- they should, unless the connection to your server is bad.

 

[Ashfaque]

Thanks Pat and Crilen007,

After reading the various articles reffered by you gentlemen, I came to the conclusion that both ADP and MDB may have little compliations if I use them and FE and back end ovet to MSDE.

At present my FE & BE both are mdb files with linked tables in FE. The FE holds tricky codes and it has enough beauty as I had hard efforts which I do not wish to loose.

As Pat says;

You can get most of the benefits of an ODBC data source and none of the problems associated with an .adp if you only upsize the tables and leave the rest of the application as an .mdb...Upsizing to an .adp won't fix this. You would need to make the same changes in the .adp.

So if I do take care of my other objects which all (should be) based on queries, would make easier to keep FE as ADP.

MDB troubles when it concern with speed up matter where as ADP could carry out the action fast.

Its like I stand on center of the bridge....dont know which side is closer to me....

Finally, my first attemp would be try to keep my BE (tables only) on MSDE and FE as ADP ensuring that rest objects are based on queries and not directly dealing with tables. B4 doing this I off course will keep a back up of my mdb bcz I dont want to loose codes and beauti of my FE as I said and then would revert back to MDB incase I face any hard critical problem with ADP FE.
But I hope it would work.

Thanks for the advice.

With kind regards,
Ashfaque