By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

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

P: 3

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
Share this Question
Share on Google+
5 Replies

P: 759
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

P: 3
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

P: 759
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

P: 3
That makes sense. Thank you again!
Jul 1 '12 #5

Seth Schrock
Expert 2.5K+
P: 2,941
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

Post your reply

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