Dear All,
I have a MS Access put into shared server to let user to use. However, when a user tried to open to use it, it prompted user that "Not enough space on disk".
I have checked the server size and local harddisk. There are also contain enough space to use. (My Access just 6MB only) Is there any user face this and solve before?
I have tried to search in google, nothing can be found. Please help!!!
OS = XP pro SP2
200GB IDE HD with 134GB free (NTFS)
200GB USB2.0 with 54GB Free (NTFS)
Virtual Memory = 1gb (Let Windows Manage)
Trying to copy files from a external USB drive to the Hard drive.
I have done this a million times and now it decides to foul up. When trying to copy files from the external drive to the hard drive that are 4GB or higher I get an error "Not Enough Disk Space"
Both Drives are NTFS with Plenty of free space. Also get the same error when creating files larger than 4GB. It worked before and no OS changes have been made that I know of.
I've been searching on the net to know what exactly does the error message "3026 - Not enough space on disk" mean when it pops up not allowing me to open my access file. Please offer your help. (This message pops up at many other cases... e.g. when saving a file - but i don't know what's the problem in this case)
View 1 Replies View RelatedHow I can get rid of Disk or network error with error code 3043? What this error indicates.
View 4 Replies View RelatedHi
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?
Since splitting my database into a front & back end - when I attempt to run the front end part from a client PC logging in as one of the users/groups defined I get : 'Disk or Network Error' and the DB fails to open.
If I log in using the same username/group bypassing the config/startup options - I do see the Access Design view main window - but then if I attempt to open (not all) most of the forms in Form View - I again get the same 'Disk or Network Error' message each time.
Yet, if I log in as the administrator from the same workstation - no message appears?
Any ideas please? :confused:
Not an expert developer but have been distributing a database based on ADT for Access 95 .
Clients machines with 1GB of memory has forced me to move to Developer for Access 2000 .
One customer in France when trying to load is getting the message :
VISUAL BASIC 6.0 SETUP TOOLKIT
Office Systems Pack cant be installed as the languages are not the same.Install the Office system pack for the appropriate language,
What do I do?
How can I still use ADT for Access 95 (with which I've had no problems) on 1GB machines without getting the "Out of Memory" glitch?
Hi,
I'm looking to take a screen dump of the current Access window, and save it to disk, as part of the error handling for my application. Does anybody have any suggested starting points? I've been Googling around for a while, but haven't really turned up anything concrete.
This (http://support.microsoft.com/?kbid=240653) was as close as I really got (sending the print screen keystroke), however I still need a way to save this data to the disk.
Any suggestions?
Thanks,
-Adam.
Hi,
When I run some procedures in a db, I get the message that the disk is full, and the computer eventually hangs. Of course the disk isnīt full, so there has to be some other explanation.
Does anyone know whatīs going on?
Fuga.
I have a query that pulls information from two different columns in a linked table, and places them together in a single column in a new table. The expression that i use in the query is: Expr1: [ARTINAME]+[ TITLE]. I need to put a space between the two. Is there a way to put a space in between these two when written to the new table?
View 3 Replies View RelatedHi everybody,
Amongst many other things i would like to be able to see which teams in our company have access to which database. We currently use up to seven!!! different Databases which makes for tremendous fun...just kidding.
Since every Team has access to more than one Database andevery Database obviously gets used by a multitude of Teams, i thought the best way to go would be a Junction Table. Whilst building this, however, it occured to me that i could have just created fields for each Database in the Team Table which then can be ticked.
So here's my question, is it more space consuming to create a junction table, it certainly appears to be more work right now...
Thank you very much,
Dan
Hi!
Is it possible for me to alias the fldGroup to Function Group?
How do you alias a field name to a name that contain a space?
Please advise.
Aijun.
I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63, in the above examples I know I could do a search and replace " " with "" but I need this to be run automaticly where would be the best place to do this and if coded how?
Any help or alternative suggetions appriciated
Hi there
I would like to know how to find out how much space a table uses within an MDB. is there a analyser of some kind available that you know of?
Thanks
I need an expression which finds the first space from the right and returns the text (variable length) to the right of it.
Ex.
AMINOPH, THEOPHY. INJ
expression should return INJ
I am trying to break out a field where city, state and zip codes have been consolidated. I want to create a field where I am able to ready the consolidated right either right or left until the first blank space. For example:
"pittsfield ma 01201"
I want to read the field to break out "pittsfield"
Thanks in advance for any help I can get on this :)
Hello Everyone :cool: ,
In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:
[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.
[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.
**Every charge amount is different, and every codes length is different; so there is no consistency in this field.
I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.
HELP!:confused:
Thanks in advance everyone,
Martian262002
Hi, i wish to check the user C drive remaining spaces using vba, how to do this?
View 6 Replies View RelatedMy following sql statement is wrong. "Scenairovalues Step02" is the table name. How should I write this one with the empty space in the name?
vtSql = "Select * from Scenairovalues Step02"
Thanks a lot in advance!
Hey all,
I got a massive lump of WORD documents with Avery Mail label tables -- each avery mail label template/table has a mailing address. This how these people store their data. :mad::confused::mad:
So I went through and over a couple days transfered all 458 records to an excel spreadsheet for easy importing to my access mailing database. Problem is that I forgot to clean up a couple of the fields and now I have all these values with unnecessary spaces as the first or last characters for a lot of values.
My question:
Could anyone help me remove the first and/or last character of these values if the character is " "? Would it be easier to do this in excel and just re-import?
Hi!
I have a field that has to be 20 Characters long. Most of the time data for this field is less than 20 characters, so the remaining has to be filled with spaces to make it 20. e.g. if there is a record xyz1234567, then the rest of the record should have 10 spaces like xyz1234567ssssssssss, meaning if i click on this record then the cursor should not blink after 7 but after the spaces. Hope I am making sense.
Thanks for any input.
can anyone help, when trying to run a dedupe query i get a error message saying 'not enough temporary disc space'
View 1 Replies View RelatedHi
is it possible to combine text in a table when some have a space between them eg 123 456 789B would like it on the table as 123456789B without any space. I was not sure what command to use in a query to get this type of and use it for an update query if possible.
Can someone help
Many thanks
Hello all,
I have a field in a database that has people's full name (e.g. Jane B. Doe). I would like to sort by their last name. Can I build a query that looks at everything after the last space in their name? Thanks in advance.
Ron
I am trying to find the position of the second space in a string, but have not been able to find a solution. Any suggestions on how I could do this using an expression in the QBE window or VBA would be appreciated. Thanks in advance.
View 8 Replies View RelatedHello,
I have a text field for filling in details of a job description. I only need a brief suummary, but unfortunately I require more than the standard 255 characters.
Is there any way of doings this? I woudl like to be able to add the information to one box in my form as I am cutting and pasting the text from MS Word documents.
Thanks