473,898 Members | 3,896 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem Converting .ACCDB to .ACCDE using Access 2016

492 Contributor
My program searches through all drives on the computer looking for the _be.accdb database, this allows the user to put the database on a network drive. The program when compiled was working fine, but the last time I compiled it and ran it using Access runtime it didn't find the database, however if I run the .accdb program it works fine. What could be the cause of it not finding the database when in a compiled mode.
Any help would be appreciated.
3 Weeks Ago #1
6 144
NeoPa
32,584 Recognized Expert Moderator MVP
Hi Tom.

Can you confirm that all other details are exactly the same when you ran it both times. The likelihood of an ACCDE behaving differently from an ACCDB in the same circumstances is vanishingly small. Before we waste time looking for where a difference may be possible we need vigorous tests run that use all else exactly the same and only the two FE files being different as the ACCDB & ACCDE.

Only if we need to take it further will we need to look at the actual code being run - which you've not included at all at this point anyway.

Logical step by step though. Run the vigorous tests first then we'll take it from there.
3 Weeks Ago #2
NeoPa
32,584 Recognized Expert Moderator MVP
NB. Compiling is possible with VBA but it's quite different from converting an ACCDB to an ACCDE. I've adjusted the title to reflect this for you.
3 Weeks Ago #3
CD Tom
492 Contributor
Thanks for the quick response, I'm almost positive that there was no changes to that section of the program. But just to be sure I'm going to compare the previous .accdb and see it there is any difference, I'll let you know if I find anything.
3 Weeks Ago #4
NeoPa
32,584 Recognized Expert Moderator MVP
Forget that Tom. Why not start with your ACCDB. Test it works. Create an ACCDE from it. Test the ACCDE works. Obviously make no changes to the environment in the mean time. Run the tests from the same place. Do all the usual things to ensure the only possible difference between the two tests is ACCDB & ACCDE files.
3 Weeks Ago #5
CD Tom
492 Contributor
That's kind of what I did, Opened the .accdb that was working and just made the changes that I made to the one that wasn't working and created the .ACCDE and everything is back working again. Thanks for your help.
3 Weeks Ago #6
NeoPa
32,584 Recognized Expert Moderator MVP
No worries :-)

Sometimes, just by following the basic steps fastidiously & precisely, we find that things work. This indicates something different that we didn't even notice was involved in the time when it didn't. Something subtle that doesn't even register when we did it / when it happened.

Many good hours get spent chasing after such issues purely for the want of carefully checking & repeating our initial steps. Always a good first step ;-)
3 Weeks Ago #7

Sign in to post your reply or Sign up for a free account.

Similar topics

3
2206
by: Rob F | last post by:
I am trying to compile a string class which was working before but subsequent attempts to make it more 'object orientated' (privatizing the member variables and implenting query functions) it refuses to compile in Visual C++. Here is the code: http://www.rbf.org.uk/xstring.h When compiling I get the following: \xstring.h(87) : error C2662: 'query_length' : cannot convert 'this'
2
2122
by: etienne | last post by:
Hello, I'm trying to compile this C++ code with gcc 3.4.5 under Solaris/SPARC (from a complete application, the file is : FullLinkedList.hh) but the make fails (no problem when compiling under ubuntu/x86) : (from line 330 to 481) /***************************************************************************** * ITERATOR SECTION - INNER CLASSES
1
1384
by: soconnell | last post by:
I created an application in the English version of Access 2000, and my customer is trying to run it in Mexico using a Spanish version of Access. When the application comes up, it asks for a password, even though the application is not password-protected. Has anyone experienced this problem? I was thinking of telling the customer to try installing the English version of Access, but I wanted to have a reasonable basis for thinking it...
2
15665
by: CD Tom | last post by:
I've installed Office 365 and when I bring up Access the back ground color is White, I've looked in the File, Account, but when I click on the Office Theme I only get two choices Colorful, White, no matter what I choose I only get the white. In Access 2007 I had the I had a choice of Blue Silver or Black. How do I get my Blue back in Access 2016 any ideas. Thanks
1
3590
by: CD Tom | last post by:
I'm thinking about updating from Access 2007 to Access 2016 but have run into a problem. I can't find any place to compile my accdb to an accde. I've installed the office 2016 and can bring up my database with out any problems, but where is the make accde? Thanks for any help.
2
2298
by: Silver993 | last post by:
I have created Access 2016 Database with custom Icon. I canít figure out what I am doing wrong. Here is the problem: When I tested the database in my developing Computer, it opens with my custom Icon and everything is great as expected. But when I move it to another computer that does not have Access 2016 installed and run my Database in Run-time (Accde), everything work OK. But the only problem is that my Application custom Icon got replaced...
1
2510
by: Murphy | last post by:
I am gettig ready to upgrade from Windows XP / Office 2007 to Windows 10 / Office Professional 2016. Are Access 2007 databases compatible with or convertible to Access 2016?
8
2668
by: MS Access Probz | last post by:
Hi all, I'm new to this forum. My Access skills are above basic, but I seem to be having trouble getting to the next level regardless of how much time I invest in it. I'm using Access 2016. Here's the current issue I'm working on. I have two forms. One called Frm_AddSku, the other called Frm_AddProdSubCat. I know that Access has a built in form property called List Items Edit Form, but I've added some VBA in an On Not In List Event,...
1
1455
by: HalloweenWeed | last post by:
Good day I am new to the forum and still learning MS Access. I have developed a code to allow 'live' 'searh-on-the-fly' queries 'as you type.' However, the problem lies in that when doing a query you lose the focus of the control in use, and when the SetFocus is set back to the control it selects all the text typed so far, so the next typed letter overwrites all the previous. I have developed a workaround that deselects the text and moves the...
10
3209
by: Tango1 | last post by:
Hi Guys One of my clients is still having problem with an Access system breaking a couple of times a day with an 'Unrecognized database format' error. I posted back in November suspecting it was an intermittent network causing the problem. Previously the app had been running without problems for more than 10 years. The backend is hosted on a server in the IT dept. It seems that most of the time there are only two users; the Laboratory and...
0
9993
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
11265
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10858
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10487
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7189
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5882
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4708
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4297
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3308
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.