Create FrontEnd and BackEnd for Multi Users

[smtazulislam]

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]

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]

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]

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]

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]

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]

@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]

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]

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]

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]

No, I can't. it is a large file.

 

[bob fitz]

No, I can't. it is a large file.

Even if you compact it and then zip it?

 

[smtazulislam]

Even if you compact it and then zip it?

Thank you so much for your reply.
its 38 mb with zip file.

 

[smtazulislam]

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.

 

[G37Sam]

Add the database path to the Trusted Locations

File -> Options -> Trust Center

 

[smtazulislam]

Add the database path to the Trusted Locations

File -> Options -> Trust Center

How I go to file because it is .accde file.

 

[arnelgp]

see this link if it will help:
VBScript - Create/Set Trusted Location Using VBScript | DEVelopers HUT (devhut.net)