I have completed the split and have deployed the backend to SharePoint. The front end is sat on my (and others) machines with linked tables to the SharePoint lists. This is all fine and works well.
Although this database is deployed, I am constantly working on a local copy of the database in design I.e. Tables being updated with fields and relationships and new tables being added. The reason for this is that work wanted something workable putting out there now and that I just continue its development in the background.
What is the best way to update the tables on SharePoint bearing in mind that users are putting new data on there? I don't want to lose what they are updating and then I need to redploy the 'new' backend to SharePoint again (no doubt in the same location) as that's where the front end is looking for it.how I can manage this version control of the backend without losing data.
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:
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'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?)
I haven't used Access in a few years and am trying to replace an Excel spreadsheet with Access.One field in Excel looks at the prior record, if they are the same it doesn't update the current record. The excel command is: If($Y3 = $Y2, 0, sumif($y:$Y, $Y3, G:G)). Is there any easy way to do this with a query?
Hi, My database consists of some personal data and a photo of each person. I am trying to include these photos when I browse the database via ADP. I have found instructions how to do so at Microsoft website (article ID: 285820) Link for it: http://support.microsoft.com/?kbid=285820 The problem is I cannot make it !!!!!!!! Where exactly should I paste the VBscript in the page code to execute displaying of the photos??????? I am happy to send you the head portion of my page code if anybody knows where to paste it.....
I have a date field on one of my forms that gets populated automatically when a new record is created. I also have a subform on the form that lists the tasks that still need to be accomplished this month. Some problems have popped up as people got new computers with new versions of Access:
Access 2002(10.6501.6825) SP3 - No problems. Access 2002(10.6771.6817) SP3 - The Date field isn't recognised on a new record (#Name?), but it's fine on the old records (displays date). Access 2002(10.6771.6825) SP3 - The reminder subform is blank (white), as if it doesn't exist, but the date field works fine.
Any ideas why this might be/how to fix?
Thanks! This is really frustrating. If it didn't work for anyone, I would find a way to fix it, but because it works for some people, I don't know what to fix...
I have developed an application and packed it into a runtime version. However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse to the documents instead of typing each link with all the errors that might give as well. Any help would be appreciated.
Are there any issues with converting an older 97 database to 2003? Is it a straight conversion, or will there be differences that affect the way the database will run if converted? I've read somewhere that it is possible to use the newer version to open the database w/o converting it. It seems silly to have to install 97 on a new computer in order to view the db.
I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!
An application that I made was created in Access 2000 as I was told that all users had at least this or newer. Of course a user with 97 popped up. Instead of having them purchase 2000 or newer I converted my app to 97 version. I expected troubles with references. So far this has only been a phone conversation and I plan on going there later today. The user says hitting alt/F11 does nothing... no code window comes up. I had her look through the menus for the code window but she says there is nothing there. She is getting runtime 3433 (she thinks) and unrecognized database format when trying to open a form. The database did open when holding the shift key though.
Before I go there, how do I open the code window for 97? Any other suggestions? I bet this is a reference thing but there may be a problem with their access install too. There are 2 users at this location with the same issues... at least it sounds like it.
I've got an VB app that uses an Access db that sits on a sever. The owner of the app has no Access installled on site. The prior consultant created the app and used MS Access.
Is there a way for me to determne what version of Access this db was created in?