Related Topics

Access 2010 & Win7 .ldb File

How to solve the Could Not Lock File Error
This error occurs when the .ldb file is not automatically deleted when the user closes MS Access. In theory, the .ldb file should automatically get created when user connects to the database and automatically get deleted when user stops using the database. The way to fix this problem is to delete the .ldb file. The .ldb file will be in the same folder as the database itself. If the File in Use error is received when trying to delete the .ldb file.


Information fro .ldb file
Ldb file if you open that in Notepad, at my work it gives me the 'Computer Name' of who is using the database.

(eg ABC1234 - Admin)Is there a way to change this to show methe 'Username' or is this a Business IT thing that pulls from our IP address and isn't related to Access? I just use this as a guideof who I need to kick out if I do.(Apologies if this posts without paragraphs etc I don't know whats going on!)


MDB in Read Only, No .ldb, What to do
I have a 2007 microsoft access database that when is opened shows it as read only but does not have a .ldb file. The database is located on a shares so that other users can access it. My questions are:

Is there a way to unlock the file set in read only? I found this post but it did not work.

Is there a way I can see what is locking the database? I have a field in the only table the users access that captures the last person that made an update although even if I have that user log off it doesn't unlock the database.

I'm strapped on ideas, please help me before I jump out the window!. jk


mdb wont open with double click
My new system will not open an MDB file from Windows Explorer when someone else has it open unless I open Access first. If the file is not open, a double-click on the file icon will open it without problems.

If the file is open by another user, my machine apparently does not open it (Access does not show up in Task Manager) but it adds my machine name to the open LDB file!

I have already tried dis-associating MDB with Access, then shutting down, and then re-associating the MDB file types with Access. It did not solve the matter.

The file is in Access 2003: I just got a new system running Windows 7 and Office 2010 today. This same issue came up previously with a co-worker with her Windows XP-Pro machine suddenly stopped opening MDBs that someone else had open unless Access was started first.


Access 2010 split form not display
I have a database I have set up in WIN7 64 bit system. I transferred database to a WINXP 32 bit system. I modified the main form in the XP system to be a split form. I then copied the file back to WIN7 64 bit systems and have found that the datasheet portion of the splitform does not display on the WIN7 system.

I have checked many settings to include that it is shown as a split form, checked the record source setup on the property sheet, data tab, and all is set up the same but datasheet does not display on the WIN7 systems.

It seems as if this may be a bug with Access.

I am uncertain if it is a 32 bit verses 64 bit issue or if it may have something to do with screen resolutions or what. I have also read that the splitforms tend to be buggy in other posts.


Maintenace Issue
This has now left me with a hanging open session in the BE file, which says it is my DEV machine, but soft and hard reboots have not cleared it.

I need to run weekly maintenace, with "Compact & Repair" but am denied, because it say the BE is locked.

I know there is a way to FORCE off the BE file, but can not find it in the MICKEY soft HOWTOs, so need some help on finding that.

I tried to delete the .ldb file for the BE but get the "file in use". I also tried changing from shared to exclusive for the db, but nothing is working


Windows Media Player Control
Background: running Access 2010 on Windows 7. Recently switched from Windows XP and Access 2003.

Problem: Have mdb db with a form that contains Windows Media Player control used for playing wav files. Until recent upgrade to Win7/Access 2010 this worked fine. Now it doesn't: when I click the "play" button on the control it displays "Opening media." and then. nothing, it returns to "Ready".

The wav file to be displayed is set with this code: "player.URL = [directory] & "\" & [videofilename]", where player is set to the windowsmediaplayer control object. The original reference "Windows Media Player" (\windows\system32\wmp.dll) has not been changed.


Upgraded from 2007 to 2010 now drop-down boxes go BLACK.
our company upgraded my PC from 2007 to 2010 and now when I try to use drop down boxes in our company-wide database, it just shows a black box. When I type it in it's completely blacked out, cant see the text at all.

I am on Win7 64bit using Access 2010 64bit while the rest of the company uses Win7 32bit and Access 2007 32bit if that makes a difference.

Any ideas on what could be causing this and how to fix it


MDE created in Win7 don't run xpwin
members

I created an .mde in Win7.64bit.sp1 ultimate OS running Access.02.sp3. When this is placed on the PC running xpWin.sp3.prof with Access.02 or Access.03, it reports that it failed due to Automation issues.

This .mde has no problem running in Win7.

.mde created from the same .mdb in WinXp.sp3 running Access.02.sp3 runs fine on all OS platform with access from 02 to 2010.runtime


Access97 app running along Office 2010
We are using an old Access97 App. I have managed to make it work alongside Win7 / Office 2007 and previous versions but now I am stuck.

The error is: "the expression on click you entered as the event.".

I have 2 stations running Win7/Office 2010. One doesn't even have Access 2010 installed, but still something has changed as one menu from the app will give the error described/attached. Uninstalling Office 2010 does not solve anything.

The database is fine, it works from all other stations.
I don't have the code, just the compiled mde.


Upgraded from 2007 to 2010 now drop-down boxes go BLACK.
Our company upgraded my PC from 2007 to 2010 and now when I try to use drop down boxes in our company-wide database, it just shows a black box. When I type it in it's completelyblacked out, can't see the text at all.

I am on Win7 64bit using Access 2010 64bit while the rest of the company uses Win7 32bit and Access 2007 32bit if that makes a difference.


File Name Confusion
Access 2010/XP

I have an Access file that is named: N&D Mailing12.mdb

However, when I open it, the filename at the top of window is N&D Mailing11: Database (Access 200 file format).

What is causing the "12" to change to "11" in the filename?


Access 2010 to Access 2003
I have been reading for what seems like forever but haven't seen the exact words I need to in order to make a decision. I am trying to decide between Office 2007 and Office 2010. I am wondering if Access 2010 can open, use, and save Access 2003 *.mdb file format.

I have found the following quote and when reading its suggestion it would lead me to believe it would but then there is that little warning that "Because Access 2010 has many similarities with Office Access 2007, such as the same native file format," I'm not totally convinced.

Migration considerations
When you plan a migration to Access 2010, changed, and removed for Access 2010. Because Access 2010 has many similarities with Office Access 2007, such as the samenative file format, you can also review and use the existing migration documentation for Office Access 2007 when you migrate to Access 2010.

So my question is can Access 2010 open, use, and save databases in the Office 2003 file format?


comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access version prior to Access 2007. I am in the process of converting the databases and installing them on new machines running Win7 and Access 2007.

Over the years, one of the References I commonly used was comdlg32.ocx. It does not appear that either Win7 or Access 2007 installs that particular Active X file. I can copy it from an older machine,

Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a newer (and differently named) Active X fle? If so, what is the name of the


Converted ACCDB to ACCDE but ACCDE fails
I have an large Access 2003 database that functions 100% as both an .mdb and an .mde file in Access 2003. I converted the file to an Access 2010 .accdb file, and then compiled and compacted that file. The Access 2010 .accdb file works 100% also.

When I 'Save & Publish' the .accdb as an .accde, the .accde file fails right away and on most function buttons. I have listed the folder these files reside in as a "Trusted Location", but I am stuck.

Hard to understand how the .accdb can work and compile flawlessly, and the .accde fails consistently.


Moving Average
I tried the whole day to contruct a query that deliver me the sum of 3 months i.e the actual month + 2 months. The Table layout is

Month1 Cost Item Year Moving Sum (should be Output)
01/08/2010 20 A 2010 55
01/09/2010 5 A 2010 85
01/10/2010 30 A 2010 100
01/11/2010 50 A 2010 90
01/12/2010 20 A 2010 130
01/01/2011 20 A 2010 90
01/02/2011 90 A 2010 110

As for the last two records the 2 months (01/03/2011 and 01/04/2011) are missing, I have reverse the logic i.e I have summed the the Costs in the opposite direction.

In my Query I have a Field MYAVG which should calculate the moving average, but it is not working. I have used the following logic

DAVG("Cost","Query1","Item="'&Item&"' and Month1 between #" & Month1 &"#" & " and #" dateadd("m",2,Month1)&amp


Access 2010 stopped working
I'm running Access 2010 on Win7 x64. I use it very rarely, but it has worked in the past. "Microsoft Access has stopped working" and given the option to close the program or search online for a solution (which yields nothing).

Failing that, is it possible touninstall/reinstall just Access? It's part of my Office 2010 Pro installation and doesn't show up by itself in the uninstall programs dialog.


Access 2010 startup FLAKE-OUT!
Using Win7 and Access 2010. Have been using for months no problem. Recently I opened up a very important DB that I am working on and instead of the DB opening by hiding the Navigation pane and ribbon and the n the Login form being displayed and accepting my drop down user combo box, then focus directed to my next password field --The drop down accepts the user name, ignores going to password and goes directly to my login command button which when clicked does nothing!

In fact, the on form load of the Login form seems to be ignored and the form buttons ignored.

At this point even closing down Access seems to be difficult! The very first symptom is my initial navigation panes/ribbon commands being ignored, followed by the command buttons on the first form (which is called from the Access 2010 options of course).

I'm scared down to the bone that this project will get hosed from this strange thing that my home PC is now doing.

Between, I already tried a 'repair' of Office Professional from Win7 control panel - Programs, and it completed without incident.


Create Backup Of Access 2010 Database
Creating backup of databases is the most important thing and must not be overlooked. Access 2010 offers a simple and easy way of creating backup of database you’re working on. To begin, open the Access 2010 database and close down all table fields. Now on File menu, click Save & Publish.


Access 2010 & Window 7
I had to replace my work computer so now I have Windows 7 home premium and office 2010. I'm connected to a network. I've had some issues. I create a shortcut on my desktop for an access application and it doesn't open the application. It works if I open access up locally and then go to the network directory and open the application. Does anyone have any idea what is going on? I noticed something else that I think is a problem. When I open access 2010, click options, at the general options screen at the " Default file format for blank databse:" dropdown I don't have Acess 2010 as a choice. I would think I should see 2010, am I correct