Access Database Networking - Newbie

[Guest]

Have a small network of 4 users. I have put the database in a shared folder.
The form/query is on each users machine. For some reason the database
utilities is greyed out. So I am not able to link the BE(table/data) to the
FE(form/query).

Any suggestions would be appreciated. Access 2000 on Winxppro
Thanks,

 

[Guest]

You can delete the links to the tables on the tables tab and then relink
through File - Get External Data.

Hope this helps.

 

[Joseph Meehan]

Have a small network of 4 users. I have put the database in a shared
folder. The form/query is on each users machine. For some reason the
database utilities is greyed out. So I am not able to link the
BE(table/data) to the FE(form/query).

Any suggestions would be appreciated. Access 2000 on Winxppro
Thanks,

Also make sure all the users have full (read write, create & delete)
rights to the folder where the BE is located.

 

[Guest]

Thank you Jackie, but my table is listed as a datasheet and everywhere I go
to try to make a change the option is greyed out. I am getting a little
desparate now.

 

[Guest]

Make sure the firewall is turned off on all of the computers. You should
have a firewall through your network router/switch that connects all of you
to the internet, so you don't need a software firewall. The Microsoft
firewall can also prevent you from sharing printers.

 

[Guest]

Thank you and everywhere I have looked they have full rights. I think the
main problem is the link because once they use the form to access the table
if any editing is done it is only saved on the individual system not on the
network.

Really need to know how to correct this issue. Thanks for your suggestion.

 

[Tony Toews]

Make sure the firewall is turned off on all of the computers.

No, no, no. You can open the Windows Networking port which is port
135. Never, ever turn off the firewall.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Thank you I didn't turn off the firewall, it is not blocking the computers
from sharing files/printers. The issue is with the database and how why the
editing is not being saved to the shared folder. The edited info is just on
the system where is was imput not on the network.

That is not good because we will end up with 4 different databases. Please
help!!!

 

[Tony Toews]

Thank you I didn't turn off the firewall, it is not blocking the computers
from sharing files/printers. The issue is with the database and how why the
editing is not being saved to the shared folder. The edited info is just on
the system where is was imput not on the network.

That is not good because we will end up with 4 different databases. Please
help!!!

This sounds like

1) The MDBs on the workstations aren't split into a front end MDB
containing the queries, forms, reports and codes and a backend MDB
containing the tables and relationships. However your original
posting states "The form/query is on each users machine" so that isn't
the problem.

2) The FE MDBs are linked to a backend MDB which is residing somewhere
else either on each local system or on the server. You can go into
the Linked Table Manager to review the paths to the tables.

In A2000 - A2003 this is under Tools >> Database Utilities. In A97
this is under Tools >> Add-Ins

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Thank you Tony for your response, I think that is what must be the problem
however when we go to the database utilities the options are greyed out.
Did this happen because of conversion from A97 to A2000? Or password
protection?

Anxiously awaiting your response
Thanks again
Pauline

 

[Tony Toews]

Thank you Tony for your response, I think that is what must be the problem
however when we go to the database utilities the options are greyed out.
Did this happen because of conversion from A97 to A2000? Or password
protection?

Right click on one of the tables in the database window and view the
properties. Does it say Table or Table: Linked Access? If Table
then the app hasn't been split into a Front End/Back End set of MDBs.

If Table: LInked Access then it is linked.

However what really puzzles me is that the options are greyed out in
the database utilities. There should be quite a number of which one
is Linked Table Manager.

I'm wondering if something is set improperly in Options or Startup but
I'm not at all sure which. If you go into Tools >> Startup are all
the check boxes checked?

What version of Access are you running? You indicate A2000.

Hmm, there are two kinds of greying. One where the background is a
different shade of grey and one where the font is grey. If it's the
background then that means you haven't used that option before. If
it's the font then that option is unavailable for some unknown reason.

Can you click on Linked Table Manager option anyhow?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm