January 26, 2004 at 3:12 pm
When I try to open an ADP form when another user has the same ADP form open I get Access error message that says .... file will be opened up read only..... the file is locked for editing by another user....................
Is this normal (ie If someone has ADP open no one else can add or edit records?)
or do I need to set a property somewhere?
or is this a SQL issue.
Thanks for your help
January 27, 2004 at 7:03 am
Don't know if this also applies to ADP, but in 'normal' Access DBs' there is a db setting, you'll find in Extras ?!? ->Options on a tab, I guess it's called something like 'More' or 'Other' the default opening mode. I guess it is set to exclusive , not shared.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 27, 2004 at 4:20 pm
Yeah, this is normal for an access data project. The ADP simply acts as a front-end for a database in SQL Server. What you need to do, is distribute copies down to the user workstations and have them run their own copy of the ADP file.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply