Ive been installing Windows 7 and getting back my Access files. When I try to open an Access 2000 .mdb with or without entering a password it says that The Microsoft Jet database engine cannot open the file &. It is already opened exclusively by another user, or you need permission to view its...

This is a long explanation, please bear with me. Overview: I have been working on a split database since 1998. It is a A2003 version and I am now using A2007. It has a front end DB that connects to 4 back end DBs. I have it setup such that whenever I use/edit the front end, it opens a hidden form to...

Hi All: I have a code copied somewhere which once run opens the "Select the Names to Add" dialog box. It works fine with Access 2007 but when I tried to use it in Access 2003 it fails. I read some of its documentation and I found out that is one of the additions of RunCommand code in A2007...

Hi, I have a database form containing a subform which allows a user to 'attach' a series of documents .. this is done simply with a command button which runs the Insert Hyperlink command. So far so good as the 'attached documents' can be clicked on and opended as expected. I now need...

Is there a way to create a hyperlink to an Access database (MDB) format from within SharePoint on our Department site? I will not be moving our Access database to SharePoint due to the issues with referential integrity, keys, etc. Thanks for your assistance.

Is there a problem with installing/running Access 2007 (runtime) and Office 2003 Professional (with active Access solutions) at the same time? I have decided to begin the process of migrating our users into the "brave new world" of the new Office GUI - i.e., the ribbon. I have (sort of) come...

Hello, My VBA code will import a .csv file into an Access table, but only if you click the .csv file twice. The first time nothing happens, the dialog box remains open, the second time the file is imported correctly and the dialog box closes. This is a little irritating and I can't determine what's...

Hello, I have an application that contains a table of motorcycle models. There are multiple instances of any particular model, for instance; JOBS[Model],[YearID] VT1100 07 VT1100 08 vT1100 09 (There are no duplicate Primary Keys) I plan on providing an update for my clients when the 2010 models are available...

Hello, I've developed an Access 2003 application, created an MDE file from that application then packaged that MDE file using the developer tools in Access 2007. The file is packaged with the Access 2007 Runtime, so it installs as an accdr file. Sometimes the deployment works OK, some clients however...

A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control