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!
9 2179
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!
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.
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.
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.
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.
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
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!
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 32,556
Expert Mod 16PB
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jon Ole Hedne |
last post by:
I have worked on this problem some hours now (read many-many...), and I
can't solve it:
In vba-code I create a table with Connection.Execute, and add some data to
it. This table is saved in the...
|
by: matt bourke |
last post by:
Hi,
Can you please tell me what the advantage is of using an access backend with
a VB frontend OVER access as a frontend and backend.
M
|
by: Chris |
last post by:
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first...
|
by: John |
last post by:
Hi All,
I have two backend databases that area link to a frontend database
where information is entered, retrieved and deleted. The information
accessed from the frontend database is coming from...
|
by: DD |
last post by:
Hi
I have a split database, that is packaged and used in a runtime
enviroment.
I want to make it easier for the user, a button on the frontend
"Export Backend"
They can click on the button...
|
by: PC Datasheet |
last post by:
I have zero experience with using a SQL database for a backend and Access
for a frontend. I have some questions:
1. Does an SQL database have tables?
2. How does Access connect to the data in...
|
by: Wayne |
last post by:
I have a backend database (Backend1.mdb)that has 3 main data tables,
I'll call them Data1, Data2 and Data3, plus several other associated
tables. All relationships are set in the backend database...
|
by: Jim Devenish |
last post by:
I wish to copy a table on a SQL Server backend to a table on an Access
(.mdb) front end in the simplest way.
I have the following to get the recordset but am seeking something
easier.
Dim...
|
by: Kaustubha B S |
last post by:
hi! this is Kaustubha from BLR , INDIA
i had a doubt about Client/server technology
1) how does a backend-frontend tool in clientserver technology work
and what ...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |