Split Access DB and make it an executable file at the same time

3 New Member

Hello,

Can anyone guide me through the process of splitting an Access database and then creating an executable file of the back and front end?

I have a database that will be used by multiple users so I would like to split it. But I would also like to make it an executable file. Is this possible?

I know how to split the database, but not sure how to make it a standalone such that new records from the various users of the front end are all updated to the back end tables.

I would appreciate any suggestions. Thanks in advance.

Jun 28 '12 #1

Subscribe Reply

3399

Mihail

759

Contributor

Hope I understand well your issue.

1) Store the BE on one computer (the best you have as speed and memory).
2) Distribute the FE to every user.
3) For every FE relink tables to the BE (I think that users are in a network).

If you will modify in the future the FE repeat steps 2-3 with the new FE

More: You can design specific FEs (for every user specific tasks) based on the same BE.

Unfortunately, I have no knowledge about making executable files. Sorry.

Jun 29 '12 #2

LeanXp22

New Member

Thanks Mihail you understand quite well. I have the DB split into BE and FE already for all users on the network that will be needing it.

Making them executable after splitting it is my challenge.

Is there a way to password protect the folder holding the BE with out it affecting updates to the tables?

Jun 29 '12 #3

Mihail

759

Contributor

As far as I know, you can protect the database (not the folder) by assign access rights based on private passwords.
But this is another question and need to start another thread for that.

For now, again, my knowledge about executable files is very limited: I never use this feature.
But, any FE (and the BE) are different databases. So, you can open every one and make it executable (.accde for 2007 or .mde, if I remember well, for 2003).

Jun 30 '12 #4

LeanXp22

New Member

That makes sense. Thank you again!

Jul 1 '12 #5

Seth Schrock

2,965

Recognized Expert Specialist

I've created installation files for the FE in Access 2010. You have to go to the control panel and change your installation to included the package manager. You can then go to file>Save & Publish>Package Solution. You will then be taken through a wizard that will create both an .MSI file and a .exe file.

Jul 1 '12 #6

Similar topics

28902

How to make a executable file, such as myprogram.exe, for java ?

by: QQ June | last post by:

Hello, I have some java classes. But, I don't want my users to type "java my_java_program" every time they run the java class ? How do I pack them together into one executable file, like...

Java

7137

How to make executable file ?

by: BOOGIEMAN | last post by:

Just how to make *.exe file from python code ?? I typed this : a, b = 0, 1 while b < 1000: print b, a, b = b, a+b and saved it as pyt.txt

Python

1764

upload an executable file disguised as gif or jpg

by: aa | last post by:

If I allow people to upload GIF or JPG files on my site, is there a technical possibility to upload an executable file disguised as gif or jpg and execute it on my server?

ASP / Active Server Pages

8808

Access Database to Executable File

by: Charles Robinson III | last post by:

Is there a way to convert an entire access database file (*.mdb) to an executable file (*.exe)? This database will be on alot of computers, and I really do not want to put Microsoft Access on each...

Microsoft Access / VBA

2082

How to call an external executable file in Add-in

by: Kelly Xie via .NET 247 | last post by:

Hi, I am building an add-in to the .NET framework using C#. I need to call an external executable file. It works fine with the computer I am working now. How can I make it work when I install the...

C# / C Sharp

3821

Get actual executable file path in Registry

by: yxq | last post by:

Hello, I want to make a utility to clean Registry, my problem is that: How to get actual executable file path? There are lots of command line modes in Registry: c:\program files\cccc\aaa.exe...

Visual Basic .NET

4090

How to protect my data in Executable file?

by: SpIcH | last post by:

Hi All, This is all about protecting my data in Executable file. I have developed a program in Visual Basic .NET 2002. I have many questions in mind... please help me to complete my project. ...

Visual Basic .NET

2057

Where can I find the GD Library standalone executable file?

by: comp.lang.php | last post by:

I downloaded the tarball and while was able to compile within PHP with no problems, I am having memory timeout issues involving image manipulation with extremely large images (800K - 2mb). ...

PHP

7024

Compiler executable file c:\..\v1.1.4322\csc.exe cannot be found.

by: mudge | last post by:

Hi, I'm getting some very strange problems with some C# code. We're running an ASP.NET application on a local server in a DMZ. If I access it using the internal address, the application works...

ASP.NET

1575

strange problem with executable file

by: manontheedge | last post by:

i'm using microsoft visual studio 6.0, and i have a program that reads in a text file, then looks for a variety of things, sorts them into categories, and prints them out ( to the console AND a...

C / C++

7204

What is ONU?

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,...

General

7091

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7342

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6998

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5586

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5018

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3171

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

1516

transfer the data from one system to another through ip address

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 ...

C# / C Sharp

391

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General