is this possible for multiple users to use (or will it show as locked if someone else is already logged into database)
each time a new enquiry is logged i want the number to jump up one automatically, ie. 1, 2,3,4 and enquiry date to be automatic
then the person will fill in contact and address details
then a couple of questions for them to answer and if they answer yes i want them redirected to an excel spreadsheet ( is this possible) but once they are there, can they return back to the form and answer the rest of the questions and will i beable to record that they followed the link to the excel spreadsheet
When they have finished, i guess all the info will be stored in the underlying table
I'm doing some changes to a database in work, but the person who created it doesnt work there anymore and so nobody knows anything about it. The database has been split into a front and back end, which is fine, but there appears to be 3 seperate databases linked to the main one, each with a .mde file for security. Depending on which department you're in, you access your database. Any information being added is updated in the main front end database. Does anybody know how that will be linked? I'm just probably going to have problems when encorporating my changes.
I am an Access novice and have managed to create a DB to record all incoming enquiries to my business. The enquiries are entered via a form onto a table and one of the fields is the date of the enquiry, which is entered as 01-Jan-07. What I want to do is build a query that will find all enquiries in a given month. Has anyone got a simple soultion, please?
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce 2) Select small file in MS Excel 2007 format. 3) Click on Import the source data into a new table ... 4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help: "ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features. Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing! Help! I do have Runtime 2002 (XP) on the same PC, is that relevant?
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.
Attached is a screenshot of the relationships in a database I built a couple of years ago. It's worked absolutely fine in Access 2003 and currently has over 18,000 customers with associated information in it.
However, when I open the database in Access 2007 the performance is awful. All the forms are very slow to respond when tabbing between form elements. I've experimented by reducing the number of form elements calling on related data on a given page and whilst this improves performance it reduces usability - something I don't want to compromise on especially since Access 2007 should be able to cope with this.
My next question is therefore whether I've got the most efficient underlying table design and I can't see any other way of doing it than my current method so I'd be grateful for any feedback or advice anyone has.
Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb).
Problem: In the split database, I've saved the Application .mdb as 2003, relinked and made a new .mde. But the Users still cannot open the database. (I did this in a copy until I figure out the nuances with 2007.) The 2 other unsplit databases can be saved as 2003 version and Users can open OK.
I'm grateful for any suggestions on working with Access 2007. I've been trying to tackle the ribbon which is a whole other question.
Having a problem here after installing 2007. All my previously created databases work fine in 2007 (after clicking the enable, which is a pain,but don't know any other way) When I return to 2002 and try to open the databases I get different errors all something like this on....... "The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. Whats up here?????I have found a site here...http://allenbrowne.com/bug-17.htmlMentions this problem,but refers to Vista..... Does the same apply to XP? And which is the best fix?
I have an Access 2000/2003 database which opens up and displays correctly in Access 2007, but when I go to use the File>Print command, or for that matter any of the other pull down menu's nothing happens?
Has anyone else experienced thisproblem, or does anyone know what I am doing wrong?
I have created a database in Access 2007 that now works well, and one that I'm quite proud off. However, I can easily convert it to an Access 2000 format as can anyone else here, but when I load it up there is a major problem.
I have used the tab control in my main form and that has three tabs on it. However, it's positioned correctly in Access 2007 it's not positioned correctly in Access 2000 as I have to move the tab control down a bit, but that would seem fine. So I lowered the tab control form and changed my form layout slightly, but even then the tab control over all over the Access 2000 form whenever I interact with the tabs - most bizzare.
I recently heard that Access 2007 ( part of MS Office 2007) can be purchased as a stand alone program. This sort of confirms that : look at pricing breakdown on : http://techrepublic.com.com/5254-6257-0.html?forumID=99&threadID=174062&messageID=1961442&id=3053951
I have downloaded Access 2007 trial, but I don't know how to use some of its features. When I try to open any of my databases saved as A2000, it displays a security message. "Security Warning: Certain content in the database has been disabled"
Hi, I have downloaded the access 2007 trial. Installed and registered it with the trial code. However when I try to install any of the free sample dbs from MS including the northwind db, Access crashes!! I was going to purchase the full version of office, but wanted to test access first. If anyone knows a solution, or can email the northwind 2007 db it would be appreciated.Many ThanksP.S. Screen dump of error is included.
I read this article from Allen Browne http://allenbrowne.com/Access2007.html#Bugs Has anyone had any problems with 2007, data, tables, etc. Our company would like to install, but after reading this, just second guessing myself. We have not yet installed the SP1. The company is gang ho about running with 2007.
I would like to hear your oppinion about new MS Access Jet db engine
I've been working with MS Access still 10 years, since version 2.0. I used to use MS Accesss for companies size of 10 pc users, and for any bigger company, I used MS Access as front end and MS SQL Server as back-end.
I bought recently MS Office 2007, with MS Access 2007. Before that, I read in one computer journal, that new, Access db Engine is completely made from scratch. And that this new engine is so good, that there are no needs to work with , for example MS SQL 2005 express. Also, I read, that during development phase of MS OFfice 2007, Microsoft development teams SQL Server and MS Access in Redmond, USA, fought among themselves, about is there need for Jet db engine, or not.
Engineers working in MS SQL development team, made a pressure on Microsoft board, to remove Jet engine from Access, as you can take MS SQL express for free, but on the other hand, MS Access dev. team, replied that new Jet is robust at least as MS SQL express 2005.
So, my question is: what do you think about it, is new Jet db engine, really so good and robust in MS ACcess 2007 ?
I've been using Access from the beginning, (well v2.0 actually) and felt quite competent. Lots of clients using various versions, still as far back as 97 - but keeping them maintained.
I just got 2007 - and the UI is leaving me totally cold !!
Is there any way that we can have a 'classical view' of menu options etc in 2007 ? It is taking me ages just to do simple things - as I'm trawling around looking for the options or commands - is there a simple guide to this ?
Also finding a no of things that won't work - again - is there a summary of differences anywhere ?
I have a few sensitive applications that I am trying to move across to Access 2007. I want to re-establish the security and in the process I want the users not to be able to access a few options in the ribbon (Create table, create forms, create queries and reports, also not allow them to import data and not allow them to compact and repair the database and view the back end window) . I tried to do this with this bit of coding on the Ribbon XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="false"> <tabs> <tab idMso="TabHomeAccess" visible ="true" /> <tab idMso="TabCreate" visible="false" />
</tabs> </ribbon> </customUI>
This hides the tab 'tabcreate'. But this allows the user to be able to add the same options through Quick Access Toolbar. Is there not a way of preventing it from the quick access toolbar as well? If I have 'startfromscratch' = true, there are no options displayed hrough Quaick access tool bar (no option to add them). Is there not a way to give a bit of flexibility by removing access to certain functions in the database? Am I missing something here...please help. Thanks,
I am a totally a newbie of Access 2007, no experience of any previous versions. Here is only my own project. I want to record NBA (National Basketball Association)‘s scores every day. There are 30 teams in NBA. So I made 30 tables, each table is for each team. Let say today’s game, it is between Miami team Versa Philadelphia team. Philadelphia is home team, favor by 5 and the total is 191. Miami is away and is underdog. The final score is Philadelphia 96 and Miami 85. Here I have done so far. First I would open Philadelphia table, and input all the data, home team, favor by 5, the total is 191, and the final score Win. Second I open Miami table, and input all the data, away team, underdog by 5, the total is 191, and the final score Lost. If there is only one game today, I have no problem to do this job. But there are usually many games in one day, the task is difficult to open and close, then go to next team’s table.
Question #1 Is there a possible way, or can be done, that I can create a form to control all tables? Meaning that when I input the favor team’s data, it will know go to Philadelphia table. (I searched an answer to this question in Google, I had no luck). Or how would you approach to this problem? Can you give me more specific details please? ‘cause I am a totally newbie.
Question #2 Example Philadelphia Home Miami -5 / 191 Win Miami Away Philadelphia 5 / 191 Lost
Because I need to record two teams of a game, so again, can it be done to create a form that when I input Philadelphia, it will auto to fill the word Philadelphia in second line. Same as Miami. I know I have 2 questions that, I describes the best I could above, may not very clear to all of you, but let me start to say this. Thank you for your times to read my post and input your helps as much as you can.
So, we were given two different tables with some datas and then we are asked to using the quary wizard create a quiery, what does that mean? we are being asked to create a query about some datas which are located in two different tables. As I said, I'm new with access, I don't know nothing about access, I'm guessing I'm supposed to put togueter those datas from both tables which we are supposed to create a query about? I already tried to do that, but I couldn't, I was gonna copy the results I got from one table after using the query wizard and paste them in the other results I got from the other table, but I wasn't allowed to paste.
for the following question, I think it is important for you to know that my instructor uses access 2003 and as I said I use access 2007. so, my instructor asks me to create a table based on the adresses sample table in the personal category with the following fields, first name, last name, spouse name, address, city, state or province, postal code, email address, homephone, birthate, what I'm supposed to do here?
This is what I have been trying to do. I go to table templates then I choose "Contacts" is this what I'm supposed to do? then, I get a table but I don't know how to edit some of the fields this table comes with, for example I have to change the order of this table's fields , this table's fields order are: company, last name, first name, etc, and I have to change this order so that it will read as first name, last name, spouse name. thank you.
