Error Accessing Network
Mar 7, 2006
I am making a database and after a small amount of progress I save it and then copy and save with same name but with an extension V1, V2 etc. so that I can keep a working one as backup. Throughout this process I have come across 'Error accessing Network' connection may be lost.....! I have to go back to my previously saved version and redo the changes I was making. This time I didnt save until I was about to make my usual backup and I had quite a few changes. How can I stop this happening and make my last DB work again.
View Replies
ADVERTISEMENT
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
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
Oct 31, 2005
Hi
I've got a back end database on one of my computers and i'm trying to get the link tables to work over a network from another computer. Ive set the link tables up but it wont let me edit any data because it is read only. Its not read only when i run the front end from the computer that stores the back end. How do i enable the front end to edit the data over the network?
also, it is a multi-user system so i want multiple front end parts accessing the one back end but whenever i try and access the data from one system when another is already open it says the file is in use and i can't do anything!
I'm really stuck at the moment and i really need some help please! :confused:
View 1 Replies
View Related
Oct 7, 2014
My boss cant access the database i made on his laptop at home.
The access database (.mdb) is on the company network.
View 3 Replies
View Related
Oct 6, 2004
And yes I now that's the title of a Knowledge base article, I stole it because it put into words what I can only say in expletives right now.
Basically, well it's all a bit odd.
I got users on the network who, until yesterday, could access some networked databases. Other files from the same source are ok, just Access files.
Today the moment they click (and I mean a single-click) on the icon to open the database...explorer hangs.
You can't open the database from within MS Access either, that hangs too. But you CAN open them up and use them if you can get them copied locally.
Oh yeah, some people (in the same room, on the same VLAN) can access the database, but can't perform any tasks within it.
Databases are a mix of 97 and 2000.
And to make matters worse, it's happening on another server.
I know you're gonna shout virus, but that looks to be a non-starter since I know of no such virus which would affect ONLY Access files and do it on a single click, and secondly The systems check out fine with both Sophos (and our good luck charm AVG) run against them.
Holy Moley! Has anyone ever come accross such a palarva?
View 2 Replies
View Related
Jul 13, 2012
How I can get rid of Disk or network error with error code 3043? What this error indicates.
View 4 Replies
View Related
Apr 28, 2004
I was working with one access application 2 months ago and I stoped. Now, I opened this access file and try to continue with it.
But I have problem! On every button, when I click on this button (it could be button for cllosing form or any other) there is one message box with followed text:
"Error accessing file. Network connection may have been lost."
I have no ideao what is going on! Even, when I create new form, put the button on it, when I click on this button, the same message appears.
Can someone help me? What is wrong with with my Access or with my Windows.
P.S.
I have Pentium IV, 512 MB Ram, Windows XP, and MS Access 2000.
Please, do send me an e-mail on dculic71@hotmail.com
or contact me on ICQ (101967172)
View 2 Replies
View Related
Nov 10, 2006
We have recently upgraded our systems from 97 to 2003. A lot of our main info is kept in our Data db and we link our tables to this main db from all our other databases.
When I try and link these tables after converting them to 2003 i get a ' Disc or Network error' and then all the queries disappear and I have to close access and start again.
Is there anything I can do or do I need to make all of my databases stand alone?:(
View 6 Replies
View Related
Feb 1, 2005
Hi
I have my Access database on a network and every once in a while (at least once a day), Access stalls and says disk or network error
We moved the database on a better server and for whatever reason, it stalls way more often, like ten times a day! I have to think that this new server is lacking in something
But the whole point, is it supposed to do that? There's about 10 users using my database, but rarely more than 2-3 at a time
Can I do something on my database to prevent this? I'm using those lines in my code
dim mycn as adodb.connection
set mycn=currentproject.connection
I don't close the connection with mycn.close every time, could it have something to do with it? Is there something that's always running in the background which could cause this?
I'm clueless cause I've created a dummy database and placed it on the network, and I'm the only one on it, and it will still say disk or network error. Is there somehting fundamentally wrong with my DB?
View 2 Replies
View Related
Jun 10, 2012
Some of my users have laptops and usually at work finish, they remove their laptops. The issue occurs when they restart their laptops again without network access and then they have some dialog boxes showing below messages:
"Your network access was interrupted and you should close MS access and restart."
When OK is pressed, some other messages like " Object invalid or not set" appears and by pressing many time OK, it does not reset. Last option is to use "Ctrl+Alt+Del".
View 5 Replies
View Related
Jan 5, 2007
i have a strange situation with a friends network
database is on laptop, the pc downstairs can open and access the db fine, but the pc next to it upstairs can see the db but gets an error on opening - of course they are using a german version of access so im not entirely sure of the error message but its basically "cant open the db on this intranet, copy it to your pc and then open it"
all pcs are running xp and the same version of access (2002)
the db is in the laptops shared docs folder
one pc can open it fine
the pc in question can open and edit a word doc (for example) in the same folder but not the mdb
i can map the drive on the pc as well
it seems more of a win xp file permission thing but the pc can open and edit a word doc ok
the only thing (seemingly) different with the 3 pcs is that the problem pc is in english and the other 2 in german (but why that would matter i dont know)
i'm supposed to be the pc guru but this has me stumped - any ideas ?
View 12 Replies
View Related
Jan 16, 2007
Hi there
I got a little problem here. I have a mdb that must be moved to another pc, but whenever I try to open it (on the other pcs) I get the message that I don't have permission to read.
When I try to change the permissions it says that I must be an administrator to do that, but I am the pc administrator, so I guess it must be the mdb's administrator.
Does anyone know how to change the permissions, or how to make me the program's administrator/proprietary?
Thanks for your time people!
View 3 Replies
View Related
Nov 22, 2004
I have copied a database that I used for another project for a new one. Everything is the same but when I try to use the command buttons on the form it give me "no record found" error, even though there are records in the database. I know that the Error message is the one that is writin in the database by the orginal designer, I can't quite figure out how to fix the problem I think that it has something to do with the VB coding in the comand button, becuase of the type error message that I am geting, but I don't know how to do it. I can't post the database becuase it is way to big. Everything else is working fine. What hte command button is supposed to do is update a total score percentage based off the numbers that placed in the database also any of the score can be left blank as to not count, max for each score is 5 min is zero, i.e.score1=3score2=5score3=5score4=score5=4score6=3Total Score =80.00%I hope that this makes sence.J
View 3 Replies
View Related
Feb 25, 2005
I have time entry program that the company I work for recently purchased that uses a SQL server 2000 Back end. I can connect to the database just fine if I create a project in Access. What I need to do is take data out of a couple of the tables in the SQL Server and place them in an access table. I really don't want to add any code or tables to the Access project that I created since it seems it would add tables and queries to this products database. What would be the best way to siphon data out of this software package for my own use? This would become a daily process so it needs to be fairly automated and easy.
Thank you for your help.
View 2 Replies
View Related
Mar 28, 2005
I have an access db and I want to access the subform on
one of my forms. Can someone help me with the syntax
to access these forms.
I tried this but it did not work.
Code:formname.variablename
View 1 Replies
View Related
May 6, 2005
Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name.
This window has several tabs including "Summary" and "Custom." It looks like this should be stuff that I can set and then reference from within my code.
My thought is that I can use the "Title" from the "Summary" screen as a variable for all of my msgbox titles. The other interesting one is "Project" on the "Custom" tab. It looks like this may be the same sort of thing.
I've found that the Access Help is absolutely useless - I'm about ready to take a shotgun to "Clippy." But as they say, a display is a terrible thing to waste <grin>. I've also found that it's getting harder and harder to find what I'm looking for in the MSDN library. There's so much stuff and they don't always file it in logical places.
Well, thanks for reading.. sorry for the rant. As usual, any help is appreciated!
Cheers!
View 2 Replies
View Related
Mar 31, 2006
Hi there
I have an application that I run in our business.
Everytime I make changes to the code I have to export all the tables from the original into the latest version of the database with the new code.
This is a pain and makes updates time consumming and prone to error.
Is the soloution to have 2 databases. One with the tables and the other with the code (forms), & reports ect
If so, how do I access tables in the 'tables' database from the 'front end' database??
Thanks in advance
OLiver
View 3 Replies
View Related
Jun 6, 2006
Hi,
I have split db with the backend residing on a computer in my workgroup in the shared files folder. I have access to the folder and can view the file perfectly fine on the other computers in the workgroup (a wireless 54Mbps network). The problem I am having is that almost every time i access the backend tables from another computer in the workgroup, access freezes up and has to be shut down. Sometimes, after restarting access it works fine, others not at all.
Any suggestions or help would be greatly appreciated.
View 1 Replies
View Related
Dec 5, 2006
Hi all! Hope you can help me yet again!
My company recently completed a fairly large website for a local travel-agency. The website runs on a MsSQL and .net platform, but (It is a big but(t) by the way) a pricing calculation database is a old MS Access 2000 application.
The users of this DB have MSA2000 installed on their computers, and the database is made with one application DB and connected tables.
My problem is that I have to make some small changes to this DB, but when I start it up, the toolbars is hidden and right-clicking is disabled. (F11 works).
Is there a workaround this problem?
View 1 Replies
View Related
May 1, 2007
Okay,
This is a bit of a weird one I hope someone can help with. I have a fairly small db that needs 3 con-current users. It is split and until recently, the backend resided on one of the computers in the shared folders directory. In this configuration it worked fine, but just recently I have set up a network using a Mac OSX server (xserve) and it is causing a bit of grief. It seems that only one user can access the backend at a time and I have tried just about everything listed in these forums with regards to permissions etc. One bizarre thing is a post here suggested I join/create a new workgroup, did that, stored on the same shared directory on the server. Every time one of the other users on the network joins the workgroup, then re-opens the frontend, they are still logged in as Admin, not the new user recently created. The folder where the workgroup file and backend reside definitely has no access restrictions. Is it something to do with the Mac environment or something else. The only way around it so far is to log 2 of the computers to the server as the same user, this sort of works.
Another weird thing is every time one of our users opens the frontend, a new workgroup file is created, system1, system2 etc. Is this normal?
Any suggestions you might have would be greatly appreciated.!!
View 2 Replies
View Related
May 4, 2007
I have an MS-SQL backend which i use for my data source. I then use Access for reporting services. (It works so much better than SQL Reporting Services 2005).
this seems simple, but i can't get it to work. Everytime the users start up access, It pops up a login and password for the ODBC link. Even when i have the password and login setup in the ODBC DSN, it still requests it everytime you start connecting to the datasource.
Is there anyway to somehow hard code this into the Access front end somehow so i don't have to give the password to the users?
View 5 Replies
View Related
Jan 13, 2006
Ill start from the dawn of time
right all tables are like a 2d array so does any body know how i can access a field in a row of a table ie like in most languages it goes a bit like this ArrayName(1,1) with ArrayName being the name of the table and that access the first field of the first row. im new to Vba and access 2000 but all i want to do is access the fields in a column of a sub-form displayed as a table add them all up and place the answer in a text box on the main form stick all this in a function so i can run it inside a macro
q1 is this possable
q2 how do you do it
thanks in advance john
View 5 Replies
View Related
May 17, 2007
Hi!
I'm making a test database for DVD rentals. When A loan is made I have an update query that sets some fields in the DVD copy table. One of these fields needs to be set to the primary key of the loan made. This would be the last entry on the loans table. I don't have any idea what to put in the 'Update To' box in the query though.
Wrong code here, but this may help explain what I am trying to get: Tables.Loans.LastLoan.Loan ID
Also heres an image of my query:
http://i92.photobucket.com/albums/l15/mikegrundel/Accessproblem.png
Help would be much appreciated. Thanks :)
View 3 Replies
View Related
Dec 1, 2005
I currently am trying to do this:
dim a as form
a = me.form
I get the following error: "Invalid use of property"
Is there a function that lets you select a form using its name.
eg: makeactiveform("NameOftheForm")
Or alternatively if there is a function that gets the activeform. (it's for use in a module)
I you can help me Thank you!
View 2 Replies
View Related
Jun 29, 2006
Hi!
I want to access individual rows in a subform (frmOrderdetails (datasheet view)).
The reason for this is that I have a checkbox at the end of each orderline, and user will be able to check individual lines and do a return of these lines.
For now, I have a query to return lines, but the problem is that when there are two lines checked, it'll only return the first one.
Anybody that knows how to obtain this?
:-)
Thank you!
View 6 Replies
View Related
