Warning message Access 2007

[Abay]

Hello ... I have a new job and all of the procedures are performed through
Access 2007 Databases. Each pc has access installed locally and the files
are in shared folders on a server. The problem I am finding is that we keep
getting a conflict message when more than one person wants to update a data
base .. doesn't matter what table(s) are being accessed.

My guess (uneducated) is that Access is not installed properly for the
ability to share data without conflicts. I have been reading up on sharing
an Access database on Microsoft's site. I seems that the best way to share
would be to have a database server installed.

To share data do we need to lock/unlock records or tables in our vba code?

We are a small organization with about 40 people using Access. Any help/
information on this situation would be most appreciated.

Abay

 

[Steve Schapel]

Abay,

First questions... Are these Access databases split into a frontend
(application objects such as forms, queries and reports), and a backend
(tables)? And do you have a separate copy of the frontend for each user?

--
Steve Schapel, Microsoft Access MVP

Hello ... I have a new job and all of the procedures are performed through
Access 2007 Databases. Each pc has access installed locally and the files
are in shared folders on a server. The problem I am finding is that we
keep getting a conflict message when more than one person wants to update
a data base .. doesn't matter what table(s) are being accessed.

My guess (uneducated) is that Access is not installed properly for the
ability to share data without conflicts. I have been reading up on
sharing an Access database on Microsoft's site. I seems that the best way
to share would be to have a database server installed.

To share data do we need to lock/unlock records or tables in our vba code?

We are a small organization with about 40 people using Access. Any help/
information on this situation would be most appreciated.

__________ Information from ESET Smart Security, version of virus signature database 4186 (20090624) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Abay]

Thank you Steve for your reply, and no the data base is not split between
data and application objects, each user just has Access installed locally
and gets all the data from a shared drive.

Abay

 

[Steve Schapel]

Abay,

That is the recommended arrangement for a multi-user environment such as
yours. I think it will solve your problem if you do it like that. Split
the database into frontend and backend. Put the backend on the server. Put
a copy of the frontend on each user's local machine, and link to the backend
tables.

--
Steve Schapel, Microsoft Access MVP

Thank you Steve for your reply, and no the data base is not split between
data and application objects, each user just has Access installed locally
and gets all the data from a shared drive.

__________ Information from ESET Smart Security, version of virus signature database 4186 (20090624) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Abay]

Many thanks for your recommendation, I really appreciate your help ... I
will put that suggestion forward at the office and hopefully it will be
adopted ...

Abay

 

[Steve Schapel]

Abay,

Since you apparently have to get approval for this change, I should also say
that the configuration I mentioned is very easy to implement. You will have
to institute a system for distributing version updates for your
applications, as no doubt there are design changes being made from time to
time.

But really, bottom line here is that we would really have to expect
continued problems with your existing arrangement.

--
Steve Schapel, Microsoft Access MVP

Many thanks for your recommendation, I really appreciate your help ... I
will put that suggestion forward at the office and hopefully it will be
adopted ...

__________ Information from ESET Smart Security, version of virus signature database 4186 (20090624) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Abay]

I agree with you, and have worked before in an environment where the data is
split out. The current situation really irritates one of the Company's
Partners, so I don't think there will be much opposition. As I am new, I
don't want to be dogmatic about this, but hope in the future that I will be
able to implement my suggestions without too much opposition ... slowly but
surely wins the race

You are right about the version updates, I will be changing a number of the
data bases over the next few months .. I am trying to learn VBA and update
my knowledge as fast as I can.

Many thanks again

Abay

 

[Tony Toews [MVP]]

I agree with you, and have worked before in an environment where the data is
split out. The current situation really irritates one of the Company's
Partners, so I don't think there will be much opposition. As I am new, I
don't want to be dogmatic about this, but hope in the future that I will be
able to implement my suggestions without too much opposition ... slowly but
surely wins the race

You are right about the version updates, I will be changing a number of the
data bases over the next few months .. I am trying to learn VBA and update
my knowledge as fast as I can.

See the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make the process of
distributing updates relatively painless.. The utility also supports
Terminal Server/Citrix quite nicely.

Tony

 

[Abay]

Thanks Tony .. I will check it out ...

Ebay

See the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make the process of
distributing updates relatively painless.. The utility also supports
Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/