form sharing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have upsized my access database to sql server. How do I share my forms
with other users so we all have the same forms, and automatically have form
changes?
 
hi,
sounds like you are setting up a front end/back end
relationship.
the way it works here is that everyone has a copy of the
main database on their locals except the local copies have
links to the main tables on the sql server. no tables
changes are made in the main database then the users copy
the new changes then software relinks their tables.
 
I,m relitively new to this. SQL has all the data and all the users can
change the data and see it. When the admin creates a form the rest of the
users don't see it and can't use it. How do I share forms or make the forms
universal. Everyone is using Access to connect the the SQL database.
 
hi again,
You would have to load the new forms on the locals.
either file export to each machine or programmaticly.
Programaticly, i'm not sure how that is don't but our
system does it. and it probably don't use vb.
for that part you may have to repost to some one more
advance on that subject.
 
Back
Top