Modify Backend db from the Frontend

[philelpko]

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!

[George Oro]

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!

[philelpko]

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.

[George Oro]

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.

[philelpko]

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.

[George Oro]

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.

[hariharanmca]

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

[philelpko]

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!

[hariharanmca]

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.

[NeoPa]

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.