Windows10 for connected computers.

Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter

You might want to consider storing the db on an SQL server and accessing
the db through the server.
That way you can have multiple accesses to the db at the same time.
Look up MS SQL Server. It's not difficult but may take someone with SQL
knowledge to set it up. We use it.

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter

https://answers.microsoft.com/en-us/...a-f6bac91fa22f

"...You will also need to split the database into two:

a shared "Backend", containing only the Tables; and

multiple copies of a "Frontend", linked to the shared backend,
containing the Forms, Reports, Queries and code. These can be
set up so that the only thing the user sees is the forms that
you choose to let them see
"

Don't ask me how the licensing works while you're doing this :-/

So one Front End and the Back End will be running on one computer,
and the second Front End will be on the second computer. When
a user is using the second Front End, the other computer will
also need to be booted and running the Back End. The Back End
computer is your "server" in a sense.

If you put the dedicated "Backend" on an actual machine intended
for serving, then the two "user" machines can have various
Front End functions. And then only the Server box need be
left running.

*******

There are newsgroups for access, but they don't look
very busy at the moment. This is about the busiest of the lot.
I guess that means using the Answers forum on the Microsoft site
or something, if you have questions.

microsoft.public.access.queries

Paul

On Sat, 09 Mar 2019 03:19:26 -0500, Paul
wrote:

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter

https://answers.microsoft.com/en-us/...a-f6bac91fa22f

"...You will also need to split the database into two:

a shared "Backend", containing only the Tables; and

multiple copies of a "Frontend", linked to the shared backend,
containing the Forms, Reports, Queries and code. These can be
set up so that the only thing the user sees is the forms that
you choose to let them see
"

Don't ask me how the licensing works while you're doing this :-/

So one Front End and the Back End will be running on one computer,
and the second Front End will be on the second computer. When
a user is using the second Front End, the other computer will
also need to be booted and running the Back End. The Back End
computer is your "server" in a sense.

If you put the dedicated "Backend" on an actual machine intended
for serving, then the two "user" machines can have various
Front End functions. And then only the Server box need be
left running.

*******

There are newsgroups for access, but they don't look
very busy at the moment. This is about the busiest of the lot.
I guess that means using the Answers forum on the Microsoft site
or something, if you have questions.

microsoft.public.access.queries

Paul

I have found only 20 entries in that NG.
But might I just install a new instance of
Access10 on the remote computer and sync both at
the end of the day? Although I got my business
software up & running on Access97, I had to use
wizards & cut/paste for the VBA thing.

Peter Jason wrote:
On Sat, 09 Mar 2019 03:19:26 -0500, Paul
wrote:

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter
https://answers.microsoft.com/en-us/...a-f6bac91fa22f

"...You will also need to split the database into two:

a shared "Backend", containing only the Tables; and

multiple copies of a "Frontend", linked to the shared backend,
containing the Forms, Reports, Queries and code. These can be
set up so that the only thing the user sees is the forms that
you choose to let them see
"

Don't ask me how the licensing works while you're doing this :-/

So one Front End and the Back End will be running on one computer,
and the second Front End will be on the second computer. When
a user is using the second Front End, the other computer will
also need to be booted and running the Back End. The Back End
computer is your "server" in a sense.

If you put the dedicated "Backend" on an actual machine intended
for serving, then the two "user" machines can have various
Front End functions. And then only the Server box need be
left running.

*******

There are newsgroups for access, but they don't look
very busy at the moment. This is about the busiest of the lot.
I guess that means using the Answers forum on the Microsoft site
or something, if you have questions.

microsoft.public.access.queries

Paul

I have found only 20 entries in that NG.
But might I just install a new instance of
Access10 on the remote computer and sync both at
the end of the day? Although I got my business
software up & running on Access97, I had to use
wizards & cut/paste for the VBA thing.

I don't really know anything about Access,
what Front End and Back End options it's got.

It sounds like the other Paul, has more experience.

Paul

On 08/03/2019 23:31, Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter
Export your Access Database to Microsoft SQL Server Community Edition
(2017) and problem solved. Access is not designed to run on multi user
environment but SQL server is.

You are expert in designing the UI to make life easy, right? The UI can
be in Visual Studio C# program or you could just create web interface.
Either way you should know both ways!!

https://www.microsoft.com/en-gb/sql-server/sql-server-editions-express



--
With over 950 million devices now running Windows 10, customer
satisfaction is higher than any previous version of windows.

In article , lid says...

Peter Jason wrote:
On Sat, 09 Mar 2019 03:19:26 -0500, Paul
wrote:

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter
https://answers.microsoft.com/en-us/...a-f6bac91fa22f

"...You will also need to split the database into two:

a shared "Backend", containing only the Tables; and

multiple copies of a "Frontend", linked to the shared backend,
containing the Forms, Reports, Queries and code. These can be
set up so that the only thing the user sees is the forms that
you choose to let them see
"

Don't ask me how the licensing works while you're doing this :-/

So one Front End and the Back End will be running on one computer,
and the second Front End will be on the second computer. When
a user is using the second Front End, the other computer will
also need to be booted and running the Back End. The Back End
computer is your "server" in a sense.

If you put the dedicated "Backend" on an actual machine intended
for serving, then the two "user" machines can have various
Front End functions. And then only the Server box need be
left running.

*******

There are newsgroups for access, but they don't look
very busy at the moment. This is about the busiest of the lot.
I guess that means using the Answers forum on the Microsoft site
or something, if you have questions.

microsoft.public.access.queries

Paul

I'm unsure if this is pertinent but it sounds like you want to access
and edit the same database from two different pcs at the same time. You
require software specifically written for a network environment to do
that and not currupt the data.

Usually the 2nd pc will not be able to access the data as the first pc
has the file "locked: for esxclusive access. Sometimes you can read the
file but not write to it "limited access". And likely if it even does
allow dual access for some reason the data is almost surely going to be
wrong except for the last write to the databse with info from other
system lost. Huge database and you may avoid collisions for sometime
but sooner or later ...

pjp wrote:
In article , lid says...
Peter Jason wrote:
On Sat, 09 Mar 2019 03:19:26 -0500, Paul
wrote:

Peter Jason wrote:
Having a second computer connected to the office
computer, I need to be able to vary data into
Access10 from either at the same time.
I am running Windows10 pro.

I can do this now, but if there are two users what
sort of software do I need to do the above without
refreshing either machine before adding data?
Peter
https://answers.microsoft.com/en-us/...a-f6bac91fa22f

"...You will also need to split the database into two:

a shared "Backend", containing only the Tables; and

multiple copies of a "Frontend", linked to the shared backend,
containing the Forms, Reports, Queries and code. These can be
set up so that the only thing the user sees is the forms that
you choose to let them see
"

Don't ask me how the licensing works while you're doing this :-/

So one Front End and the Back End will be running on one computer,
and the second Front End will be on the second computer. When
a user is using the second Front End, the other computer will
also need to be booted and running the Back End. The Back End
computer is your "server" in a sense.

If you put the dedicated "Backend" on an actual machine intended
for serving, then the two "user" machines can have various
Front End functions. And then only the Server box need be
left running.

*******

There are newsgroups for access, but they don't look
very busy at the moment. This is about the busiest of the lot.
I guess that means using the Answers forum on the Microsoft site
or something, if you have questions.

microsoft.public.access.queries

Paul

I'm unsure if this is pertinent but it sounds like you want to access
and edit the same database from two different pcs at the same time. You
require software specifically written for a network environment to do
that and not currupt the data.

Usually the 2nd pc will not be able to access the data as the first pc
has the file "locked: for esxclusive access. Sometimes you can read the
file but not write to it "limited access". And likely if it even does
allow dual access for some reason the data is almost surely going to be
wrong except for the last write to the databse with info from other
system lost. Huge database and you may avoid collisions for sometime
but sooner or later ...

Databases are better than that.

Paul

On 10/03/2019 00.39, Peter Jason wrote:


I have found only 20 entries in that NG.
But might I just install a new instance of
Access10 on the remote computer and sync both at
the end of the day? Although I got my business
software up & running on Access97, I had to use
wizards & cut/paste for the VBA thing.

No. A database solution needs the server running and updated instantly
by all clients.

--
Cheers,
Carlos E.R.