form sharing

K

Keith Schmeichel

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?
 
G

Guest

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.
 
K

Keith Schmeichel

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.
 
G

Guest

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.
 
Top