Re: fe and be problems with deletion and relationships

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
once you have spitted the application - you have to add references in backend
to delete table in BE - you have to open BE database:
dbengine.opendatabase("c:\my_BE.mdb")

and then delete tables these using tabledefs.delete method

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"jalewis999" <jalewis999@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0E3BFD36-BEE2-4FAA-AAA1-A0E6AE77D502@xxxxxxxxxxxxxxxx
I have just split a completed database and I have a couple of problems.
I add 4 new tables with relationships for each new user and have to delete
them if a user is deleted.
when i create the relationships they only show in the front end. I remember
reading in a post that relationships are passive and do nothing other than
supply the default JOINs and child Master links. If this is true I would like
to remove all of them and get rid of a head ache. I'm concerned about if they
have any impact on record updates in forms etc. Enforce referencial integrity
is not used and the design is finished. Users won't have access to any tables.
Also when I delete a table after removing the relationships using
DoCmd.DeleteObject it only deletes the link. What is the best method of
deleting backend tables from the frontend. The backend is a normal mdb.
Thank you for any help.

.

Relevant Pages

  • Re: Why would the VB6 exe not show up in the task bar
    ... Sub Main, you should unload all forms, set any references still in scope to ... and disable any active Timers. ... references to the backend database so I can compact the backend or ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.vb.general.discussion)
  • Re: fe and be problems with deletion and relationships
    ... Best regards, ... The problem i had was with relationships not references. ... for the tables in use when i split the db are in the backend. ... "Alex Dybenko" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 200: Module not found
    ... the VBA window; however, it's probably something that you already know. ... even if all the references seems to be valid; ... >>> an Access database between a backend and a frontend. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... really powerful machine to run the database front-end, ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... Report as the report writer and Access as the ...
    (microsoft.public.access.formscoding)
  • Re: Why does splitting a mdb make it slower?
    ... In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can see each row being created quickly. ... I created a table on the backend called KeepOpen. ... performance when opening the main database and opening tables and forms, by forcing the linked database to remain open." ... The folder name is 8 characters in length. ...
    (comp.databases.ms-access)