Access Network File Sharing Problem
Apr 30, 2007
I am running a small access database over a wireless network which all worked fine (still does on 1 wired/3 wireless) with not too many problems total of 6 machines (5 wireless/1 wired). I have just replaced two machine as they were getting a bit old 3years. But these two new machines do not seem to have full rights to the access database, in that I can open the database and view records but when you add data you get a Disk Error message. I can open and share word documents etc but not the database – if I reverse this set-up I get the same problem the wired computer can open and save word documents but again not the database - what am I missing!!!
SET-UP = All machines have Windows XP Pro and Office 2003 with all windows/office updates done, all connected to the same workgroup etc. Two new machines are Dell with Dell Wireless adapter. No server just workgroup and database in a shared folder on one computer which is hard wired to the Netgear wireless router. I have not run any network wizards and I don’t think I need to, just sharing the folder should be enough? Windows is managing the dell wireless adapters, file and print sharing is enabled, other computers can print to this computer, but I just can’t get the database to share correctly – I have also checked “References” and all looks fine.
View Replies
ADVERTISEMENT
Jan 22, 2008
I have created the time booking application in access. (Application will alow autherised user to enter daily work done) My Idea was to put this file on the server and ask each employee to log in and enter information. But whenever I try to run application from other than my pc(On which file is created) it flashes error and can't run some of the form. It works absolutely fine when run from my pc. Why this hapens? What is the solution for this? Can access application is sharebale over network?
View 10 Replies
View Related
Feb 11, 2008
I have created multi user access application. I have kept it on server and all users access that application from there desktop pc. Can I set time out for application? Means, Session of each user must be note more than 10 minutes. I want to add this functionality for avoiding the application blocking.
View 2 Replies
View Related
Sep 18, 2007
Hi Guys,
This might sound like a stupid question but I'm just trying to work through it in my head and I don't want to miss something, so a couple of new pairs of eyes might just clarify.
I've created a call monitoring database for a call centre and I have split this so that they have a front end and a back end as per someones instructions. They have done the normal thing in as much as just putting a shortcut on everyone's computer so that they are all trying to access the one front end instead of putting a copy of it on everyone's machine. I've got a feeling they are going to ask me to go in and put it right, so when they have put a copy on everyone's machine will that automatically link to the back end or do new links have to be made, if so how would I/they do this? - is it done from each computer?
I don't really know, I'm just assuming that's what needs to be done but I don't want to tell an IT team that what to do if it's not.
I've only ever set up a sharing database once before and that was built on the company network and I set it up on each computer in the department, but they weren't doing data entry it was only for interrogation purposes and it was a few years ago now so I'm rusty, but I do remember it took me a long time to do.
Thanks for any help.
Donna
View 8 Replies
View Related
Aug 17, 2005
I have a multiple user situation, the db is Access 2000, all works well then last week the IT technitian upgrades one computer to Access 2003.
The db is hosted on this PC and shared to other users, now multiple access to the db is no longer possible. I request that the db be moved to another PC with office 2000. Now all the users can share the db simultaneously but not the 2003 PC.
The OS (WIN XP) shares are set right, and the db itself is shared.
Any help will be appreciated
View 1 Replies
View Related
Jul 30, 2012
i have made a database in access 2010 . and i have put that in a shared folder . split that into fe and be. and on my network i am using access 2010 runtime on other computer to access it . on that computer in registry settings i have trusted locations as //server/database i.e. in database folder i have the fe and be.i can open the fe but with potential security warning i.e. of trusted locations i think . and when i click open on it it doesnt open my forms those are linked with tables from navigation form and displays the error that is something concerned with location g:database which is on my server computer.
View 2 Replies
View Related
Oct 19, 2014
I want to deploy an access database at a small office with 5 computers, small network. However I do not intend to create a server in order to have a domain etc. Operating system is win 8.1 pro. Should I use a homegroup or workgroup ? Would it require password in case of workgroup? Which is a recommended way to setup this and keep some security like a guest cant access these files?
View 14 Replies
View Related
Aug 14, 2007
Here are some background . My company got a access file in a network drive.The data entry simply open the file in the network drive.But once the data has increased (~400mb) sudddendly,all process slow down. Like search , using report etc.Is there any method to imporive the situation?Some guys suggest me to copy the data file to the desktop and sync them.Can it it work?IF works,how to do that?
thanks gratefully for any ans
View 3 Replies
View Related
Jul 27, 2005
Hi,
I have some code which updates an invoice table with transaction numbers. It worked ok until this month when we had to run three months worth of invoices in one go. I recieved a runtime error 3052 "File Sharing Lock Count Exceeded" and Access told me to increase the MaxLocksPerFile registry entry. I thought i'd better check it out a bit first though and found the following on support.microsoft.com
In Microsoft Access 2000, you can take advantage of a feature that allows you to increase the MaxLocksPerFile setting for Microsoft Jet database engine 4.0 by editing the Windows Registry. The default value of this setting is 9500. However, changing this value is not recommended if one of the replicas is located on a Novell Netware server, because the server's maximum record locks per connection is 10000.
The invoice table had about 20k lines but as I am on a netware server i'm not gonna be able to squeeze more than 10k lines out of my recordset so I was wondering if there is any way I can open it without record locking? The table that is being modified is never edited apart from in this one process so there is no risk of complications there.
Here is how I opened the recordset
Set rstInvs = dbs.OpenRecordset("SELECT [InvNumber], [InvNumExt], [TransactionType], [LineNum] FROM [tblInvoices]" _
& "WHERE [LineNum] Is Null ORDER BY [InvNumber], [InvNumExt], [TransactionType]")
Any help would be much appreciated.
thanks, Tom
View 14 Replies
View Related
Dec 2, 2014
I have a button that adds pictures/files to a network location. So people from all over the company can do this and all pictures/files are stored in one location.
I also have a delete button, but a waning pops up and the file remains on the network.
PHP Code:
Run-time error '424': object requiredÂ
Code:
My.Computer.FileSystem.DeleteFile (Path)
where Path is a string, files location on network.
View 4 Replies
View Related
Dec 6, 2006
I have 2 files with linking tables. Both are posted on the same network drive for the office to access. However some users have their drive link to drive E: and some to G:, etc. How do I get the file to automatically find what drive the user has and update the correct link in Linked Table Manager?
Thanks for your helps,
Penguin
View 4 Replies
View Related
May 20, 2005
I think the damage to my database is not recoverable, but i'm still hoping.
My computer crashed when I was working on my dtabase and after restart the db is not working anymore :( If I try to do something, anything (!!!) all I got is an error message: "Error accessing file. Network connection may have been lost." But the db is on my computer, I don't use it over the network.
What can I do to make it working again?
Thanx!
Attila
View 8 Replies
View Related
Mar 22, 2014
I have a picture stored on a network file share that populates each time a particular form is opened. Every so often we lose our connection (which is a different issue altogether). Right now the error I get after much grinding away, is "Bad file name or number"
Is there a quicker way to check for the connection before it spends 45 seconds trying to find the whole path?
Code:
Dim vFolderPath As String, dirFile As String, strFile As String
vFolderPath = Nz(DLookup("FolderName", "tblCodes-FolderControl", "FolderKey = '" & "Profile" & "'"))
dirFile = vFolderPath & Dir(vFolderPath & ctrl_people_id & " *", vbDirectory)
strFile = dirFile & "profile_pic.*"
'Debug.Print dirFile
On Error Resume Next
If Dir(strFile) <> vbNullString Then
Me.[ctrl_ImageFrame].Picture = dirFile & "" & Dir(strFile)
Else
Me!ctrl_ImageFrame.Picture = "X:~stuffprofile_icon.png"
End If
View 4 Replies
View Related
Jun 9, 2005
I have an access database that I used to be able to share between 5 different people (we were all able to input data at the same time) Something has changed and now only one person can get in to work on it at a time. If someone else tries it tells them that it can't find the database. Has anyone seen this before and if so what's the fix. Any help would be greatly appreciated.
View 2 Replies
View Related
Jan 20, 2006
Goal
I'm trying to trying to setup a MS Access database on a shared server drive where all of the main tables are linked via ODBC into an SQL database. The SQL database is updated and maintained via purchased application. It appeared that MS Access security could be used to control the type of access each user has. Most of these users will have read only access for reporting purposes since the main application is used to update and maintain the data.
What I've done.
1) I've setup ODBC Access for each user. Not sure if this should be User, System or File DSN. They all work and I can't tell at this point that it makes a difference.
2) Created the MS Access Database, created users and assigned security.
3) Linked the needed tables.
Problem
1) When I had a user try to access a table it said "Table definitions not defined". What I then realized is that the MS Access on there machine was picking up their default security. A security Table and a shortcut (.mdb1 file) that pointed to the correct security and table definitions.
2) Now when the user gets in everything seems to come up fine but when they try to go into a table they get an error saying they don't have permissions. If I relink while they have it open, they can get into the table just fine. However, they can't delete the old tables because they have 'Read only' access. I don't really want to have to relink all the tables for each user, I might as well to go to each of their machines and set them up individually...not a good idea.
What now?
This seems like something that should be fairly easy to do..what am I missing?
View 5 Replies
View Related
Feb 19, 2007
hi everyone,
i have designed a simple database which need to be accessed by 3 different people(number likely to increase) located in different towns.what do i need to do especially from a technical point of view.
Thanking you in advance.
View 5 Replies
View Related
Jul 29, 2007
I have developed an application for a friend. We live about 100 miles apart in the UK. The database (Access 2007) works perfectly for us, I input data from various sources and he views the reports I've designed that show him exactly what he wants to see.
Now I want to move to the next phase which is I enter data from my PC at home and he then views the reports on his PC at his home.
Any advice on how I can do this, at low cost,
View 2 Replies
View Related
Mar 3, 2008
OK, I have spent the best part of a week trying to sort this out, so if anyone can shed any light on it, I would be very very grateful.
I have created a database in Access 2007, which I wish to share with my collegues. We all are running Vista, and access 2007, over a peer to peer network.
I have installed a Front End on each Computer and linking to one copy of the backend on the host computer in the public drive.
The system runs great on each PC, however, I am having a problem sharing the database. All users can log onto the database at the same time.
However, when one user enters a form, it locks access to the form for other users, it just hangs until the other user exits the form, then the user that was hanging goes directly into the form. I get no error message.
I have tried linking the form to a query rather than directly to a table, but no joy with that either, the form still allows only one user.
I am not sure if this is an exclusive permissions problem and I need to change the Windows security settings or something else.
Like I say, if anyone can help, it would be really appreciated. :D
View 10 Replies
View Related
Apr 8, 2008
I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to any help would be greatly appreciated.
I have attached the asp file, I can upload all files and database to a server if someone requires them (too big for the forum).
Thanks,
Richard
View 2 Replies
View Related
Feb 11, 2013
Does a (the) .ldb file have to be closed for another user on a network (separate FE linked to network drive BE) to read/write info to a table? Or even select info from a table?
View 6 Replies
View Related
Apr 27, 2012
I created an access database for the sole purpose of sharing approved data with my entire company. The end users will view the data in a Form which utilizes several tabs and also gives them the ability to run pre-set queries out of the Form. The Form was created using several queries which were built from tables off of the server.
The tables update every day, as does the information in my Form. The problem I am running into is that it takes about 2 minutes to open the DB (the DB opens directly to the form and all queries run immediately to update), which is annoying to end users and might deter them from actually using the tool. I have tried moving the DB to SharePoint, but that did not work due to the size of many of the tables.
View 2 Replies
View Related
Aug 4, 2013
I've just split a database into the front-end and back end components. But how to distribute it further.
Additionally, I need people who have the front end to access the database from their homes, not just from work.
What would I need to use?
Is there anything available for free?
View 3 Replies
View Related
Oct 12, 2007
Hi all,
I have been developing Access 2K applications. Lately, every time I click a command button on a form or even open the code window for a form, I got this repetitive error message. I even create BLANK Access db and re-import all objects or create brand new form and copy the control designs/code from the error one to the new one. The new db or the new form still have the same ERROR, which is as follow :
"The expression On Click you entered as the event property setting produced the following error: Error accessing file. Network connection may have been lost.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluation the function, event, or macro."
Please help! Thanks so much for your suggestions/
Have a great weekend,
View 1 Replies
View Related
Apr 1, 2006
For the past several years I have been designing and building Access databases. They are designed for small evironments to be used on one machine only.
I am now faced with a situation where my client would like to have his database placed on his network server so it can be accessed by several computers.
This is a little outside my area of expertise.
I have searched the forum but I keep coming up with references to front end and back end and other things I don't understand.
Can someone point me in the right direction to search for:
what should be on the netword and what should be in the computer.
what changes should I make to the database stand-alone vs. network.
what unexpected problems should I expect.
Or perhaps you could suggest a book I could buy to assist me.
Many thanks
View 12 Replies
View Related
Jul 4, 2014
I have problem sharing an Access 2013 file from one cumputer and then change the data in the file on another computer, or i can change it but the change wont be made one both computers.
I'm working so i need my secretary to be able to change information or add, but i also need to get the change.
View 2 Replies
View Related
Nov 29, 2005
Hi guys,
does anyone know if there are issues using Acess on a wireless network? There seems to be problems access the database now that this has been installed... Lots of reboots required etc...
Ta muchly
View 1 Replies
View Related