f



'you do not have exclusive access to the database...'

I recently updated one of my clients from Access 97 front-end to Access 
2003.  (Database still in 97 format).

They have about 5 networked PCs.  On one of these PCs only, the user 
gets a warning message when logging in: 'you do not have exclusive 
access to the database at this time ... may not be able to save 
changes'.   The message keeps on reappearing. If he hits ok about 30 
times, it eventually goes away.

Can someone help?
Thanks.
-- 
Zippy S
0
ZippyN1 (28)
10/22/2007 5:53:52 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
589 Views

Similar Articles

[PageSpeed] 32

On Oct 22, 12:53 pm, Zippy <Zipp...@thedessers.com> wrote:
> I recently updated one of my clients from Access 97 front-end to Access
> 2003.  (Database still in 97 format).
>
> They have about 5 networked PCs.  On one of these PCs only, the user
> gets a warning message when logging in: 'you do not have exclusive
> access to the database at this time ... may not be able to save
> changes'.   The message keeps on reappearing. If he hits ok about 30
> times, it eventually goes away.
>
> Can someone help?
> Thanks.
> --
> Zippy S

1) It could be the way the data is being handled.  With multi-user
systems, it makes more sense to use dbOpenTable or dbOpenDynaset
recordset types only to save a record, and dbOpenSnapshot for
everything else.  This is quite different from the historic method of
opening all tables for read/write when the program is opened and then
closing them when the program exits.
2) It could also be a known bug of the .ldb file in Access 2000/2003.
If I recall correctly, the fix was to keep one table open all the
time, perferably an empty table, so it would not conflict with the
rule stated above.
3) It could be a difference in references between the computers too.
Open a form in design mode, and view the code page.  From there you
can select References from the Tool menu.  Make sure the same items
are selected on all computers.  You may need DAO 3.51 instead of 3.6
to get this to work... I'm not sure whether DAO 3.51 works with Access
2000/2003, but Access 97 databases work well with it.

0
rrosskopf (122)
10/22/2007 9:34:15 PM
In message <1193088855.038935.204860@q3g2000prf.googlegroups.com>, 
OldPro <rrosskopf@sbcglobal.net> writes
>
>1) It could be the way the data is being handled.  With multi-user
>systems, it makes more sense to use dbOpenTable or dbOpenDynaset
>recordset types only to save a record, and dbOpenSnapshot for
>everything else.  This is quite different from the historic method of
>opening all tables for read/write when the program is opened and then
>closing them when the program exits.
>2) It could also be a known bug of the .ldb file in Access 2000/2003.
>If I recall correctly, the fix was to keep one table open all the
>time, perferably an empty table, so it would not conflict with the
>rule stated above.
>3) It could be a difference in references between the computers too.
>Open a form in design mode, and view the code page.  From there you
>can select References from the Tool menu.  Make sure the same items
>are selected on all computers.  You may need DAO 3.51 instead of 3.6
>to get this to work... I'm not sure whether DAO 3.51 works with Access
>2000/2003, but Access 97 databases work well with it.
>
Thanks for your suggestions.  I'm working through them.
-- 
Zippy S
0
ZippyN1 (28)
10/24/2007 7:27:08 AM
Reply:

Similar Artilces:

Using Access to 'access' an sql database on a webserver
Is this possible? I know about a bit about ODBC and found how to import an ODBC database stored on the computer, however I am after accessing an SQL database stored on a webserver. I'd like to keep it up to date, but that could probably be done with a macro. At the moment I'm just considoring possible options, so just need to know if it can be done, how easy and a rough idea of how. Any help would be much appreciated! Flic On 6 Oct 2006 03:59:25 -0700, "Flic" <FelicityP@gmail.com> wrote: I typically create an ADP, then connect to such db specifying the IP address...

How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I am trying to write to a MS Access database. Everything works fine as long as I add data to all records at the same time. The database I am using have two tables (just for testing) with a 'one-to-many' relationship between the two. They both have a PrimaryKey with the data type 'AutoNumber'. From what I understand those numbers should be automatically generated when new data is written to the DB. I can't get that to work with LabVIEW. I am using the function 'DB Tools Insert Data.vi'. According to the manual I should be OK with specifying the column I want to write...

Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I applied the same approach as you guys have described, however my problem starts before I get to autonumber. I have an issue feeding column (data) from "DB tool list column VI" to "DB Tools insert data VI" .So when&nbsp; I connect&nbsp; column output of "DB tool list vi" to column input of "Insert data Vi " I get an error message "exception occurred in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.." However, when I don?t connect column between those two v...

Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW? #2
Hi Alex77, can you please post your vi? so that it will be easier to understand your problem. Any of the field has autogenerated values??? ...

significance of 'not-accessible' MAX-ACCESS
Hi, Can anyone suggest what's the significance of 'not-accessible' MAX- ACCESS on an object. I mean why they can't be accessed? Thanks in advanced. astonishs@yahoo.com wrote: > Hi, > > Can anyone suggest what's the significance of 'not-accessible' MAX- > ACCESS on an object. I mean why they can't be accessed? > > Thanks in advanced. Well, INDEX objects for instance are not accessible, because to retrieve the value of the index you first need the value of the index - so it wouldn't make much sense to have a readable ind...

MS Access 2000 corrupt's databases
Hello. We have about 20 users in our Access databases. Sometime databases corrupts and are not available. I have to correct them. It is not nice, because you have to ask every user to close database, because other wise correcting is not possible. We have 100 Mt Cat 5 ethernet and some of the users use database via Citrix servers. Why databases corrupts and is there anything I can do to this problem? Hannu There are some things that can be done to minimize the problem. First, make sure the have the most current updates and service packs for Office, MDAC, Jet, and your operating systems. Th...

How do I set MS Access NOT to use my profile's 'My Documents'
Hello All, I need to set Access to use my local folder, and not my 'My Docs' folder which is in a netwrok drive. I did the setting thru' options, but when I logged in again, it was pointing to 'My Docs' folder. How do I set this folder permanently? Regards K. Lakshmanan On 4 Mar 2006 01:53:07 -0800, lakshmanan.kk@gmail.com wrote: >Hello All, >I need to set Access to use my local folder, and not my 'My Docs' >folder which is in a netwrok drive. >I did the setting thru' options, but when I logged in again, it was >pointing to 'My Docs' fo...

Opening access database for exclusive access
hi Folks, I am opening my access database file (Access 2003) from a C# application. The connection string specifies mode=Share Exclusive The intent is that the application have exclusive access to the database file. No other instance of MS Access or this particular C# application (or any other app) should be able to open the access database file concurrently. however it seems that this is not happening. A second instance of my program run from another computer under another LAN user id can successfully open a connection to the database using the same connection string, specifying Share E...

Copying from an 'exclusive' Database ??
Hi folks, I need to make a copy of a database (and its associated .cdx file) while that same database is opened in 'exclusive' mode. Clipper Tools won't let me do it (with its filecopy function), and the Clipper command: Copy File xxxx TO yyyy also won't let me. Any hints please ??? (of course, I could go thru the agony of completely closing the database after saving record number, etc, etc, but is there anytrhing simpler than that ??) TIA, -Mel Smith In article <3g9jb5Fb3s7oU1@individual.net> "Mel Smith" writes: > Hi folks,...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...

'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Sin...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check here to see if there is a better way. Any suggestions? Thanks Do you mean remotely controlling an Access database, or linking tables over the internet? The first is doable, the second is a recipe for disaster. Remote Control: If your remote OS is Windows XP, you can use Remote Desktop (although only 1 person can access the PC at a time; this will change in the upcoming Service Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers similar services, as does Terminal Server (a component of a Windows Server machine), PCAnywhere, et al. Linking to remote tables: You will almost certainly encounter severe problems with corruption, and your performance will almost certainly be so poor as to be unworkable. I attempted this once, with a web server in Canada and my machine in Augusta, GA. Even tiny data requests on a very well optimized data structure took waaaay too long to process ... it's simply not workable, IMO. Other alternatives would be covert the app to a web-based and place your data on a web server. Access/Jet isn't really designed for those workloads, but running a small site with minimal transactions and users can be done. Otherwsie, consider switching to a more robust data platform like MySQL, SQL Server, etc. -- Scott McDaniel CS Computer Software Visual Bas...

'Access denied for user 'root'
I've just installed mysql5 under Solaris 10. I installed it as root. Every thins seemed to go well, and then I attempted to execute: /opt/csw/mysql5/bin/mysqladmin -u root password 'mysqls1rgu3' and I receive the error: /opt/csw/mysql5/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I've verified: # ps -ef|grep mysql root 261 1 0 16:11:39 ? 0:00 /bin/sh /opt/csw/ mysql5/bin/mysqld_safe --pid-file=/opt/csw/mysql5/var/mysql.pi mysql 421 ...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

accessing MS Access database fila via ODBC problem
Hi! I'm trying to connect to a MDB file via ODBC like this: char *DSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\dev-cpp\\test\\1.mdb"; SQLAllocEnv(&env); SQLAllocConnect(env, &hdbc); SQLBrowseConnect(hdbc, (UCHAR*)DSN, strlen(DSN), (UCHAR*)buf, BUF_SIZE, (SQLSMALLINT*)&rcvlen); The function SQLBrowseConnect fails and SQLGetDiagRec returns "IM001 Driver does not support this function" Can anyone help me? Thanks! David On S...

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

Python database 'frontends', what's available?
I'm desperately trying to move a Microsoft Access database application (a simple accounts system I wrote myself) to Linux. Python is one of my preferred programming laguages so I wonder if there are any good Python 'frameworks' for writing database applications, in particular I need good reporting and forms writing facilities. The basic database and logic/arithmetic seem fairly simple to me. -- Chris Green On May 23, 1:59=A0pm, tinn...@isbd.co.uk wrote: > I'm desperately trying to move a Microsoft Access database application > (a simple accounts system I wrote myself...

'Undefined function Dlookup' error with Sagekey 'Access 2002 Msi Wizard'
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great product) to install my applications. When the Access Runtime was needed on the system I simply ran 'accessrt.msi' from Microsoft Office Developer discs. When another version of Access (other than Access 2002) was on the system then I simply edited the shortcut so that my application will open with Access Runtime 2002. Everything worked great for about six years. In the last couple of years most of my customers (those already existing and the new ones) have migrated to Microsoft Access 2003 and recently to Microsoft Access 2007. To avoid possible problems I decided to use 'Access 2002 Msi' from Sagekey. The main reason was that 'Access 2002 Msi Wizard' from Sagekey was supposed to generate completely independent installs for my Access aplications so I will not have to worry if my clients install and uninstall different versions of Access on their systems. I use from January 2008 'Access 2002 Msi Wizard' from Sagekey. Since I begun using 'Access 2002 Msi Wizard' to create my install packages on some computers (1 in 10) a unexpected error happened ( 'Error 3085 Undefined function 'Dlookup'...). Most of these errors are thrown on computers where full Microsoft Access 2003 or Microsoft Access 2007 is already installed. When I start my ap...