How do I share an Access Database 2007 (Vista) with other workers?

[Guest]

My company is very small--only 3 people but we do need to share an Access
Database. I read from the comment earlier about split the database into front
end and back end but I can't find it in Access 2007. Please forgive me if
it's a silly question. Thank you for your kind support.

 

[AnandaSim]

My company is very small--only 3 people but we do need to share an Access
Database. I read from the comment earlier about split the database into front
end and back end but I can't find it in Access 2007. Please forgive me if
it's a silly question. Thank you for your kind support.

Access 2007 Ribbon is quite different from Access 2003 classic menus.

Database Tools tab > Move Data chunk > Access Database icon

is the equivalent to the Access 2003 menu

You can get a classic menu vs new ribbon map for Access here:

http://office.microsoft.com/search/redir.aspx?AssetID=AM101757761033&CTT=5&Origin=HA101666061033

HTH
Ananda

 

[Guest]

Thank you so much for your help. I do have more questions and hope you don't
mind to help me out. I'm not sure that I did copy the front end database to
the second pc correctly--I used copy command and then go to network-->his
computer--> paste it in his public folder. Is that right? Do I have to
"Linked Table Manager" his front end database with the back end--(I did it on
my machine)? Thank you again for your help!!! Have a great day!

 

[AnandaSim]

Thank you so much for your help. I do have more questions and hope you don't
mind to help me out. I'm not sure that I did copy the front end database to
the second pc correctly--I used copy command and then go to network-->his
computer--> paste it in his public folder. Is that right? Do I have to
"Linked Table Manager" his front end database with the back end--(I did it on
my machine)? Thank you again for your help!!! Have a great day!

Each front end must know where the common back end is. For people who
have a common server, they put the back end on the server and it
appears like an extra drive - e.g. W: so all front ends can reference
the back end as W:\blah\blah

For people who don't have a server, then the back end is sitting on
one machine and the other machines use the first machine.

Every front end must be able to see the back end - hence to make
things simple, I make all front ends see the back end (using Linked
Table Manager) using the UNC naming convention e.g.

\\firstmachinename\networksharedname\blah.mdb

That way, all my front ends are identical and you simply copy the
front ends to any machine without further adjustment.

 

[Guest]

Thanks again AnandaSim. Your information does help me a lot but I 'm very
stupid with the computer--new with everything. From reading your answer, it
seems like I do have to "Map a network Drive" on my computer first, don't I?
Let's say if I map a network drive with "Z"drive, in the folder it should be
something like this "\\my computer name\Share\my database_be" right? I'm not
sure I understand the whole thing that you gave me and again, please forgive
me if it's a silly question. Thanks a million for your assistance! Have a
wonderful day.

--
Nikki

Each front end must know where the common back end is. For people who
have a common server, they put the back end on the server and it
appears like an extra drive - e.g. W: so all front ends can reference
the back end as W:\blah\blah

For people who don't have a server, then the back end is sitting on
one machine and the other machines use the first machine.

Every front end must be able to see the back end - hence to make
things simple, I make all front ends see the back end (using Linked
Table Manager) using the UNC naming convention e.g.

\\firstmachinename\networksharedname\blah.mdb

That way, all my front ends are identical and you simply copy the
front ends to any machine without further adjustment.

Thanks again AnandaSim. Your information does help me a lot but I 'm very
stupid with the computer--new with everything. From reading your answer, it
seems like I do have to "Map a network Drive" on my computer first, don't I?
Let's say if I map a network drive with "Z"drive, in the folder it should be
something like this "\\my computer name\Share\my database_be" right? I'm not
sure I understand the whole thing that you gave me and again, please forgive
me if it's a silly question. Thanks a million for your assistance! Have a
wonderful day.

 

[AnandaSim]

Thanks again AnandaSim. Your information does help me a lot but I 'm very
stupid with the computer--new with everything. From reading your answer, it
seems like I do have to "Map a network Drive" on my computer first, don't I?
Let's say if I map a network drive with "Z"drive, in the folder it should be
something like this "\\my computer name\Share\my database_be" right? I'm not

There are two ways to refer to a network location. You can map a
network drive like you propose but this is not necessary. In the
Linked Table Manager, you can actually browse directly to \
\mycomputername\share\mydbbe

Keep cool, you're almost there....

Ananda