Hello.

I have a client with several machines on a LAN (their office) all running
Windows XP Pro SP2. Most of the machines are running Access 2003, however
one machine is running Access 2007.

The machine that is running Access 2007 can never access the network-stored
database if anyone else is already in it. However, if the Access 2007
machine is logged into the database first, everyone else can log in without
issue.

Hope someone in here can suggest something to aid in this problem.

Thanks!
Shoregeek

Split the db into front end and back end. Put the back end (tables and
relationships) on the network. Give all users read, write, and modify
permissions (and delete if you're a risk taker) on the folder where the back
end is. Put a copy of the front end (all other parts of the db) on each
user's desktop. Everyone can share it that way.

Chris
Microsoft MVP

Ah, OK. I haven't worked in Access for a long time, so I'll have to tinker
with that a little bit.

Thank you very much!

"Chris O'C via AccessMonster.com" wrote:

Question. Within the database that everyone in this office is trying to
access, usually at the same time, they are all typically accessing the same
table.

Will this splitting of the database still let everyone access the specific
table? Or do we need to do something fancy? :)

Thanks!

"Chris O'C via AccessMonster.com" wrote:

Access is not strong enough to support multiple locks on the same
table.

SQL Server supports real locking.

Access does not.

SQL Server is free.. you should have upsized a long long long time
ago.

On Jul 26, 5:46 am, Shoregeek discussions.microsoft.com>
wrote:

If databases were my specialty, then perhaps I would have moved to SQL the
first time I met this client. Given that I am not a database person, I
don't think I should be beaten down for a client not having moved to a
platform I am sure they know nothing about.

Thanks for the information anyway.

"a a r o n . k e m p f @ g m a i l . c o" wrote:

you're not any sort of person whatsoever.. if you don't do SQL Server

Access isn't reliable enough for a single record nor a single user.

On Jul 27, 3:50 am, Shoregeek discussions.microsoft.com>
wrote:

Shoregeek discussions.microsoft.com> wrote:

Yes, that will work quite well.

Please ignore Aaron Kempf's postings as he is rather monomaniacal.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

splitting isn't reliable.

sorry. upsize to SQL Server if you give a shit about your data
if you don't give a shit about your data-- keep it in excel

On Aug 4, 7:12 pm, "Tony Toews [MVP]" telusplanet.net> wrote: