How to have two computers share a datase

[Arima53]

I have two computers in an office and want to share an Access database. This
database is for creating orders, invoicing, etc. and is critical to my work.
I would like two computers to use the same database and have the work done on
either computer reflected in the database. I created a shortcut on the second
computer that targeted the Access application on the main computer. However,
when I click the shortcut, I get the following error message:

“Microsoft Access cannot open this file. This file is located outside your
intranet or on an untrusted site. Microsoft Access will not open this file
due to potential security problems. To open the file, copy it to your machine
or an accessible network location.â€

I looked at Microsoft Knowledge Base Article ID 303650 regarding this
message. In this article it says to add the *.domain.com or an IP address
range to the accepted sites. I know how to get to the place to do this, but
don’t know what the *.domain.com or the IP address range is for either
computer is. How do I find this information?

Also, do I need the domain name and/or IP address range for each computer?

I have a high-speed Internet connection, use Windows XP, and have Microsoft
Office Professional 2002 installed.

 

[Joan Wild]

You would add the name of the computer to the trusted list, as in
\\computername

If you right-click on My Computer, and choose properties, you can find the name. Once you have done that, I suggest that you split the database. Put the Backend in that common location, and give each computer a copy of the frontend (which has table links, connected to the backend).

There is a database splitter wizard you can use to split the mdb, or do it manually.

More on splitting:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
http://granite.ab.ca/access/splitapp/index.htm


--
Joan Wild
Microsoft Access MVP
:I have two computers in an office and want to share an Access database. This
: database is for creating orders, invoicing, etc. and is critical to my work.
: I would like two computers to use the same database and have the work done on
: either computer reflected in the database. I created a shortcut on the second
: computer that targeted the Access application on the main computer. However,
: when I click the shortcut, I get the following error message:
:
: “Microsoft Access cannot open this file. This file is located outside your
: intranet or on an untrusted site. Microsoft Access will not open this file
: due to potential security problems. To open the file, copy it to your machine
: or an accessible network location.â€
:
: I looked at Microsoft Knowledge Base Article ID 303650 regarding this
: message. In this article it says to add the *.domain.com or an IP address
: range to the accepted sites. I know how to get to the place to do this, but
: don’t know what the *.domain.com or the IP address range is for either
: computer is. How do I find this information?
:
: Also, do I need the domain name and/or IP address range for each computer?
:
: I have a high-speed Internet connection, use Windows XP, and have Microsoft
: Office Professional 2002 installed.
:

 

[Arima53]

Thanks. I'll try that. I am familiar with splitting databases and have done
that in the past.

arima