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

Modify Backend db from the Frontend

P: 31
Good Morning all,

Lost once again which is becoming a common occurance atm.

My database has successfully been broken into a frontend and a backend db. A problem has now arisen as it has become apparant that db managers need to add additional field names to a table.

I cant find anyway that access will allow you to create additional fields to already existing tables in the backend from the frontend.

In a nutshell, is it possible to create new fields on tables in a backend database from the frontend of the database?

Cheers for any help!
Jan 10 '07 #1
Share this Question
Share on Google+
9 Replies


P: 36
Why don't you just add it on the BE? or you want to do this programatically in the FE?

George



Good Morning all,

Lost once again which is becoming a common occurance atm.

My database has successfully been broken into a frontend and a backend db. A problem has now arisen as it has become apparant that db managers need to add additional field names to a table.

I cant find anyway that access will allow you to create additional fields to already existing tables in the backend from the frontend.

In a nutshell, is it possible to create new fields on tables in a backend database from the frontend of the database?

Cheers for any help!
Jan 10 '07 #2

P: 31
Why don't you just add it on the BE? or you want to do this programatically in the FE?

George
I am trying to make it as easy to use as possible so (fingers crossed) it will need minimal admin intervention. The hope was that a user with the right security setting could do this from a form on the FE.
Jan 10 '07 #3

P: 36
100% its doable. What will be the next step after adding the field? Most probably you will view this in the form to input some data right? If so, eventually you still need to go to the design view.

George


I am trying to make it as easy to use as possible so (fingers crossed) it will need minimal admin intervention. The hope was that a user with the right security setting could do this from a form on the FE.
Jan 10 '07 #4

P: 31
100% its doable. What will be the next step after adding the field? Most probably you will view this in the form to input some data right? If so, eventually you still need to go to the design view.

George
Not quite.

The table consists of several fields containing various information about the users i.e. Names, Logon, e-mail etc

Several of these fields are of a Yes/No format with the field title being the specific project that the person is on i.e. Q35164

The need to add a new field comes from the introduction of a new project, hence another Yes/No field is required.

I am unfortunatly thinking that it will be quicker just to create a new table containing user names and the projects they are working on and using DLookup to filter the data.
Jan 10 '07 #5

P: 36
Sorry but not 100% clear what you up to but it seems you have to change your approach.

Wish you luck mate.

George


Not quite.

The table consists of several fields containing various information about the users i.e. Names, Logon, e-mail etc

Several of these fields are of a Yes/No format with the field title being the specific project that the person is on i.e. Q35164

The need to add a new field comes from the introduction of a new project, hence another Yes/No field is required.

I am unfortunatly thinking that it will be quicker just to create a new table containing user names and the projects they are working on and using DLookup to filter the data.
Jan 10 '07 #6

hariharanmca
100+
P: 1,977
Not quite.

The table consists of several fields containing various information about the users i.e. Names, Logon, e-mail etc

Several of these fields are of a Yes/No format with the field title being the specific project that the person is on i.e. Q35164

The need to add a new field comes from the introduction of a new project, hence another Yes/No field is required.

I am unfortunatly thinking that it will be quicker just to create a new table containing user names and the projects they are working on and using DLookup to filter the data.
for this you can create two tables
and inner goin tables with ids
Jan 10 '07 #7

P: 31
for this you can create two tables
and inner goin tables with ids
All is well again. Shame I had to create the extra table but if it makes life easy so be it.

Cheers all for the feedback and suggestions!
Jan 10 '07 #8

hariharanmca
100+
P: 1,977
All is well again. Shame I had to create the extra table but if it makes life easy so be it.

Cheers all for the feedback and suggestions!

just Consider today you created one field and next day you created one field how you come to know the fields available?
So that you have to keep track on the created fields.
Of course, you can use field count but it doesn’t make any sense.
Jan 10 '07 #9

NeoPa
Expert Mod 15k+
P: 31,273
I'm not sure exactly what you ended up doing, but it sounded before as though you were trying to work in an 'inadvisable' way. The recommended way to add data of the type you were describing would be to put it in a field in another table. If you've done something like that then you've probably saved yourself some trouble and have a more manageable database.
Good luck.
Jan 10 '07 #10

Post your reply

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