Re: Add field to the table in the backend


I see no reason that would prevent you from simply opening up the back end,
and opening up the table in design mode and adding the new feel that you
need.

In fact I would assume over the lifetime of your application, that you're
often adding new updates, bug fixes, new reports, and on the ocation, also
add a few fields here and their too existing tables.

The process and things that you have to watch for after you add a new field
to the table is exactly the same with the non split application.

For example often people build a form using the wizard, and a query. You
often see people asking the question how come after I added a new field to a
table, it does not appear or can't be used in the form? The answer of course
that you have to go back and edit the query to add this additional field
into the query grid ...and *THEN* you'll be able to use that field on a new
form (I'm assuming you're distributing a new front end with the updates and
changes to the forums also).

of course if you're in a different location, or don't have physical access
to that back and tabled, then you're updating or modification of the table
structures is a little bit more tricky, and the solution that case is to
start writing some code to open up the back end database and add those
additional fields.

I will continue to watch this thread a bit, and if you're looking for some
sample code that does update the back end, just ask and I will post a few
lines of code (however, keep in mind that you really don't need this cut out
if you can just open up the back end table and modify the tables direclty).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx



.

Relevant Pages

  • RE: TableAdapter.Update fails with missing parameter
    ... Select Query). ... And that worked and then the Updates started working. ... I see that when I enter a new value in the bindingNavigatorPositionItem ... Thus, VS IDE generates GridView ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Update/Append/AddColumn
    ... K Dales wrote: ... everything - even your update/append query - the way it is, ... run your query find any matching employee records by joining your imported ... Then when doing the updates, instead of overwriting the wage info mark the ...
    (microsoft.public.access.queries)
  • RE: Update/Append/AddColumn
    ... everything - even your update/append query - the way it is, ... run your query find any matching employee records by joining your imported ... number) and use the result as an append query that adds the OLD record values ... Then when doing the updates, instead of overwriting the wage info mark the ...
    (microsoft.public.access.queries)
  • Re: Back end database lock-up
    ... Or are you programmaticlly executing some updates in an action query or some code? ... Check the open mode and locking strategy of *each* front end. ... Default Record Locking: No Locks ...
    (comp.databases.ms-access)
  • Re: Subreport ControlSource
    ... You can set your subreport's record source to a saved query. ... You would then run some code prior to opening ... >> This should be done prior to the main report opening. ...
    (microsoft.public.access.reports)