Compile Access 2016 with a Split Database

Question

  I am trying to compile the Access 2016 DB as an .accde file.  The database is split from the front end.  Yet when I start the FE.accde file, then menus work.  Yet, I cannot get an db retrieval to work.  I can see the data on the edit screens, yet when I enter the selection nothing comes back to the screens.  Also, none of the buttons work for exiting the screen or anthing else when I click on them at the bottom of the screen.  Can someone plz let me know how to resolve this.  I want to have the FE for the production version, not display the tables, queries, forms, etc or the menu options at the top of the screen for File, Home, Create, etc.  They should just have screens to work with.  Thanx in advance.

Answer 1

Have you validate that the tables are properly linked to the back-end database file?

Have you created a Trusted Location for the front-end?

 

" I can see the data on the edit screens, yet when I enter the selection nothing comes back to the screens."

Could you explain more please, I do not understand.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

1.  Have you validate that the tables are properly linked to the back-end database file?

A.  in the *.accdb, they work just fine.

2.  Have you created a Trusted Location for the front-end?

A.  Yes

" I can see the data on the edit screens, yet when I enter the selection nothing comes back to the screens."

3.  in the *.accdb, I get the data.

4. This the *.accde using the same criteria

Answer 3

Are your testing the ACCDE on the Same machine? If not you may be missing a reference?

I Assume the Header is a fiter? how do you update the detail after the header is entered?

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 4

Hi ballj_351,

Try to recompile the code in accdb database and then again try to create accde database.

Then try to make a test.

Let us know, whether it work for you or not.

We will try to provide further suggestions to solve the issue, If issue persist.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 5

Yes I am testing the ACCDE on the same machine.

Yes, the header is a filter.  I have an after update event on the 'Count' field.  I check for all the data being entered on the header, then I perform a select to get the records that match the criteria.

Answer 6

I have done that and I get the same results as before.  I do not get data returned from the tables and the buttons I have in the footer, nothing works when I click on them.

Answer 7

The term you use for your field name "Count" is a function name.

Try to wrap it in square brackets in your query and code. e.g. [Count]

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 8

Also you should post the SQL of the Query that results from your Count AfterUpdate Event...

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 9

Hi ballj_351,

Is your VBA code contains empty sub routines like below?

Private Sub Form_Type_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub Form_Load()

End Sub

If yes, Then try to remove them and again try to fetch the data using ACCDE version of database.

Also try to make some change to your form (It can be anything) save it and again compile it and then make ACCDE database and check whether it solves your issue or not.

If issue persist then try to add a new trusted location and check whether it makes any difference or not.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 10

I call it count on the screen text name.  Yet it is a combo box and it is named cbocount.  When I reference it in the table, I always use tblname.count.  This is not causing me any issues.

Answer 11

Yes I did have some of them.  I went through and removed all of them from the forms.  Then I compiled the code and I still have the same issue as before.

Answer 12

Hi ballj_351,

I suggest you to create one sample database for testing purpose and try to add some functionality like your original database.

Then after compiling it make an ACCDE file. check whether it works correctly or have the same issue.

It will help us to narrow down the issue that whether issue is related with your database or Access Application.

Also if possible then try to copy the database to another machine and make ACCDE file on that machine and check whether issue persist.

Let us know about your testing result.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 13

Ok, so lets go back a bit further...

Can you confirm you application runs correctly as an accdb?

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 14

What is the code behind your Filter/Retrieval?

If you look in the table, is the data actually saved?

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 15

Yes it runs just fine as a accdb.  I have not challenges when running it as an accdb.

Answer 16

yes the data is saved.  Again, when IU run it as an accdb, I have no issues.  Just when I try to compile it to an accde.

Answer 17

I did the following:  Also if possible then try to copy the database to another machine and make ACCDE file on that machine and check whether issue persist.

I copied it over from the server to my local machine.  Then I started the application, updated the linked table to the new location on my machine, updated the trusted source to the location on my local machine and then saved everything.  Started the accde and got the same issue.

I am going to create a small new application and then try to compile to see what happens.

Answer 18

We'd need to see a sample database or at the very least the code involved in your record filter/lookup.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 19

It is not just the filter, nothing works.  I.E. I have an exit screen and that does not work either.  Nothing works on any of the screens that I have completed.  If you let me know where you want me to put it, I will copy everything out there for you.  I will copy the accdb, accde and the be database.

Answer 20

Hi ballj_351,

You can try to post your sample database with dummy data in it on any free resource sharing website.

Then you can share the link here. If you are not allowed to post the link then you can paste the link as simple text.

We will try to visit the link to get the database and try to make a test on our side.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 21

Here is a link to the folder in dropbox:

I put the accdb, accde and the be_database there.

1.  Run the accdb

2.  Set Trusted location top where you copy the information to.

3.  External Data -> Linked Table Manager (Set to where the *_be is located)

4.  choose Manufacturer Data from the Menu and attempt to exit this menu.

5.  Choose Manufacturer Edit.  Acura, 2018, ILX, 1  The data will be retrieved.

6.  Exit everything.

A. Run the accde.

B.  choose Manufacturer Data from the Menu and attempt to exit this menu.  Nothing

5.  Choose Manufacturer Edit.  Acura, 2018, ILX, 1  The data will NOT be retrieved.

https://www.dropbox.com/sh/4ver21zt4fxhwaa/AACM6BZF4TC2faDlyZ8GSZUoa?dl=0

Answer 22

Hi Neal,

Yes i could replicate the fault when i took you accdb and built a new accde.

But i ran a compact and repair then built a new accde and all was fine!

I suggest you have some minor corruption issue...

Try a decompile then compact and repair. Then publish...

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 23

I just did that on the accdb, and the *_be.  Then I created a new accde and I have the same issue.

Answer 24

Try a full office repair! 

In Windows 10: Settings > Apps and Features > Microsoft Office xxx 

Then pick Modify and Online repair.

Then Open your Acccdb. Compact/Repair. Then save at Publish to accde...

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 25

I performed each step and I get the same result.

Answer 26

I also note that on opening the VBA IDE window and running Debug > Compile the "Dealer Main Edit" form opens in design view.

Then on closing, it wants to Save Changes!

Following this save it will correctly build the accde!

 

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 27

Are you sure you are creating a brand new .accde file after you change anything in the .accdb file? Any existing .accde file needs to be deleted and replaced with a new one every time you change anything in the .accdb file and compile the VBA code in it. So:

1. Delete any existing .accde file
2. Open the .accdb file. Make sure it is working properly and compile any VBA code you have in it.
3. Create a new .accde file from the .accdb file.
4. Open the .accde file. There should be absolutely no difference in function between the two files as long as you make sure the .accdb file is properly linked to the BE file and no VBA compile errors occur before creating the new .accde file.