Re: Database design

Joan has a good point. For some reasoon I read your question to mean that
you were trying to change the tables, not the other objects.



--
Rick B



"Rick B" <Anonymous> wrote in message
news:uq81fPnoFHA.1464@xxxxxxxxxxxxxxxxxxxxxxx
> There is no automatic way to do this. You could modify a copy, then use
> queries or copy.paste to move the data into the new structure, but
depending
> on your changes this may not always work smoothly. Why would you not just
> change the actual file (after saving a backup)?
>
>
> --
> Rick B
>
>
>
> "Doreen" <Doreen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D5C66953-0C85-4F0C-9F76-9A6A8C35D95C@xxxxxxxxxxxxxxxx
> > Firstly can somebody please tell me if it is possible to do a database
> design
> > change on a separate copy of my database and then bring it on to update
> the
> > one I am using. Does this have any effects on my data already in the
> > database? Secondly is it possible to seperate my data frame from the
data
> and
> > then bring it back on after a design change?
>
>


.

Relevant Pages

  • Re: save action failed on form with multi users
    ... you make a design change. ... already the database in a different instance. ... > I have stripped away the audit log code. ... > sub Onokclick() ...
    (microsoft.public.access.formscoding)
  • Re: Remove Password
    ... "Rick B" wrote: ... This assumes that he created a new workgroup before playing around ... so secure no one could get in!! ... Adding userid's and passwords to a workgroup does not secure a database ...
    (microsoft.public.access.security)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)
  • Re: only display certain query results
    ... That is how you'd do it in a spreadsheet, not a database. ... Rick B ... >>> a specific course for all employees, ...
    (microsoft.public.access.reports)
  • Re: normalization question and one to one relations
    ... Rick, thanks greatly for taking the time to answer me. ... listing a contsraint in SQL Server a matter of a couple of seconds? ... uses "tables" in a relational database, but it doesn't use them as ... recompiling that program changes its level triggering a domino affect of ...
    (comp.databases.ms-access)