Does anyone know of a good "You can learn Access ADP in 21 days or less......" type book. Most of the Access How To books cover the subect but only for a few pages. Thanks.
I just purchased
Microsoft Access Projects with Microsoft SQLServer by Ralf Albrecht and Natascha Nicol.
I'm only to Chapter 6 but it seems reasonable in terms of learning about Access Projects(21 days would be ambitious at 600+ pages). It covers all the back ends, SQLServer 7 and 2000 and MSDE1 and MSDE2000. It points out that MSDE1 is not nearly as good as MSDE2000. The only drawback so far is problems loading the Sample Db. I was not able to load it in MSDE1 but I think it's a problem with the CD and not with MSDE1. I was able to attach the NorthwindCS.adp and get it running. It's the only book I've found that gives more indepth info about Projects.
Nowell, did you load the cd that came with the book? I was not able to attach the .mdf and.ldf files from the cd. I have been able to attach other files, specifically NorthwindCS and haven't had any issues except with the ContosoSQL database on the cd.
Let me know how it goes. I got a response from the Microsoft Learning Customer Support but they can't tell me what the issue is. Here is my original email to them
Comment: Trying to install the .MDF and .LDF files from the command line.
1> EXEC sp_attach_db @dbname = N'ContosoSQL',
2> @filename1 = N'C:\MSSQL7\Data\ContosoSQL_Data.MDF',
3> @filename2 = N'C:\MSSQL7\Data\ContosoSQL_Log.LDF'
4> GO
I get the error
Msg 5172 Level 16 State 15 Server JHZB000 Procedure Line1
[Microsoft][ODBC SQL Server Driver][SQL Server]The Header for file
'C:\MSSQL7\Data\ContosoSQL_Log.LDF' is not a valid database file header. The PageAudit property is incorrect.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.