ADP Files

[yoavchen]

i wanted to convert my MDB file to ADP.
the convertion went well except from on important issue, it didnt convert all mu queries to the new file, i tried another way but nothing.
please help.

all the forms and tables an d everythoing else are in the new file, although, the forms are based on all teh queries.

 

[Pat Hartman]

I would recommend NOT converting to an .adp. The .adp will NOT support SQL Server 2005 EXCEPT to access data. Any maintenance activities must be done with Enterprise manager. Also, the .adp is no longer being developed so although Access will continue to support them at least through A2006, you won't see any new features added and they will get further and further away from the .mdb in development tools.

You can still upsize to SQL Server but leave your database as an .mdb. The db should work without modification. However, to make use of the fact that the be is now a database server, you will need to modify all your forms to use queries that contain where clauses to limit the number of rows returned if your forms are not presently built that way. In some cases, you may want to add a "pre" form rather than recoding your existing form. So, you would open the unbound "pre" form and use it to select the record you want to open the original form to.