Cannot edit shared access database in 2007?

[dyouden]

We recently started getting some updated computer systems and now have a
mixed environment where some staff have Office 2003, and some staff have
Office 2007.
Certain employees share an Access database on a network share. They used to
be able to edit this database individually through the network access.
Since going to Office 2007, however, one employee cannot edit the database
without first saving a copy to here hard drive, making the changes and then
saving the new copy of the database to the file server again.
How can we get around this on the office 2007 system? The people using
office 2003 can still edit the database on the server as they used to and the
person using Office 2007 wants to be able to do the same.

 

[Marco]

What do you mean with edit?

input and update data? or change the batabase settings, such as table
definitions or forms layout?

because it's not supposed to be allowed to edit the struture the database
when more then one user is using it.


marco

 

[Tom Wickerath]

It sounds to me like you are sharing one unsplit database file. Even though
you may have gotten away with this practice in the past, when everyone was
using the same version of Access, you should know that Microsoft has
identified sharing an entire database as the number one cause of JET database
corruption. So, you really are playing a game of roulette with your data.

When you split a database, two .mdb files are created: A "front-end" (FE)
..mdb and a "back-end" (BE) .mdb file. (The same applies as far as splitting a
..accdb file, using the new privatized JET file format available in Access
2007 only). A copy of the FE (application) file should be installed on each
users local hard drive. The FE contains all queries, forms, reports, macros,
modules, and any local (non-shared) tables. The BE .mdb file is placed in the
shared folder of a file server. This .mdb has tables only for the shared data.

Split the Database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB

and

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[dyouden]

I mean input and update data. They are not trying to change settings ... just
input or update entries.