473,320 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can't share Back End - Opened Exclusively by...

110 100+
All,

I have an application (developed in Access 2007) that I am just finishing. It developed as with the database split into front and back ends on a single machine with a single user. This works great - one user, same machine. I've turned on encryption for the backend (i.e. the back end has a password)

As I'm preparing to deploy I've installed the front end on another computer and linked to the back end.

This also works (painfully slow however - even with a gigabit switch - but this probably another post) when there is a single user logged in.

When there are 2+ users logged in (different front ends, same back end) I am getting an odd exclusive open error. It seems like the system is locking the table. If someone has the customer's table open and I try to open a customer record, I get the error. If they close there customer record so there is nothing open, then I can open the record just fine.

Also - this may help with troubleshooting - it appears that the .ldb file will appear when a user opens a record and disappear when the record is closed.

All record locks appear to be set correct (pic attached).

As always, any assistance is greatly appreciated.

Gunner

Attached Images
File Type: png Capture.PNG (14.4 KB, 544 views)
Nov 29 '13 #1
5 1793
dgunner71
110 100+
To clarify - the .ldb file that is appearing/disappearing is for the back end. The front end .ldb files are constant.

Thanks again.

Gunner
Nov 29 '13 #2
zmbd
5,501 Expert Mod 4TB
First, sounds like you used an older mdb (acc2003) version as the lock file should be "*.laccdb" if you are using any older datatables this may cause you issues.

Second, we'll need to see how the recordset was created.
Is the form bound to the tables.

and yes the encryption can slow things down... the use of the older ACC2003 file format may be complictaing things here too.

The recordlevel locking should handle this... there may be something in the table relationships too so that if the form opens in such away as to allow potential for editing cross tables things can get locked.

Just a few different variables.
Nov 29 '13 #3
dgunner71
110 100+
zmbd -

Sorry for misspeaking before - the locking files are indeed .laccdb files. (I'm so used to 2003)

As a general rule of thumb, the forms I'm using are bound to tables. I have some that are bound to queries but most are direct to the table. The Customer form that was presenting a problem earlier is bound directly to the [tblCustomers]. Do you recommend that they be bound to queries instead?

Also, to clarify your input regarding RecordLevel Locking, this should be set as shown, correct (Open db using record level locking)?

On an interesting note, when I was having the trouble today (my first trial run), the database was showing "No Record Locks" in the advanced properties. However, I made a copy of the database and it seems like it now opens itself with "Edited Record" checked. (I did not change it, but sure enough, that's how it opens). In any event, this seems to have corrected the problem.

I believe there is some minute downside to using this ("Edited Record"). I know that I had it set in an earlier database (2003) but turned it off to alleviate some problem. I just can't remember what that problem was. Can you offer any advice on this?

Thanks again.

Gunner
Nov 29 '13 #4
zmbd
5,501 Expert Mod 4TB
Hmmm,
There is a performance hit for the lock edited record. With the weirdness of having it checked marked when you re-opened the file makes me wonder, once again, are you using tables and objects within an older database file?

As for table v. query:
I've usually used queries for my forms, it was the way I was shown by the SQL/Oracle programmers (they use views, same thing I believe) even if the query is a simple select that mimics the table. Only in my DBA front-ends do I ever have any form directly linked to a table and that is because I want that table locked. Ofcourse, the DBA front-end will not open the back-ends in exculsive unless everyone has closed their frontends (^-^)

Now, IF and ONLY IF I understand this correctly: By basing the form on the query, the form loads, queries, and is done with the table unless changes need to be made either thru edit or new record addition. The record is lockedupon write for an edit and submit for the new record. This is why often forms, or subforms, and controls must be re-freshed or re-queiried in order to get new information added either by the Local user or the other network users.

(I hope I have that right as I've been using that paradiem for many many many many years).
Nov 30 '13 #5
dgunner71
110 100+
zmbd,

I checked and both the front and back ends are indeed MS Access 2007 files.

Also, thanks for the great info on tables v. queries - this makes perfect sense and will likely help to prevent (or alleviate) the issue - I'll get these all changed over.

I'll close this question for now - I'll see if I still have issues when I implement the new program.

My plan is to deploy this database next week with all users logging into the server of RDP with both the front and back ends on the same machine. I hope this will minimize the performance issues I was seeing when running the program with the back end on different computer than the front end. For the record, however - this should be doable, correct? (I've only deployed with all users on the server)

Thanks again,

gunner
Nov 30 '13 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Sam Kong | last post by:
Hello! We are developing and selling an application which uses Access DB over network. It works fine. However, we encountered a strange case. Computer A(DB Server): Windows 98, Access 97...
0
by: Bob Darlington | last post by:
I have a split db (XP) working on TS to Win2000 Server with 10 users. Each user has separate FE which is opened using command line in TS logon with /excl switch. The Administrator opens to her own...
1
by: Shannon Rotz | last post by:
I have a database split into front-end, back-end, on a machine running Windows XP professional (no network, just a single machine). I just upgraded the database from Access 97 to Access 2000. The...
2
by: caradhras | last post by:
I've been troubleshooting for a friend's charity. She wants their database accessible from both their PCs (I'll call them A & B), which are on a local network, both running A2K on Windows 98. I...
7
by: Lian | last post by:
Hi every body I have a problem with accesses and visual studio. I've just installed XP and I can't get a connection with the Data base. I have this error and I don't know how to fix it The...
0
by: Tom Wild | last post by:
Hi I am trying to connect to an Access database from a WebPage in VB.Net but when I try to open the connection I get the following error: The Microsoft Jet database engine cannot open the file...
1
by: Tom Wild | last post by:
Hi I am trying to create a webform that connects to an Access database. If I use the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb" Then the application...
1
by: bmoos1 | last post by:
I'm trying to share my Access Database with a co-worker, however, they won't be able to delete. Anyway, the database has been put on a shared server where the co-worker can see it, but can't open...
1
by: cefrancke | last post by:
I have a Back End database (split) that is on a smokin' hot machine (dual processor, 2 gig RAM, XP Pro SP2) and I'm getting an error that says the database (back end file) is "opened exclusively"...
5
stonward
by: stonward | last post by:
Hi Folks, This one is from work! Running Access 07, usually our default saving format is 2003 - not our fault. I want to publish a database to our SharePoint system, but the database must be...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.