All of the session from PDC content is also available online to anyone, for free, for six full months. For more information, refer to this blog post http://blogs.msdn.com/mswanson/archive/2005/10/24/484434.aspx. There are a few sessions that are interesting from the Access perspective:
OFF307: “Access 12”: Developing Collaboration Solutions with “Access 12” and Windows SharePoint Services “v3”
Speaker: Clint Covington – Broad overview of many new features.
http://microsoft.sitestream.com/PDC05/OFF/OFF307.htm#nopreload=1&autostart=1
OFF201: “Office 12”: Introduction to the Programmable Customization Model for the “Office 12” User Experience (Part 1)
Speaker: Jensen Harris – explains the philosophy behind the new UI and the ribbon changes.
http://microsoft.sitestream.com/PDC05/OFF/OFF201.htm#nopreload=1&autostart=1
OFF302: “Office 12”: Developing with the Programmable Customization Model for the “Office 12” User Experience (Part 2)
Speaker: Savraj Dhanjal – explains how to customize the new UI.
http://microsoft.sitestream.com/PDC05/OFF/OFF302.htm#nopreload=1&autostart=1
OFF310: Windows SharePoint Services: Developing Collaboration and Tracking Applications
Speaker: Mike Morton – explains many of the changes to WSS that can be used while building Access applications with WSS link tables.
http://microsoft.sitestream.com/PDC05/OFF/OFF310.htm#nopreload=1&autostart=1
OFF417: Visual Studio Tools for Office “v3”: Creating Office Application Customizations
Speaker: Andrew Whitechapel – details around how to develop managed task panes and addins for Office including Access
http://microsoft.sitestream.com/PDC05/OFF/OFF417.htm#nopreload=1&autostart=1
OFF415: Windows SharePoint Services: Developing Custom Workflows
Speakers: George Hatoun; Pravin Indurkar – details about workflow that can be used while building applications with WSS. Access will have hooks for working with WSS workflow.
http://microsoft.sitestream.com/PDC05/OFF/OFF415.htm#nopreload=1&autostart=1
Last, if you don’t read the blog post, know that you can right-click on the speaker video, choose Play Speed, then Fast to watch the presentations at a higher speeds.
Enjoy!
--------------------
Clint Covington
Lead Program Manager, Access
Microsoft Corp.
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard. But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007. I can't use the Package Wizard.
I hope I am in the right forum area. I have just upgraded to XP Home and have a choice of Office systems to install. However I have Office 97 Developer Edition that I use for Access Databases and this must be installed. I can also install either Office 2000 or Office XP Professional. What are the problems with having any of these combinations and Access 97 with the developer.
I have heard that there may be licencing issues or I may have to install in a particular order. Any advice would be appreciated.
We just switched to Access 2003 (from 2000) last week, and now none of my reports will open. Everything else works fine, I can open tables, queries, forms, etc., but I can't even open a report in Design mode.
Has anyone else had this problem? Is it an Access 2003 quirk or am I doing something wrong? Any ideas on how to fix this would be great. Since all of the other objects work I guess I could just redo the reports--there are only thre of them. I seem to remember something funny happening when I moved from Access 97 to 2000 too...
At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.
After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.
Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.
Their own site states that Office standard IS a qualifying license see here
Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded
I am building a database for users to input escalations in. The users that are actually keying the information in, do not have MS office. When they try to access the DAP html file, a message appears at the top of the page that states "The page requires the Microsoft Office Web Components. See the Microsoft Office Web site for more information." Can data access pages be used without office being installed? I have heard that it could also be the users internet explorer security settings.
I have a main form (unbound) and a main form (bound) and then a subform (or a main form;subform;subform).The main form has the following SQL;-
SELECT Detail.*, Hazards.*, HowHarmed.*, Section.* FROM PSR RIGHT JOIN (Hazards INNER JOIN ([Section] INNER JOIN (HowHarmed INNER JOIN Detail ON HowHarmed.ID = Detail.HowHarmedID) ON Section.ID = Detail.[Subject Area]) ON Hazards.ID = Section.detailID) ON PSR.ID = Detail.PSR;
This form appears to work fine. Essentially, there is a control on the unbound form whereby the user selects the section and it populates the respective form with the various 'detail' of the various records.My tables are as follows;-
Risk Assessments Detail Section HowHarmed Hazards PSR PLR Staff
In the subform there are records from Riskassessments, which is the table in the source property of this subform (and not on the main form) with a link to PSR of which is on the mainform. Again, these appear to work if the record is entered via the tables - all the tables appear to be linked correctly from their respective dropdowns (+ sign) but when I go to add a new record in this subform, I get the error "The link masterfields property has produced this error: 'The object doesn't contain the automation object ID'." When I try to update from this entry the following message is presented;-"The ms Office access database engine cannot find a record in the table 'Detail' with key matching field(s) 'DetailID'.
The SQL for this subform is as follows;-
SELECT Detail.*, PLR.*, RiskAssessments.* FROM (Detail INNER JOIN RiskAssessments ON Detail.ID = RiskAssessments.DetailID) LEFT JOIN PLR ON RiskAssessments.PLR = PLR.ID;
I'm trying to locate the Developer Extensions so that I can compile my Access 2003 application to distribute to my end user.
I'm getting totally lost in the myriad of documents and links on the MS website that keep sending my round in ever decreasing circles. I've downloaded Visual Studio Express - Visual Basic Edition but can't seem to find it in there.
Can anyone point me in the direction of the software that I need to be able to distribute my Access 2003 applications.
Our Access database is multiple user. The front end is on the local drive and the data file is on our main server. Our database has numerous queries, forms and reports accessed by command buttons or directly. Various queries are set to merge with Word documents.
What are major or annoying problems that have been encountered by converting. Our database is contains our membership information and is crucial to our operation. Detailing problems/solutions if possible would be extremely helpful. Asking for allot but very concerned about conversion. Thanks for any input.
I have a database which is use at busy times to run the delivery side of our Floristry business. The orders are entered,assigned to a delivery area, address labels printed. When it comes to delivery day orders are selected from the list ticked off then printed a make a list for the driver.
It was built using Access 97 when it first came out. Since then the software was upgraded to Access 2000 many mods have been made each year to improve the performance and the number of things it can do. It now has about 15 tables and a lot of queries. Not being an expert with Access a lot of the design has been on a trial and error basis. Put it another way the main form has many hidden fields to make things work behind the scenes. But it does most of what I want it to. I have now go to the point where the main query is saying that I can't add any more features because I have to many fields in it.
So the time has come to look at re building it for a number of reasons.
1. It is a stand alone database on one Pc.......... I would like to have it on a network to 3 or 4 Pc's around the shop. 2. Some of it needs to be redesigned to take out my ( it might not be the way a designer would it but it does work) type bits. 3 I would like to be able to use the system for all orders received on a day to day basis. So it will need to be used by other people.
My question today is Should I be looking to rebuilt it using Access 2003 + the extra software so that i can run it on more than one PC.
Or would it be better to wait few months till Acess 2007 comes out and start from scratch.
I am trying to determine what version of Access is being used from a file that I obtained from a user. Everything I clicked on does not say what version of Access is being used. The extension name of the file is .MDB. The original version of the file I am accessing was created in 2001. Thus would you tell me how to verify what version of Access I am working with?
Will Microsoft ever consider making another RAD program similar to Access that supports the .Net framework?
Just think of an IDE of a RAD program similar to Access that has a full set of toolbox items already built in .Net that supports all of the functions / options that Access currently supports in its forms, reporting etc. and have the ability to interface with all of the .Net database engines... :cool:
I'm recently starting a new job and one of my tasks is to clean up their Access 2000 database. After looking through it and realizing how much crap there is in it, I was thinking about starting a new one for them from scratch. I was wondering if there are any pros/cons to redeveloping the database in 2003 verses 2000. Its a pretty small company with usually about 6 people concurrently working on it throughout the day.
We recently experienced network issues here at work. Now I need to make sure the current version of the MS Access application is running. Is there a version compare component with MS Access? Does anyone have a recommendation on software that will work well with MS Access 2003?
I've got two tables in Access. The first contains 300 column headers running from top to bottom, i.e:
Title First Name Surname .. ..
The second table contains the corresponding data entries for 1000 customers running from left to right, i.e:
MR Trevor Smith .... MRS Mary Jones ....
Ideally i'd like to append table 2 to the bottom ot table 1 so the correct data field is under the right column header but I can't do this. Is there a transpose style funtion in access which will mean I can convert table 1 to run from left to right instead of top to bottom?
HI, Im new to this, so I need some help if you can on the subject of upgrading a database created using access 1.0 to the latset version of access, can this be done ? Many Thanks
I have an mde database originally created in Access 2003. Will I be able to open it in Access 2007?
(I ask because this mde file was originally created in Access 2002, and wouldn't open in A03. We had to track down the creator and get her to resend a new mde file that was 03 compatible. Are we going to run into the same problem after the next upgrade?)
