Split database for several projects

quicova

Registered User.
Local time
Today, 04:29
Joined
Oct 31, 2013
Messages
12
Hello everyone.

I created a database and I manage to split it into front end and backend.
now I'm going to make an EXE of the front end.

My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).

I also need to create a button that will create a new empty backend and save it as a new project.

anyone has any ideas on how I can go about this?
thanks so much
 
I created a database and I manage to split it into front end and backend.
now I'm going to make an EXE of the front end.
First, I have to first tell you that it is not possible to actually create an exe out of the front-end Access database file. You can create a compiled version and your users can open and use that with the Runtime version of Access.

My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).

I also need to create a button that will create a new empty backend and save it as a new project.
Here is a link that should provide you with code that will link your front-end file to a specific back-end file. As for having the database to be empty when opened, you could just have the front-end initially linked to an empty database then when a new database is needed, just make a copy and link to that new empty back-end file.

With that said, I am curious to know if you have really thought this through. Although it is possible to do what you are describing. You are going to have issues if you ever need to report on the data from your multiple databases. If there is any possibility that the data from these multiple project databases will need to be combined to provide reporting over all projects for a period of time then you may want to consider having only one back-end file but have it structured so that each project can be identified and provide users with the ability to enter data for one project at a time, but then when needed you can easily combine the info from multiple projects.

If you have some business rule that dictates that you create these multiple back-end files then so be it, but I just thought I would raise the issue.

Good luck with your project.
 
Thank you for the replay Mr.B

I will have to study the compile version to use in runtime, I'm new to access and create an exe was the only solution I found so that users can't change the code or the design.

The reason for creating several backend files is that each project will be totally independent of each other.

I can't see the link you posted?
can you post it again please. maybe is because I'm a new user and I can't see links.

Thanks so much
 
hi Mihail,

super complicated thread. I'm very new to scripting to I didn't got anything :)

and that thread is the reverse of what I'm trying to do. link a specific backend file into the frontend file. and eveytime someone opens the frontend file it is linked to a empty backend file.
 
and that thread is the reverse of what I'm trying to do
No, it isn't.
From any FE you can switch to more BEs. In the same time the other FEs are linked to the same BE in order that all of them to point to the same BE.

super complicated thread
Is not very simple but not as complicated as you say.
 
I'm new to access and create an exe was the only solution I found so that users can't change the code or the design.
Make a note of the site and poster who provided this advice so you can ignore anything they say in the future.

I also think you should review your decision to use a separate BE for each project. Having users switch from one BE to another is awkward and unnecessary and has already been mentioned, makes consolidated reporting very difficult.

If you are saying that you want to distribute the FE with an "empty" BE because each user will NEVER work with any project but his own, that is a whole different scenario. When distributing an app that will ultimately be only a single-user app, I control linking to the BE silently, behind the scenes. I always install the BE in the same directory as the FE so if the links get broken (on install or if someone moved the folder), the application can detect the broken link and using the path to itself and the knowledge of the name of the BE database, just automatically relink using the correct path. I would suggest searching for code that does this rather than using hard-coded links or forcing the user to decide.
 
thanks for everyone replays.

I was given this link
jstreettech.com (J Street Access Relinker)

sorry I'm not allow to post links yet!!! that sucks

which has a download with exactly what i needed if anyone has the same problem.

you just import it to your database and the code is all done.
it promts the user to which backend file he wants to open.

Thanks so much for all your help.
 

Users who are viewing this thread

Back
Top Bottom