Creating and linking table in Backend database

[Striker99]

Hi, I just splitted my database into FrontEnd and BackEnd. Now the problem is when I run VBA (from Frontend) which contains append query to create new table from the Backend tables, the new table is created in FrontEnd database. I don't want to create table in Frontend, instead I am trying to create table in Backend and linked to Frontend. Not sure how to create table in Backend and linked to Frontend?
I have already tried to find the solution but I must be using the wrong criteria. Does anyone has example code with bit of explanation?
Thanks

 

[ajetrumpet]

Just out of curiosity here, what's the FE and BE?

 

[boblarson]

Hi, I just splitted my database into FrontEnd and BackEnd. Now the problem is when I run VBA (from Frontend) which contains append query to create new table from the Backend tables, the new table is created in FrontEnd database. I don't want to create table in Frontend, instead I am trying to create table in Backend and linked to Frontend. Not sure how to create table in Backend and linked to Frontend?
I have already tried to find the solution but I must be using the wrong criteria. Does anyone has example code with bit of explanation?
Thanks

Why do you need to use code to create a table? You should have your design in place and normalized and then you should NOT have to create tables. Please elaborate on what and why you are doing this so we might be able to give proper guidance. What you need may not be what you think you need.

 

[ajetrumpet]

What you need may not be what you think you need.

I'll second that, and third that, and fourth that, etc...

 

[Striker99]

Bob Larson said

Why do you need to use code to create a table? You should have your design in place and normalized and then you should NOT have to create tables. Please elaborate on what and why you are doing this so we might be able to give proper guidance. What you need may not be what you think you need.

I can create and link new table if I run my query/vba from backend database but I don't want to do this and would like to use Frontend database to perform such tasks. I am using my base tables and run query to create tables on weekly basis in Backend database. There is no issue of data normalisation or similiar.

 

[boblarson]

I am using my base tables and run query to create tables on weekly basis in Backend database. There is no issue of data normalisation or similiar.

Creating tables on a weekly basis WOULD mean that there is a normalization problem. You shouldn't be needing to create a table weekly.

 

[Striker99]

Bob Larson
Creating tables on a weekly basis WOULD mean that there is a normalization problem. You shouldn't be needing to create a table weekly.

Forget about data normalisation or anyother design issue. I just ask simple question How to create table from frontend to backend?

 

[WayneRyan]

Striker,

This might help:

http://www.officefrustration.com/showthread.php?p=2628256

But, they are right about creating a table on a weekly basis ...

hth,
Wayne

 

[Striker99]

Thanks Wayne for your reply

I will look at the link you suggested.

Sometime you have to break the rules to keep the balance!


Striker

 

[boblarson]

Thanks Wayne for your reply

I will look at the link you suggested.

Sometime you have to break the rules to keep the balance!


Striker

And sometimes, if given enough extra information, alternative methods of accomplishing the same end result can be suggested without breking the rules.