By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,363 Members | 3,622 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,363 IT Pros & Developers. It's quick & easy.

question about Access

P: n/a
Kip
I have an office with approx 8 people. I have used Access with a Form on my
personal PC for client records. I was wondering if I could put the Access
table on a server and put shortcuts on each work station to allow users to
view, update records?

Thanks in advance
Dec 28 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi, Kip.
I was wondering if I could put the Access table on a server and put shortcuts
on each work station to allow users to view, update records?
Don't use a shortcut so that everyone is sharing the same database file on the
network. That often leads to database corruption. If it's just a table (or
tables in the back end), it can be viewed and updated in a multiuser environment
as long as each user has another file (front end) loaded on their workstations,
and the front end is linked to the tables in the back end. Each user will need
a copy of Access installed on his workstation if the front end is an Access
database file. However, other applications can be used as front ends, as long
as they are ODBC-compliant.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Kip" <ja*******@gmail.comwrote in message
news:Od****************@newsfe03.lga...
>I have an office with approx 8 people. I have used Access with a Form on my
personal PC for client records. I was wondering if I could put the Access table
on a server and put shortcuts on each work station to allow users to view,
update records?

Thanks in advance


Dec 28 '06 #2

P: n/a
Hi, Kip.

For more information about split databases (front end and back end), please see
the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:f9******************************@adelphia.com ...
Hi, Kip.
>I was wondering if I could put the Access table on a server and put shortcuts
on each work station to allow users to view, update records?

Don't use a shortcut so that everyone is sharing the same database file on the
network. That often leads to database corruption. If it's just a table (or
tables in the back end), it can be viewed and updated in a multiuser
environment as long as each user has another file (front end) loaded on their
workstations, and the front end is linked to the tables in the back end. Each
user will need a copy of Access installed on his workstation if the front end
is an Access database file. However, other applications can be used as front
ends, as long as they are ODBC-compliant.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Kip" <ja*******@gmail.comwrote in message
news:Od****************@newsfe03.lga...
>>I have an office with approx 8 people. I have used Access with a Form on my
personal PC for client records. I was wondering if I could put the Access
table on a server and put shortcuts on each work station to allow users to
view, update records?

Thanks in advance



Dec 28 '06 #3

P: n/a
Kip
Thanks so much.

Are you saying make a duplicate table on the workstation and server and link
the tables?
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:te******************************@adelphia.com ...
Hi, Kip.

For more information about split databases (front end and back end),
please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote
in message news:f9******************************@adelphia.com ...
>Hi, Kip.
>>I was wondering if I could put the Access table on a server and put
shortcuts on each work station to allow users to view, update records?

Don't use a shortcut so that everyone is sharing the same database file
on the network. That often leads to database corruption. If it's just a
table (or tables in the back end), it can be viewed and updated in a
multiuser environment as long as each user has another file (front end)
loaded on their workstations, and the front end is linked to the tables
in the back end. Each user will need a copy of Access installed on his
workstation if the front end is an Access database file. However, other
applications can be used as front ends, as long as they are
ODBC-compliant.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Kip" <ja*******@gmail.comwrote in message
news:Od****************@newsfe03.lga...
>>>I have an office with approx 8 people. I have used Access with a Form on
my personal PC for client records. I was wondering if I could put the
Access table on a server and put shortcuts on each work station to allow
users to view, update records?

Thanks in advance




Dec 28 '06 #4

P: n/a
Hi, Kip.
Are you saying make a duplicate table on the workstation and server and link
the tables?
Splitting is easiest with the Database Splitter Wizard. It will allow you to
place the file with the tables (back end) on the networked server. Your altered
file will be the front end, and it contains links to those tables in the back
end. It has the form that the other users can use for updating and viewing the
data in the (now) linked table.

Place a copy of your front end on the networked server and have the other users
copy that front end file to their own workstations. The tables will remain
linked.

Practice on a copy of your current database file until you become comfortable
with the process, then do it on the real thing.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Kip" <ja*******@gmail.comwrote in message
news:mf*************@newsfe04.lga...
Thanks so much.

Are you saying make a duplicate table on the workstation and server and link
the tables?
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:te******************************@adelphia.com ...
>Hi, Kip.

For more information about split databases (front end and back end), please
see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:f9******************************@adelphia.com ...
>>Hi, Kip.

I was wondering if I could put the Access table on a server and put
shortcuts on each work station to allow users to view, update records?

Don't use a shortcut so that everyone is sharing the same database file on
the network. That often leads to database corruption. If it's just a table
(or tables in the back end), it can be viewed and updated in a multiuser
environment as long as each user has another file (front end) loaded on
their workstations, and the front end is linked to the tables in the back
end. Each user will need a copy of Access installed on his workstation if
the front end is an Access database file. However, other applications can
be used as front ends, as long as they are ODBC-compliant.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Kip" <ja*******@gmail.comwrote in message
news:Od****************@newsfe03.lga...
I have an office with approx 8 people. I have used Access with a Form on my
personal PC for client records. I was wondering if I could put the Access
table on a server and put shortcuts on each work station to allow users to
view, update records?

Thanks in advance




Dec 28 '06 #5

P: n/a
Hi, Kip.

Once you split the database, you might be interested in automating the
distribution of any new front ends with Tony Toews's (MVP) AutoFE utililty.
With this utility, the developer places the new front end on the server and the
next time the users open the application, the new front end is saved to their
hard drives and they start using it. Please see the following Web page for more
information on his utility:

http://www.granite.ab.ca/access/autofe.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:W4******************************@adelphia.com ...
Hi, Kip.
>Are you saying make a duplicate table on the workstation and server and link
the tables?

Splitting is easiest with the Database Splitter Wizard. It will allow you to
place the file with the tables (back end) on the networked server. Your
altered file will be the front end, and it contains links to those tables in
the back end. It has the form that the other users can use for updating and
viewing the data in the (now) linked table.

Place a copy of your front end on the networked server and have the other
users copy that front end file to their own workstations. The tables will
remain linked.

Practice on a copy of your current database file until you become comfortable
with the process, then do it on the real thing.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Kip" <ja*******@gmail.comwrote in message
news:mf*************@newsfe04.lga...
>Thanks so much.

Are you saying make a duplicate table on the workstation and server and link
the tables?
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:te******************************@adelphia.com ...
>>Hi, Kip.

For more information about split databases (front end and back end), please
see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:f9******************************@adelphia.com ...
Hi, Kip.

I was wondering if I could put the Access table on a server and put
shortcuts on each work station to allow users to view, update records?

Don't use a shortcut so that everyone is sharing the same database file on
the network. That often leads to database corruption. If it's just a
table (or tables in the back end), it can be viewed and updated in a
multiuser environment as long as each user has another file (front end)
loaded on their workstations, and the front end is linked to the tables in
the back end. Each user will need a copy of Access installed on his
workstation if the front end is an Access database file. However, other
applications can be used as front ends, as long as they are ODBC-compliant.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Kip" <ja*******@gmail.comwrote in message
news:Od****************@newsfe03.lga...
>I have an office with approx 8 people. I have used Access with a Form on my
>personal PC for client records. I was wondering if I could put the Access
>table on a server and put shortcuts on each work station to allow users to
>view, update records?
>
Thanks in advance
>
>




Dec 28 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.