Hi
I've just tried adding the Administrator to a workgroup as described in http://support.microsoft.com/kb/918583
and now I can't open any access databases at all!
It's asking me for Login Details even on a blank database.
Anyone got any ideas?
Shane
I have upgraded from Access 2003 to to 2007 in Window XP. When trying to edit code I get the message Project Locked - "Project is unviewable".
Sandy
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 have turned off DEP.
How can I get MS Access 2007 to import Excel?
Thanks
Ken
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?
:eek: security levels were set on a database using the wizard, unfortunately the person who set the security did not print out the sheets with the WID etc on it, this person is now unable to open access at all from their pc it asks for a password which the user does not believe they set or if they did set one it was their standard pc log in, however the database and access can be opened from any other pc on the network......can anyone out their help...thanks
View 2 Replies View RelatedI copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working.
Any suggestions would be very much appreciated.
Thanks,
Mike
-------------------------------------------------------------------------
#1 02-13-2006, 04:33 AM
odun
Registered User Join Date: Apr 2005
Posts: 108
can't log on to database
Hi all,
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
Please help
Thanks!
odun
View Public Profile
Send a private message to odun
Find all posts by odun
Add odun to Your Buddy List
--------------------------------------------------------------------------
Hi
Is there anyway of returning the menus that I removed from the Tools > Startup options back?
It looks like I have locked myself out of my FE!!!!
Thanks,
B
Hello out!!
Is a moment of desperation! I created a security group or something (dont know what i was thinking!), and now there is no way to get into my application!!!! It says to contact with the administrator, but I'M the administrator!!!!
Any way to get the scripts minimun from the applications?? The classes, the modules??? God!!!! My last backup was 4 days ago!!!! I can't loose everything!!
Message:
you do not have the necessary permission to use myapplication.
:confused::confused::confused::confused::confused: :confused:
I have an access application which is locked for edit. When ever i open this application it shows me the main menu, i want to edit this menu but it does not give me any option, even the Access File menu and toolbars are not visible. Please help
View 4 Replies View RelatedI have a MS Access 97 database that seems to be locked. I wish to update it but I cannot open it as a regular file. When it is opened, there is no way to edit the database or access any of the controls that are usually present. The tool bars are even different.
Any idea?
Thanks,
WJ
Hi All
I am using OLEDB to connect to an Access DB and it does use the "admin" account as the default user to connect from within Access i.e. this is not a Windows account.
I have an ASP.NET web page that is trying to do a compact and repair using a jet/MDAC object called JRO (Jet Replication Object).
The problem is whenever I call the JRO object I get this error:
"You attempted to open a database that is already opened exclusively by user 'admin' on machine..."
If I try and delete the .ldb file it is ofcourse locked. I found that if I do a CTRL-ALT-DEL and end the aspnet_wp process I am then able to delete the .ldb file and then successfully execute the compact and repair from the ASP.NET web page.
The aspnet_wp process when ended simply restarts itself (a new instance no doubt) and in doing so cannot remember it had a lock on the access db.
My conclusion is that the aspnet_wp process locks the access db file for or on behalf of the "admin" user in the access db.
Even if all connections have been closed the aspnet_wp process has a lock on the database file!
I am still searching for a way to tell the aspnet_wp to let go of the access db file!
I did use getprocessbyname() from the ASP.NET page to try and kill the instance of aspnet_wp programmatically and try and force it to forget by starting a new instance of itself, but ofcourse IIS gets really upset and won't let me kill this process from an ASP.NET page because I figure that in this case its suicide and aspnet/IIS won't "kill" itself but would be happy to "kill" other processes.
Anyway, I would have been content with the "kill the aspnet_wp process instance" approach except it won't suicide.
Does anyone have any idea how I might tell the aspnet_wp process to let go of the acccess db file?
By the way, I found the only account you need in a dev environment is the ASPNET account with read/write access and also your own account if you want to browse the folder yourself. No other accounts needed.
Any ideas appreciated.
I think this one has me beaten
from howartthou
Windows XP Prof.
VS.NET 2003
IIS 5.1
I am completely locked out of my Access Database!
Basically, I have 3 forms which have all got the properties set to DISALLOW right clicking on them to prevent users accessing the design of the form, they all have code behind them so that they cover the entire screen and block ALL menus/shortcuts apart from those available on the form and I have set up a command button on each form which is password protected to ONLY allow Admins to access the design/backend of the form/database when they enter a valid password.
However, I was playing around with the settings of all these forms and have inadvertantly locked myself out, the last thing I remember doing was setting up a "Password" form to collect the Administrator password which had code attached to allow access to the database design. This was working fine until I tried "tweaking" it and now whenever I input the CORRECT password, I get the error message;-
"Error 2585: This action can't be carried out while processing a Form or Report event"
If I enter an INCORRECT password, I get the standard "Login Failed-Please try again" form that I have set up.
The "Password" form doesn't have an override/Cancel (I wanted to make it REALLY secure) it means that although I can use the database fine for entering/editing information/data within the database when it first opens, as soon as I want to make changes to the design and try to log in with "Admin" privellages using my custom made "Password" form, it then pops up with the password screen and goes no further.
I do have a backup of this database BEFORE I set up the "Password" security to collect the "Admin" Password but I can't remember the code I used and although I can work it out again, it will take me a LONG time to work it out again. So I was wondering if any of you might have some ides or a workaround I could try to gain back "Admin" rights to my database.
Does this makes sense? As stated I do have a backup so if all else fails I'm going to have to try to remember how I got it working in the first place BEFORE I cocked it up but if any of you could save me the trouble that would be very much appreciated!
Thank you very much
Alex
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. The editing functions delete, cut, new etc are not working, we can still filter the data.If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
View 6 Replies View RelatedI have an .accde database that will not let my print button to work. How do I print from an .accde database?
View 2 Replies View RelatedI greatly appreciate your help on 2 issues:
1/ At work, I have Access 2000 application residing on a Novel server for multiusers purpose. Everyday, occasionally, the application is locked out by whoever opens first (I think?). Some of other users could not open it since it has the message like "locked out by a particular (computer name)...". Therefore the user of that computer name needs to close the application so others can open it. This issue is not happen in Access 97 as we used that version before and it is not consistent happening, so I could not find the pattern or know why?? Please let me know if you have seen this problem and how to prevent it...
2/ Do we have a way to trigger or initiate GroupWise email inside an Access 2000 application. For example, if a purchase order is created in Access 2000 application, I want to email a co-worker...OR it can be automatically sent an email to my supervisor for notifying the purchase order so he can approve it?
Thanks so much in advance for all the helps...
Access2k
I have MS access database. The database is password encrypted. I do not own this database but it is critical for me to see the contens of this database. I do not want to edit the contents.
View 9 Replies View RelatedHello,
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.
How can I do to solve this?
Thanks.
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.
Hi All,
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?
View 7 Replies View RelatedHi
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?
Any help greatly appreciated.
Thanks
Steve
Hello friends.
Do you know anything about a new Developer Extension for Access 2007 ?
Thank :) :)
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.
Any help? Thanks.
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
Anyone done this already ?
Interesting article. Especially the Macro / Security thing. I saw some pretty extensive demo's last week and the UI was real different...
Link (http://msaccess.advisorguide.com/doc/18229)
Hi,
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"
Is there any way to disable this message?
Any help will be very much appreciated.
B