General :: Unable To Create MDE From MDB

Jan 7, 2013

When I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'.

I am a user who has been making some improvements to our database. Now that I want to test the improvements I need to create an mde, but can't.

The database was created in Access 2003 and I am now using Access 2007 on windows 2010. The original developer advised that we continue to use mde format - something to do with the runtime version everyone else who uses the database have.what I need to do to convert my mdb to an mde?

View Replies


ADVERTISEMENT

Unable To Create MDE

Sep 5, 2005

I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled)
Its disabled I cannot continue so no error message. Any idea?
Prodigy

View 2 Replies View Related

Getting An Error Unable To Create Mde

Jun 10, 2005

Unable to create MDE file WHY?????????????????????

View 3 Replies View Related

Unable To Create An Mde File

Jan 1, 2006

I am running access 2000 9.0.2720. I wanted to create an MDE file but every time I attempt I get the message 'unable to create an MDE file'. Any advice?

View 1 Replies View Related

Unable To Create .mde File

Oct 28, 2004

I was able to create a MDE database from .MDB file (1900 KB) using Access2000 but not on the other database (5000 KB)
I followed the steps (under tool -database utilities- make MDE file), the message box shown " Microsoft Access was unable to create a MDE database"

Is there any limit on the size of the file? What should i do or check?

NaNy

View 4 Replies View Related

Microsoft Access Was Unable To Create An MDE Database

Mar 31, 2006

When trying to create an MDE using Access 2002 I get the message

"Microsoft Access was unable to create an MDE database"

The database is split and in Access 2002 format.

Could this be anything to do with References? I say this because I recently downloaded a dll for Redemption to make use of the SafeOutlook Library

Thanks

Oliver

View 2 Replies View Related

[D.A.P.]Unable To Create Page Using Union Query

Oct 26, 2007

Before anybody says anything about it, no, my MS Access is not corrupt, and I don't need to reinstall, or update or anything like that.

Now, to the problem...... I have a union query that in essence ties 4 tables together. The query works great! Here's the issue...... When I try to create a data access page using the wizard, I get an error msg saying wizard was unable to create data access page. If I try to create in design view, I cannot view the fields of my union query to add to the data page.

I am including 2 databases..... the first one, called "union" contains the union query that will not work to create a data access page..... the second one, which is very similiar on the union query, just not as detailed does work. It is called "joined"

The only difference in these two union queries, is that I tried to include times for db"union", whereas for db"joined", I only calculated hours. I can make a data access page using the union query in db"joined", but not the union query in db"union"

Any ideas?

View 2 Replies View Related

Modules & VBA :: Unable To Create Duplicate Records On A Subform?

Nov 20, 2013

I am working with a sub-form where once a staff member enters there sub measure I would want to create a duplicate of that record. The problem I am having is that once you enter the sub-form and click the duplicate button it creates a duplicate of the record selected but overwrites the first record in the table. I want it to create a new SubMeasure Number which is the primary key and assigns the record the next available number.

Also if I try to add another record after one has been added I get runtime error "3021" - No current record. I would have to close the form and reopen for it to be able to add again.

I have attached the code below:

Private Sub cmdDuplicate_Click()Dim dbs As DAO.Database, Rst As DAO.Recordset
Dim F As Form
'Return Database variable pointing to current database
Set dbs = CurrentDb
Set Rst = Me.RecordsetClone

[code]....

View 4 Replies View Related

Modules & VBA :: Unable To Create Duplicate Record On Subform

Nov 29, 2013

I am trying to create duplicate records from a main form frmManagers which has a subform frmSubMeasure. I have placed the duplicate button on the main form. It creates a duplicate of the main form data and gives me the option to add new record to the sub. I want the duplicate to be created on the sub form for me to just edit the scores.

I don't know how to pass the sub form data to be duplicated I thought the append query which I used would update the tblSubMeasure table which created the subform frmSubMeasure.
In the sub the append query do update the form with the new MeasureID from the mainform and the form is available to enter new data. I want the subform data to be duplicated as well

In the query I included all the fields from the tblSubMeasure table and this is appended to the same table tblSubMeasure and I place a tag on the MeasureID using "[Forms]![frmManagers].[Tag]"

Code:
Private Sub btnDuplicate_Click()
Dim dbs As DAO.Database, Rst As DAO.Recordset
Dim F As Form
'Return Database variable pointing to current database.
Set dbs = CurrentDb
Set Rst = Me.RecordsetClone

[Code] .....

View 1 Replies View Related

Unable To Create A Main Menu Page For Database

Jun 2, 2015

I want to create a main menu page for my database. I have tried the Navigation form and obviously I am doing something wrong....because the tabs won't open the forms. We have Access 2010 at work and I would like to create something similar to this:

Cardinal Rap - Main Menu

[button] Input Monthly data
This button would take me to another screen that would list the tables for appropriation, expenditures and revenue, each with their own respective button

[button] Reports
This button would take me to another screen that would would list the reports available each with their own respective button

[button] Monthly reconciliations

This button would take me to another screen that would list the tables necessary for my monthly reconciliations each with their own respective button that open that table.

The tabs in the Navigation form don't seem to do anything.

View 1 Replies View Related

Modules & VBA :: Error - Microsoft Access Was Unable To Create MDE Database

Sep 19, 2013

I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.

how to fix this problem in MsAccess 2003?

View 6 Replies View Related

Forms :: Unable To Create Command Button To Open Folder On Desktop

Feb 19, 2015

I am simply trying to create a command button to open a folder on my desktop

Cannot seem to find this code

This is the path to the folder I want to open

C:UsersJONATHANDesktopCMS FILES

View 4 Replies View Related

Tables :: Unable To Create A Database By Compiling Records From Multiple Excel Sheets

May 22, 2013

I am trying to create a database by compiling records from multiple excel sheets. however, since most of the clients still uses the excel sheets to enter records, I am thinking if it's possible to create a linked table in access from these excel sheets that are hosted on an online server.

also is it possible to merge multiple linked tables together? if they have the same field range, so they will append when the linked tables gets updated.

View 3 Replies View Related

General :: Create A Button That Will Create A New Empty Backend

Oct 31, 2013

I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.

View 7 Replies View Related

General :: Unable To Add New Record To Table

Apr 28, 2015

I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to the visit form to add all of the visits for the month. I have never had a problem adding data to any of my tables but now I am unable to add data to the visit table. As much as I didn't want to I brought up last month's back up to enter the patients again. Before I did I checked to see if I could add visits - I could not. So I checked January's back up - same issue. I made no changes to the db before trying to add a visit .

View 10 Replies View Related

General :: Unable To Enter Data In Form?

Mar 10, 2014

it is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc

View 3 Replies View Related

General :: Unable To Set Password - Open Dialog Box

Mar 2, 2015

When trying to set a password I receive the following message.

You must have the database open for exclusive use to set or remove the database password.

To open the database exclusively, close the database, and then reopen it by clicking the File tab and using the Open command, In the Open dialog box, click the arrow next to the Open button and then select Open Exclusive.

When I follow the instructions, I don't get a dialog box. How do I set a password?

View 7 Replies View Related

General :: Unable To Close A Form With Subform

May 30, 2015

I am trying to close a form with a subform.

I enter data in the main form and then the subform.

The main form has a save btn with an on click event which includes at the end of code

If Me.Dirty then
Me.Dirty = false
DoCmd.Close
DoCmd.OpenForm "FormName"

However the Form will only close and open the required form if I remove the two "Dirty" Code lines.

I am obviously trying to ensure that the data is saved on both the main and subforms using the If Me.Dirty......code

View 7 Replies View Related

General :: Unable To View Design Of Any Objects

Oct 4, 2012

I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of any objects. How do I enable the menu items?

View 1 Replies View Related

General :: Unable To Transfer To Online Server

Apr 19, 2014

I have a MDB file that I am unable to transfer to my online server (I get a 'critical transfer error' message. I am, however, able to upload other MS Access databases to the same server using the same FTP software.This points to a problem either with this particular database itself or my ASP code.

I have six fields, all text fields, with simple named columns (such as username, password, etc). In Design View.

View 4 Replies View Related

General :: Application Was Unable To Start Correctly

Oct 31, 2013

The application was unable to start correctly (0x00007b)not sure it's an Access issue exclusively. What fix to apply (is it a Registry entry that's corrupted perhaps?).

View 5 Replies View Related

"Hidden Module" Unable To Create MDE

Jul 12, 2007

Hi,

I have found a few threads on here regarding creating MDE files but have found none stating this message...

I have been trying to create an MDE version of our Db but keep receiving the message "Complile Error in hidden module: Form_formname"

I thought I'd see if it was just that one form causing issues, so I deleted it! But now it's just moved onto another form!!

If anyone could shed some light on this I'd be most appreciated.

Thanks.
Matt

View 9 Replies View Related

General :: Unable To Modify Pivot Tables / Charts

Feb 11, 2014

When I start my database normally, I'm not able to add fields, change chart type, etc, by right clicking in a pivot chart or table. It works when I open the database while holding down the shift key though, so I suppose there is an option in my database somewhere that I have changed, but which one.

View 1 Replies View Related

General :: Unable To Edit Records - Fields Are Locked

Jun 11, 2013

I have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other users front end is working fine, expect for the one.

View 2 Replies View Related

General :: Split Database - Unable To Find Table Location

Mar 24, 2014

I'm having a problem with a database that i had split. While creating teh database, i had it stored on my personal drive at work, but wanted to move it to the shared drive so the data could be stored there. this is to deal with cross site network connectivity issues that we encountered with another database here at work.

When splitting the database, i split it on my personal drive and then dragged the back end to the common drive. I realized my error, but when attempting to correct it, i somehow have two of the same file, and no back end?

I receive the error on the attached document when attempting to access any of the tables or information in either of the files, the "back end" that i placed on teh drive, and the "front end" that i have on my personal drive.

I also tried to relink the tables through the linked table manager, but receive the same error when attempting that.

Is there a way to recover from this? I had backed up my file by making a copy prior to splitting, but somewhere in this process, this became linked to these and is having the same issue. Is there a way to recover the old "unsplit" version? I cannot copy over all of teh tables, etc. because i get the same error as earlier.

I can attach a copy of my database for reference...

View 5 Replies View Related

General :: Unable To Disable Mouse Scroll Wheel On The Form

Apr 24, 2014

I'm trying to disable mouse scroll wheel on the form but no luck here,

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved