Shared Access To A Database Problem

Jet Database Engine Error On Non-shared Database

Jul 7, 2005

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

View 3 Replies View Related

Shared Database

Nov 2, 2007

Hello,

Im having some problems sharing a database. I need multiple users to be able to open the database at the same time. I have check TOOLS - OPTIONS - ADVANCED and my option is set to shared, but for some reason it will still only allow 1 user to open it at a time.
Does anyone know why this could be?

Thanks

View 2 Replies View Related

Shared Database Problems

Dec 19, 2006

hello everyone... with the help i have gotten from this site I embarked upon producing a online booking databse for my workplace ...

since the work enjoys having an intranet i simply placed the database in a shared folder and things have worked great for nearly a year ...

Ive tinkered and modified and everyone is happy till today ....

while an administrator was deleting a booking things went haywire ....

a message came up about couldnt delete because someone else was deleting ...things froze and a message about path problems came on the screen..

the only thing we could do was delete the database and replace it with the backup copy we have.... everything worked great for an hour or so and then things went wonky again with same error messages...

also I noticed that the database grew in size from 1.6md to 2.5 mb ....

again I replaced it with the backup copy and did a repair and compress ..and it seems to be ok ..

but im dreading tommorrw since i anticpate it happening again ..any suggestions appreciated... ps ..the databse is a booking form for booking ict suites in a school and I am the schools technician

cheers

harry

View 14 Replies View Related

Securing A Shared Database

Jul 17, 2007

Have created a database that will be placed on a shared drive, giving access to others to add, delete, modify records. That aspect of it is fine -- but how to I prevent someone from deleting a field?

View 2 Replies View Related

General :: Security For Database On Shared Drive

Oct 3, 2013

I need securing an Access database. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).

I found this post [URL] .... about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.

View 6 Replies View Related

Forms :: Split Database In A Shared Folder

Nov 9, 2014

I have recently been experimenting with adding an Access database to a shared folder (in a network HomeGroup) and have it working on two networked PCs. Then tried the same with the database split but I get a path error on the PC joined to the HomeGroup (where the database resides) whenever the backend (tables) are accessed by a form or from the Tables listing. If I however open the backend file directly from the file directory, the tables all open as expected.

The path stated as being invalid in the error message starts with "C:Usersetc..... instead of LAF-PCUsersetc..... so it looks (to me at least) that it is attempting to load the file from the local hard drive rather than the host computer.

Why a split database works differently in this situation than a non-split.

View 13 Replies View Related

Using User-level Security On A Shared Database?

Jan 9, 2012

I am going to put my access database on a network drive so that four different computers can have access it. However will user-level security work if I implement it? For example, from one of the computers I implement 2 different usernames and passwords. If one of the other computers tries to access the database will they also be presented with the logon screen?

If not, how can I go about setting this up?

View 6 Replies View Related

Cells Not Appearing On A Shared Drie Split Database

Aug 22, 2005

I have made this database for a company that I work at, and I seem to be haveing some problems. I split the Database and placed the "'back-end" on the company's shared drive, however it seems that only when I log in as myself, on any computer, that it works. On other people's profiles, when a form is opened, there is nothing there, it is blank, no textboxes, labels or anything. However, if you use the database window to open one of the linked tables, you can see all of the existing data and cells just fine. I am only 17, and I have used Access for only two weeks, so I may have missed some setting in the splitting, or a database property that is affecting it. Please help me, as I need to finish this DB ASAP.

PS: the folder settings for the shared drive (at least as far as i know...) allow full access, so there should not be an issue there.

Thank you

View 2 Replies View Related

Accommodation Database - Availability With Shared Room Capacity

Feb 6, 2007

Hi,
I have been reading throguh various articles and learning a lot from you guys, so thank you very much. This place is a fantastic source of information, by far the best of anything i have found online.

I have a question which i would be grateful if someone could advise upon.

Access 2003. I have 4 tables:

list_accommodation (holding host family address details who offer accommodation to students)
id (autonum)
name (text)
address (text)
etc.....

list_rooms (table of rooms offered by host families)
room_id (autonum)
host_id (number) - joined to list_accommodation.id
room_name (text)
capacity (number)

students (student contact details who want accommodation!)
id (autonumber)
name (text)
dateofbirth (date)
address (text_
etc.....

bookings_accommodation (to hold the accomm bookings)
booking_id (autonum)
room_id (num) - joined to list_rooms.room_id
student_id (num) - joined to students.id
start_date (date)
end_date (date)

This structure therefore enables me to query if rooms are booked between dates:

SELECT bookings_accommodation.room_id, bookings_accommodation.start_date, bookings_accommodation.end_date
FROM list_rooms INNER JOIN bookings_accommodation ON list_rooms.room_id = bookings_accommodation.room_id
WHERE (((bookings_accommodation.start_date) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d",-1,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR ((([end_date]-1) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d","0",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR (((bookings_accommodation.start_date)<DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date])) AND (([end_date]-1)>DateAdd("d","-1",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date])));

and therefore, using the 'booked' query i can therefore find out rooms are available.

SELECT list_rooms.room_id, list_rooms.room_name, list_rooms.capacity, list_rooms.description, list_rooms.host_id
FROM list_rooms LEFT JOIN qry_rooms_reserved ON list_rooms.room_id = qry_rooms_reserved.room_id
WHERE (((qry_rooms_reserved.room_id) Is Null));

----

so, now i have found out that there is a necessity to enable students to share a room (the bookings for a room may not happen at the same time). This means that i have to determine the capacity of a room and therefore if
the capacity is not full, then show as available.

I was wondering what the best approach to this may be?
I have added 'capacity' to list_rooms, but i am unsure as to how to go from there....

Any thoughts and advice woudl be really appreciated.

Many thanks

Phil.

View 2 Replies View Related

General :: Database Opens As Read Only When Opened From Shared Location

Jul 15, 2012

We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.

View 6 Replies View Related

Access File Shared

Nov 9, 2005

Can an Access being shared and by multiple users concurrently?

View 1 Replies View Related

Shared MDE Gives Exclusive Access Warning

Jul 3, 2007

We have shared MDE, when second user opens gets message: [B]You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
The message seems to repeat for each compiled object (Form, Report and Module).
Helptext states occurs when in design mode - but not in design mode!
Any ideas as to how we can suppress the warning?

View 6 Replies View Related

Shared Access To DB - Anyway To Refresh Automatically?

Apr 28, 2005

I'm trying to get one database to be shared by multiple users so that the file on the server is always updated as others add new records....in real time. Is there a way for this to work? What settings will I need?

View 2 Replies View Related

Users Cannot Access Data Entered By Others In A Shared BE!!!

Nov 27, 2007

Hi folks,

I've a BE/FE database where the BE is on the server and the FE on different PCs. I have got linked tables in my FE and the connection between them and the BE is correct; however, users cannot view data entered by others. They can only view data entered by themselves!!

I'm not sure if the records are getting locked that's why they can't see others inputs.

Any help will be very much appreciated,
B

View 5 Replies View Related

Access 2003 Backend On Shared Network Drive.

Feb 8, 2006

Hi all...

I have an ACCESS 2003 application with front end in the local machine and backend on the shared network drive. I mapped this drive to E: in my computer and all my linked tables show the E:folernameDatabasename.mdb as the source.

When I install this application in an other computer where they have mapped the same drive to F: , I am getting error that says "E:foldernameDatabasename.mdb" not found. How can use absolute network drive(like \cscrd eamfoldernamedatabasename.mdb) name to link the tables?

Thanks in advance.

View 6 Replies View Related

Modules & VBA :: Add Appointment To Shared Outlook Calendar Using Access

Aug 19, 2014

I am very new to VBA. I found some code that will allow me to add an appointment to my personal calendar with using access VBA and it works great. It also allows me to add an appointment to another calendar created under "My Calendars" folder.

I wanted to know how to change the code in order to add the appointment to the SHARED calendar instead.

The main folder is called "Shared Calendars" which is at the same level as the default "My Calendars" folder. Under the "Shared Calendars" folder the calendar is called "Tester".

Here is the code im using at the moment: I believe I have have to change the line of code that is in red but I don't know how.

Private Sub cmdAddAppt_Click()
On Error GoTo cmdAddAppt_Err
Dim outobj As Outlook.Application
Dim outappt As Outlook.AppointmentItem
Dim olNS As Outlook.NameSpace

[Code] ....

View 1 Replies View Related

Exclusive Access Vs Shared Access

Jun 28, 2005

I have an Access DB that 3 different Analysts use on a daily basis. I need to be able to have more than one person in the DB and be able to design Reports, Querry's, and Tables. If I try to open the DB, and someone else already has it open, I am unable to modify the design of anything. Anyone know a way around this?

View 6 Replies View Related

Access 2007 DB Shared Through Network Folder Showing Record Lock

Feb 6, 2013

I have an Access DB shared through a network folder. It is currently frozen and showing a record lock, however, none of the users have it open. Is there a way to kill the lock so I can restore it?

View 5 Replies View Related

Shared DB

May 13, 2005

can anybody tell me why my colleague cannot add records to a DB I set up on my pc.

i have a DB with 3 tables linked (all one-to-one).

i can add records into it fine on my pc but when my colleague tries on her pc it allows her to enter data but when it comes to moving onto the next record it wont allow her to save the record.

To explain further. there are 3 tables as mentioned before. lets call them Table 1, Table 2 and Table 3. When my colleague uses the form to add a record it wont let her save it as it says a related record is needed in table 2.

any ideas why it works perfectly on mine but not on hers?

View 2 Replies View Related

Db Shared Is Read Only!

Jan 2, 2007

Hi, i've a problem

there's a database in a shared folder (two pc connected NOT in a LAN).
the database is on the pc called "A", i'm in the other (called "B") ; i open the db and i've a message "read only". so i cannot enter, modify, ...
how can i give to the pc "B" the possibilty to modifiy the db??

thx in advance

bye

View 5 Replies View Related

Shared Drive

Oct 23, 2007

Hello,

I have an exrternal shared drive "E:"where I put my be files (which are constantly accessed by users with fe's from different terminals). Everytime
I reboot the computer that I am working on (where the external drive is), I have to set up the permissions of the shared drive "E:" all over again, otherwise other computers have no access to E. Is there a way that I could
fix this and not having to set permissions every time I reboot my computer?
For some reason, the permissions are lost.

View 4 Replies View Related

File Already In Use?? It's A Shared DB!!

Mar 14, 2008

Hey folks, me again...

I have a big problem and it's stopping us from rolling out the db to our call-center... cliff-notes at the end...

I have a database that tracks customer calls.
The db files are located on the network in a folder that everybody has access to.

The db is arranged as such:
A backend that holds all the tables.
A front-end for Customer Service Reps with tables that are linked from the backend
A front end for Managers linked in the same way.
And a front end for our corporate folks which is also linked in the same way.

I've tried replicating, making mde's and creating a shortcut on each CSR's desktop. I've also made sure that I use the UNC to link the tables. I've also made sure the db's are shared (I think)

Cliff-notes:
when I have the front-end open on my desktop, and somebody else tries to open it, they get an error. "The file is already in use"

Am I doing something wrong Or am I missing some type of setting??

View 14 Replies View Related

Shared Folder Problems

Feb 1, 2007

I'm currently having problems with splitting my database.

The situation as present it:

- I have a shared folder on my laptop, to which i have given full permission rights to a collegue, in this folder is the backend of the db which i split from a database also sat in the shared folder

- I can then go to the front end of my database either on my desktop or shared folder and update tables

- However, this is where the problems start. The copy of the front end that my collegue has (an exact replica of mine) cant access or open any tables. Even if he opens the exact front end that I'm successful with in the shared folder. The following error message appears

"Could not find the file 'D:Testdb_be.mdb'"

the D drive on my computer is where the shared folder 'test' is stored.

Any hints or advice on why this isnt working?

Thanks in anticipation

Ross

View 10 Replies View Related

Shared And Exclusive Databases

Mar 6, 2008

I was just wondering what the drawbacks for using Shared and exclusive databases.
id like to create a shared database but has anyone come across any problems?

what happens when 2 people at the same time access the same row and save at the same time? is the first persons work get overwritten?

View 3 Replies View Related

Different Paths For Shared Drive

Feb 2, 2006

Hello all:

I have the following code to retrieve doucments:

strPath = "G:CorpCustomer Files"

Application.FollowHyperlink strPath & "" & textbox1 & "-" & textbox2 & ".doc"

This works fine from my computer because the shared drive on my computer is saved on the G drive.

I tried using the code from a coworker's computer, but got an error because her shared drive is : "X:CorpCustomer Files"

Basically anyone can access the Corp server through any drive depends on how it was mapped.

How do I get around this so that it works from any computer as long as the user has the Corp share drive?

Thanks much.

View 5 Replies View Related