ADP reference
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
ADP reference
Has anyone got a good reference book on ADP development in Access 2003?
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ADP reference
I'd prefer using an Access database (.mdb) with linked tables; Microsoft appears to provide only half-hearted support for Access projects (.adp).
As to books, you might consider Microsoft Access Projects with Microsoft SQL Server. It's a bit older, but the principles should still be valid.
As to books, you might consider Microsoft Access Projects with Microsoft SQL Server. It's a bit older, but the principles should still be valid.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: ADP reference
Thanks Hans, i have no option on using an ADP on this project, i inherited it. I like you have only developed in MDP's in the past.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: ADP reference
I am thinking of converting this ADP database back to an MDB.
Apart from the dbSeeChanges option in OpenRecordsets what are the other main differences?
Or is this task too big and time consuming?
Apart from the dbSeeChanges option in OpenRecordsets what are the other main differences?
Or is this task too big and time consuming?
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ADP reference
Bound controls work a bit differently, but it should be doable.
Also, you can't edit views from an .mdb, you'll have to do that in SQL Server itself.
Microtools.us has an ADPtoMDB converter that is part of their Access Whiz series of products; I don't know if they provide it separately; you might try contacting them.
Also, you can't edit views from an .mdb, you'll have to do that in SQL Server itself.
Microtools.us has an ADPtoMDB converter that is part of their Access Whiz series of products; I don't know if they provide it separately; you might try contacting them.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: ADP reference
Thank you Hans, i will contact them and see what they are offering.