Create FrontEnd and BackEnd for Multi Users (1 Viewer)

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
Hello everyone !
I want to use my database on three desktop computers with the same network. But I don't have server. For that need suggestions to set up file based on Multi Users. My 3 users using the ms Access 2016 ver.

First I split my database, now it has a twist file. The twist file opened and worked well. After I create the .accde file then show the access blank page.

Q1. Why is my .accde file open but does not show my Login Form ?
Q2. If I want to later add a new Form or Report then how can I add it in the .accde file ?

Any help will be appreciated.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:12
Joined
Oct 29, 2018
Messages
21,358
Hi. Are you using an Autoexec macro or a Display Form?

You keep a master copy of the ACCDB file and make your changes there. When you're ready to distribute it, you make a new ACCDE file and replace the old one.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:12
Joined
May 7, 2009
Messages
19,169
also, i think you can only open an .accde file on the Bitness it was
created. if you created it on x32 msa, you can only open it on x32?
 

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
Hi. Are you using an Autoexec macro or a Display Form?

You keep a master copy of the ACCDB file and make your changes there. When you're ready to distribute it, you make a new ACCDE file and replace the old one.
Thank you so much for your reply.
No, I dont using the autoexec macro. Yes, Using the Display Form.

I have a master copy of .ACCDB in others computer. Duplicate copy to make all of the process.
Q2, I understand thanks.
 

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
also, i think you can only open an .accde file on the Bitness it was
created. if you created it on x32 msa, you can only open it on x32?
Thank you so much For your reply.
I understand what you means. You remind me good point, I totally forget it. Thanks again and appreciated for that.

Still my pc configuration x64 bit and Win10 ver where I create master file and .accde file.

And I checked my all pc that have one pc x32.
So, how to run in the x32 bit pc ?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 13:12
Joined
Feb 28, 2001
Messages
26,999
The question is not whether the computer is 32-bit but whether the version of Access is 32-bit.

If you develop a 32-bit app, it WILL run on a 64-bit version of Windows. The little secret is that Microsoft didn't port all of THEIR 32-bit apps so they have to maintain compatibility with 32-bit apps. To verify which version of Access is on a machine, open it. The ribbon will show up with tabs. Open the File tab, then near the bottom click the Help option. To the right of the resulting screen, you will see "About Microsoft Access." Under that you will see a version string but in parentheses after the version you will see either 32-bit or 64-bit. That is the "bitness" of your Access version. The rule is simple. You must run your app on a version of Access that is the same bitness as the version under which you built it.

In a mixed environment, the rule is "lowest common denominator." If you have a 32-bit PC, that user will not be able to run the app unless you build the app on a 32-bit Access. I will emphasize the point: 32-bit Access doesn't have trouble running on a 64-bit machine. I do it all the time at home and did it at work before I retired.
 

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
@The_Doc_Man Thanks for your suggestion.
Maybe I do it as per your instructions.
Still, I don't open the FrontEnd file after make it .accde. What I do for that? Any suggest ?
 

Minty

AWF VIP
Local time
Today, 18:12
Joined
Jul 26, 2013
Messages
10,355
You keep a "normal" accdb development copy for you to work with.
When you are ready to deeply you compile and save as an accde.

The fun comes if you need both 64-bit and 32-bit versions, and are running on a 64-bit version
 

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
You keep a "normal" accdb development copy for you to work with.
When you are ready to deeply you compile and save as an accde.

The fun comes if you need both 64-bit and 32-bit versions, and are running on a 64-bit version
Yes I did. I have a master copy.
First I create a Split then check and run perfectly.
When I FrontEnd file make .accde file then not working? This is the problem now...
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:12
Joined
Oct 29, 2018
Messages
21,358
Yes I did. I have a master copy.
First I create a Split then check and run perfectly.
When I FrontEnd file make .accde file then not working? This is the problem now...
Are you able to share a sample copy of your db?
 

smtazulislam

Member
Local time
Today, 21:12
Joined
Mar 27, 2020
Messages
806
By the way I tried many ways and learning from Youtube. I solved the issue.
Now I facing another problems TRUST location. "Access Security Notice ". See attached picture.
How can I resolve this message.
 

Attachments

  • Capture.PNG
    Capture.PNG
    19.8 KB · Views: 206

G37Sam

Registered User.
Local time
Today, 22:12
Joined
Apr 23, 2008
Messages
454
Add the database path to the Trusted Locations

File -> Options -> Trust Center
 

Users who are viewing this thread

Top Bottom