Over 1 million tech questions and answers.

Solved: Avoid file write error in Access 2003 when folder does not exist

Q: Solved: Avoid file write error in Access 2003 when folder does not exist

I am using OutputTo to write a file to our network and I would like to know how to error check that the computer is attached to the network and that the specified folder is available. I use the command below
==================
'File will be named with drive+path+rm#+revised+rev date.snp
pstCriteria = "[rm#] = Me![rm#]"
stDocName = "rpt R1"
'stPath = "e:\" 'use for testing when not connected to network
stPath = "s:\rm specifications\R1 changes and additions\" 'network drive and folder where R-1s are stored
'Construct the date because format of [rev date] can include / which is not allowed in file name
stDateStamp = " revised " & Month(Me![sfrm R-1]![rev date]) & "-" & Day(Me![sfrm R-1]![rev date]) & "-" & Year(Me![sfrm R-1]![rev date]) 'append revision date to saved file
stFileName = stPath & Me![RM#] & stDateStamp & ".snp"
Refresh
DoCmd.OutputTo acReport, stDocName, acFormatSNP, stFileName
Exit Sub
===============================================
The error messages referred to in the next paragraph are shown on the file attachments.

This works fine when stPath specifies an available path but if the path is not available then I get an error message which I can clear but which brings up another error message. Clearing that error message sends me back to error message 2 and the only way I know to get out of this is to close the program from task manager.
My question is then whether there is a way to check for the existence of stPath so I can bypass the outputTo command when the path is not available.

RELEVANCY SCORE 200
Preferred Solution: Solved: Avoid file write error in Access 2003 when folder does not exist

I recommend downloading and running Outlook PST Repair. It's a PST repair tool that I've used it in the past to recover emails, contacts, tasks and notes from corrupt Outlook files that are damaged or inaccessible. Supports Outlook 2000, 2002, 2003, 2007, 2010 and 2013.

You can download it direct from this link http://goo.gl/1bjhSi. (This link will automatically start a download of Outlook PST Repair that you can save to your computer.)

A: Solved: Avoid file write error in Access 2003 when folder does not exist

Read other 8 answers
RELEVANCY SCORE 74

Whenever i try to rename a folder it says file or folder does not exist.
it doesnt matter where i try to make one or rename one it always says the same thing.
please help.

Read other answers
RELEVANCY SCORE 73.6

Good morning,
I have a simple question, at least I hope it's simple.
I have and Access database and I use the table's properties description to show how many records it contains or just add some information for other users to read.
I found that I can retrieve this information using the foloowing code

Code:

Sub gettdesc()
Dim o As Object
Dim p As Property
Dim db As DAO.Database
Set db = Application.CurrentDb
Set o = db.Containers("tables").Documents("_ontbrekende-cis")
On Error Resume Next
For Each p In o.Properties
If p.Name = "Description" Then _
Debug.Print p.Name & vbTab & vbTab & p.Value
Next p
Set o = Nothing
Set db = Nothing
End Sub

As you may notice I check If p.Name = "Description" which is the same as p.Type=10
As extra test I have a loop, not shown, and it tells me if p.type = 10 or p.name = "Description" exists
Two options:
If the value is empty (non existant) I want to add new data automatically with the table's or query's recordcount
of if the valeu does exist I want to update it with the table's record count.

Any help or suggestions is appreciated.
I want to update the Description with the tables record count
 

A:Solved: MS Access 2003: retrieve / write Description information

Read other 16 answers
RELEVANCY SCORE 68.8

I need to develop databases in both versions of Access. I don't want to work entirely in 2003 and then save down because most of my users are still on 2002 and I need to test functionality for them. Does anyone know if these two versions can live safely on the same machine, or do I have to find another pc to install 2003 on? Thanks.
 

Read other answers
RELEVANCY SCORE 66

Hi to all   I Installed “GoodSync” yesterday luckily’... because I found what I think is a remaining issue from the Dramas I had with Win 8.1 and the MS Windows Accounts and Log-in Phobia!
I finished up with about 5 User Accounts from scratch one of them was called "Dasha" so once I sorted it all I just kept Admin, CatDog and “Guest” Accounts? CatDog was the Account I was using and is was an  ‘Admin Local Account’ and is the one I use (just my wife and I use this Home computer)? 
 
So I deleted the rest. However I realised that my Computer is running on C\Users\Dasha.... So in Control Panel >“Users Accounts” I changed (Re named) "CatDog" to “Dasha”. 
Meaning I think that when I had deleted the "Dasha" account only the name "Dasha Deleted- all the Profiles and Programs etc remained and had renamed that account as "CatDog" and thats what I have been using until now
All seemed good until I tried to do a Sync to my&... Read more

Read other answers
RELEVANCY SCORE 64.8

hi,
I am facing an typical issue with share folders.
the below error appears for some users when they access any folders in the share folder which is mapped.
at the same time if i open the share folder with \\hostname instead of \\10.x.x.x the same folder is working fine without any issue.

can any one help on this error
Thanks in Advance

D. Sendil Kumar

Read other answers
RELEVANCY SCORE 64.8

I stored some files on my D drive which is an external hard drive ...

Lately I have had this happen a number of times with totally unrelated files in different places on the D drive.

I try to open them (in Excel, but I don't think that matters) and I get an errors saying the file does not exist and to make sure it wasn't deleted or renamed ...

However, if I copy that file to folder on my desktop it works just fine.

Is this a hardware problem with my external drive? It is not true of all the files ... for instance there are say 19 similar files in a folder and maybe 2/3 of them give me errors while 1/3 do not.

Read other answers
RELEVANCY SCORE 63.6

Hi all

I'd like to have the feature whereby on click of a "Compact Utility" button on my form, then the application will compact the currently open database and will offer me a choice of where to store the compacted DB and to allow me to change its name if I wish.

Is this do-able programatically?

I have no probs with the dialogues, just the compacting process.

Thanks in advance

Chris
 

A:Solved: Access 2003: Compacting to a new file name

Chris, yes it is doable up to a point, because you have to supply the Compact Command with both database name and save as name.
However I did find one major snag, the VBA version does not appear to want to Compact the Database that you have open, (Unlike the Menu Version), it produces an error. It works fine from another database though.
So I produced a routine to open the Compacting database using windows scheduler, opened a form to run the code, compacted the target database and then closed the form and database.
So to do what you want would appear to be impossible, unless you close the database.
see this Thread
http://forums.techguy.org/business-applications/843146-access-2k-fe-speed-question.html
 

Read other 2 answers
RELEVANCY SCORE 63.6

I have one workstation (Win2K Pro) on a LAN that refuses to use the default workgroup security file. Every time you open Access 2003 it creates a new file named system1.mdw. I have deleted all of the system.mdw file and placed the correct workgroup file in the user profile and it is still ignored and still creates a new system1.mdw

I have not checked the Office SP level on the workstation and there are no older versions of access on the PC. I suppose I could use the /wrkgrp switch if all else fails.

Thanks!
 

A:Solved: Access 2003 Security file

Have you used the workgroup manager to join the default group?
 

Read other 2 answers
RELEVANCY SCORE 63.6

Does anyone know if it is possible to run a batch file when Access 2003 database is opened? If so, how would that be done?
 

A:Solved: Access 2003 & Batch File

Read other 16 answers
RELEVANCY SCORE 63.6

Hi

I need to get the files from a specific folder using VBA.
I use FileDialog for that, but the problem is that it loads the whole path with the file name, while I need only the file name.

Is there any way I can do this?
Thanks,
Barbos
 

A:Solved: MS Access 2003 (VBA) - FileDialog (File name only)

Learn about the "File System Object"

Methods used with that object and related objects like the File object can do lots for you.

Go ahead and use the file dialog bok to get the whole path with the file name and then call the function below:
Public Function GetJustTheFileName(WholePathWithTheFileName As String) As String

Dim Fs

Set Fs = CreateObject("Scripting.FileSystemObject")

GetJustTheFileName = Fs.GetFileName(WholePathWithTheFileName)

Set Fs = Nothing

End Function
 

Read other 3 answers
RELEVANCY SCORE 63.2

I have kinda setup a network with my computer and a laptop which has just been formatted. It now has XP service pack 2 installed and I have to enter the password and username of an account on the laptop in order to access the resources.
Now I can access the laptop using my computer, when the laptop tries to access my computer, and tries to get a file, the message on the title always comes up.

I have unchecked simple file sharing and enabled full access (read/write) on the laptop whose account Im using. But it didnt work.

When opening my computer today, I have noticed a message about migration and program controls and some information about windows NT and windows 3.x This has never popped up and am wondering if this has made any changes to my computer not the laptop.

So Is there a simple way that does not restrict the laptop from getting the resources on my computer??
 

Read other answers
RELEVANCY SCORE 63.2

I began a database in Access 2003 a few years ago. Two days ago, the file size was about 500k. Then our IT staff upgraded our machines to Office 2007 and I began using my database in Access 2007. In the last two days my file has doubled in size. I have only added one new query which has an output of 5 fields for 450 records.

Has anyone else had this experience with Access 2007? How much more can I expect the file to grow?

Thanks,
Lisa
 

A:Solved: Access 2007 - file 2x bigger than 2003

The file size in Access 2007 should be smaller, but only if you convert the database to the 2007 version of Access. Just opening the 2003 database in access 2007 does not allow you to use some of the new features available in Access 2007, like smaller file sizes.
 

Read other 3 answers
RELEVANCY SCORE 62.8

I have a Windows 8 computer and a Windows Vista laptop. Both computers are connected to my network. I Have a portable hard drive attached to the Windows 8 computer. I can read the files on the portable hard drive from the Vista computer but I can't copy to them or download to them. When I try to drag a file from the Vista Computer to the Windows 8 computer it says I need permission to perform this action. I think I have the settings correct. I have file and printer sharing turned on. I am running Kaspersky Internet Security 2013 but even with that disabled I still can't copy to the Windows 8 computer. Can anyone help??? Thanks in advance for everyone's help!!
 

A:Write Access for a folder on Windows 8 computer

Read other 9 answers
RELEVANCY SCORE 62.8

I have no write access to the program files folder (only). I have check security, it's all as should be..
I can log into administrator in safe mode and do anything I want in the program folder.
Make admin available in normal mode.. even the admin is blocked for installing, deleting anything from the programs folder.
I'm lost.

A:Write access to program files folder

If you create a new administrator account in safe mode, are you able to write to the programs folder?
Edit: Is the OS XP Pro or XP Home?

Read other 11 answers
RELEVANCY SCORE 62.8

Up until recently I was able to import cds onto itunes with no problem - now it says I do not have write access to the music folder and also no access privileges. I have recently changed my internet browser from ie7 to safari - would that have anything to do with it? I have tried enabling sharing on all music folders but nothing seems to work.

Read other answers
RELEVANCY SCORE 62.8

I accidentally removed the file from an particular app and now when i try to restore it, it says "Destination Folder Access Denied" can anyone help??? I tried tweaking with permissions and user control but it still doesn't allow me to restore the file. The destination of a file is in Program Files\WindowsApps\

A:File restore error, Destination Folder Access Denied,

But what was the name of the program or file? Could be one of us could help but that information is needed. In other words, don't keep it secret.

Read other 3 answers
RELEVANCY SCORE 62.4

I've got a corrupted file in my CD write folder that I have tried to delete every way I can think of...without success. So every time I log on to the computer a message pops up that says I have files that are ready to be written to a CD. The file and the folder it is contained in are also part of every CD write job I set up since they always in the CD write folder.

Does anyone know how to purge corrupted file from the CD write folder? Not a major problem, but after several months, it is driving me nuts.

Pete1231
 

A:Undeletable file in CD write folder

Read other 9 answers
RELEVANCY SCORE 62.4

OK non PC techie here. My system barely comes up so it can access C drive but useless - can't even logon. I DO NOT have a recovery CD that I can find from Sony Vaio or Norton - nor does it look like I have the original windows XP CD

I have been running Norton faithfully and Spybot (no execution in last few days) have been suspecting a trojan horse giving glimpses of problems but nothing finds it. SUpposed NO ONE in the family opens emails with weird attachments

History:
- System running slow - my 15 year old son did an end process on some things, 2 of which were called opware32 and opware16 (don't know if that is related)
- he rebooted and tried to logon got a number of weird msgs - one of which he remembers saying something about not finding a valid license
- I managed to logon after a couple reboots etc. one msg was a device not found - re-establish connect. the only that had been disconnected by him was printer, so I plugged it back
- had to re-boot - Started going into file properties of C because low on space and started deleting personal files because that has sped it up before
- suddenly file properties could not see the size of content of disk drives or folder - showed 0 megs size (directory trashed?)
- reboot and logon to me - erros "window script host" then only red X and OK in the error box itself
- same time error "activation.exe - application error -then only red X and OK in the error box itself
-clicked OK - error "your installati... Read more

A:HELP - OS XP - error folder C:\windows\system 32 does not exist - I'm hosed!

Read other 12 answers
RELEVANCY SCORE 62.4

Copying and installing data files from old notebook 98se to new notebook with Vista home premium using my wireless. Going well so far with those files that are going into Documents.

However, certain files (Outlook pst) and folders I can't get to, because as I get down the C: path say to User then me the next folder does not show. Seems I am only able to see certain folders and files to a certain level.

Looking at properties in C under tab Security I suspect I could change me as User to "Full Control" from read/execute/list and this should have make all my files visible to me??

But, I can see administrators already have Full Control and I am listed under the name I gave during setup----can I work in there as then I would not have to modify my user settings? How do I access that or is it better to just change my user controls or is there a third way to see all folders.
thanks,
G
 

A:Solved: file and folder access?

It sounds like you're not set to show hidden files/folders. Enable this by hitting the <ALT> key when viewing whatever folder to get the old menus, then Tools - Folder Options - View - Show Hidden Files and Folders.
 

Read other 2 answers
RELEVANCY SCORE 62.4

Hi...

Running Access 2003; & when I go to 'File' on my Command Bar, there are a few old databases in the dropdown menu that are long gone from my system. I know this as an anal type question...but I want to get rid of everything in that menu I no longer use.

Can someone please explain how?

Thanks,

mark4man
 

A:Solved: Access 2003...Remove Old File Dropdown Entries ???

Read other 6 answers
RELEVANCY SCORE 62.4

My document folder in my windows xp laptop gives the mesage as Access denied or write protected. This was caused whrn I changed my logon password wusinf Manage your passpord from My desktop, Manage, User and Groups then change password.
Is ther anyway I can un encrpt and make my folder usable. I am unable to backup or restore from previous backup.
Need some help
SM

A:My Document Folder Access denied / write protected

Try this:

http://support.microsoft.com/kb/308421

You have to be logged in as an administrator.

Read other 5 answers
RELEVANCY SCORE 62.4

Hello guys,

I am admin on the computer but somehow (may be via group policy) I can not write/delete to my USB. By the way this is a corporate laptop. I tried couple of ways to fix it but couldn't manage. Is there a way to fix this issue?

Thanks in advance and best regards.

Read other answers
RELEVANCY SCORE 62.4

Hi

can i block a program to write access to a specific folder ?
the folder is c:\Users\User\AppData\Local\Adobe\Lightroom\Caches\Video\
i use lightoom i import only photos

but lightoom find every video in my pc and fill this folde of video cache!
i don't have video in my catalog

can i block lightroom to have access to this folder?

thanks

A:can i block a program to write access to a specific folder ?

This may sound stupid, but what happens if you just delete that \Video\ folder? Does it get recerated? If not, that may be the easy fix. If not, you can try changing permissions for that one folder.

Permissions - Allow or Deny Users and Groups

A Guy

Read other 3 answers
RELEVANCY SCORE 62.4

Hello,

I have a application that work with Hardware lock and after run try, to write file "HLBSrvc.dll" to system32 folder, but user work with this application is Standard user, Show message [Cannot create file "c:\windows\system32\HLBSrvc.dll".
Access is denied]
Also I can not change permission system32 for this user.
Now how can i access to my user to access system32 folder without change his to Administrator.
Please guide me
Thanking you
Soks Sia
 

Read other answers
RELEVANCY SCORE 62

Hi Guys,

I'm trying to start a migration of all mailboxes to an exchange 2010 server from an exchange 2003 server,
I have done pretty much all the setup and migrated one of the mailboxes.

My issue is that i cannot get mail to pass between exchange 2003 and exchange 2010 mailboxes.

Now I am assuming this is a connector issue but cannot see a way to setup the correct connectors via the system manager within exchange 2003.
(Still wanting to use the 2003 server as main server for incomming and outgoing mail but just want to also be able to transfer any all incomming and outgoing mail from the 2010 server - through the 2003 server)

I did the above a while ago when moving to a new exchange 2003 server just by making sure the connectors were in place to route mail between the 2 servers, i.e. using the main server as a local bridgehead and smarthost on the connector from the new server)

I cannot seem to select the new exchange 2010 server as a local bridgehead though via system manager on exchange 2003 - it just doesn't appear as an option.

Any help would be most appreciated, even if i have to go back and do bits of my setup from scratch as long as i can get this working.

Do i need to setup the connectors on the exchange 2010 server? I have partially tried this but still cannot route mail between the servers.
(also just to note, internal mail is also not working between the exchange 2003 and 2010 server)
 

A:Solved: Exchange 2010-2003 co-exist issue

Solved it guys.
Just to let you know.
Had to setup a bi-directional routing group connector on system manager within exchange 2003 server for routing to and from exchange server 2010.

and make sure that the exchange 2003 server was accepting incoming messages from the ip address of the exchange 2010 server.

done and dusted now yay.
 

Read other 1 answers
RELEVANCY SCORE 62

I have a 64 bit Windows 7 computer and a large number of files on old zip 100 disks, which I would love to have access to again. My 100 drive is a USB drive.

Iomega's site says the following about that qualified for 32-bit Windows 7: "Zip? Drives: Zip? 100MB, 250MB or 750MB USB, ATAPI, FireWire or SCSI drives should work with native Windows 7 drivers. IomegaWare software does NOT work with Windows 7, so features supplied by IomegaWare will not be available."
"native" - so Windows 7 can simply accept the zip drive? that seems very wrong --- Furthermore Iomega can simply be referring to current Zip drives.
I am sorry my level of knowledge of computing is much below those of you on this site, (but I am learning! perhaps not apparent here) but I have been unable to find clear help on the web...
I would like to accomplish this by myself, but with any of your feedback, it may be clear I need to take the drive to a computer repair store. I am hesitant to just give it a go with further info for fear something will go quite wrong with my computer.
I appreciate your help on behalf of quite the novice. Thanks.

A:Does driver exist to enable file access from old Iomega zip 100 drive?

Since Iomega supported both 32 and 64 versions of Vista I'd say if your drive is not recognized by Windows 7 native drivers you may want to explore this https://iomega-na-en.custhelp.com/cg...b2RzPTEsMTkmcF

and try the Vista drivers in compatibility mode.

Read other 6 answers
RELEVANCY SCORE 62

Hi all,

I need to execute the Windows command:

metaflac --dont-use-padding --remove --block-type="PADDING" Filename.flac

For every file in a folder, including every file in the subfolders! (Two levels of subfolders.) The file name extension is as mentioned above .flac.

I understand a batch file is the best way to accomplish this, but what should it contain?

Many thanks!
 

A:How do I write a batch file for all files in a folder?

Read other 6 answers
RELEVANCY SCORE 61.6

Not sure what's going on here or how to fix it. I've tried every workaround I can find, and nothing works. It's a folder in my Steam directory, and even when I try to manipulate it as an administrator I can't even read access it. I also can't see permissions
on it, so I can't change those or take ownership, either.

I really need to fix this. Any ideas?

Read other answers
RELEVANCY SCORE 61.2

I am running Vista Basic SP1 on my laptop. I created a new folder called Combined Music under Desktop / Chuck. Based on suggestions in other TSG threads, I have been using TagScanner 5.0 to rename MP3 files in other folders on the same computer. I then tried to use TagScanner to copy a set of files from one of the other folders to the empty Combined Music such that it would create sub-folders based on the the artist name and album name. Then each sub-folder would have the selected tracks from that particular album.

As soon as I clicked the Rename button, TagScanner spit out rename failure error messages for all the tracks. When I opened the Combined Music folder in Windows Explorer, I could see all or most of the newly created album folders but they were all empty. I figured I would start over. I right clicked on the Combined Music folder and selected "Delete". I got a confirmation pop-up asking if I wanted to put the content in the recycle bin. When I clicked Yes, I got an "Item Not Found" Error Message that said, "This is no longer located in C:\Users\Chuck" and the folder was still there. I then tried holding down the shift key while selecting "Delete". I got a pop-up asking to confirm the permanent deletion. The pop-up closed when I selected "yes" and then nothing happened. The same things happen for any of the sub-folders thatwere created by TagScanner.

I was able to rename the folder with no problem but still couldn�... Read more

A:Solved: Can't Delete Folder Because it Does Not Exist?

i dont know if this willl help, but i know of a program that is made to delete files when you get the error messages such as

Cannot delete file: Access is denied
There has been a sharing violation.
The source or destination file may be in use.
The file is in use by another program or user.
Make sure the disk is not full or write-protected and that the file is not currently in use.

it removes any handle that any other programs may have on a file or folder so if it is a program that is causing the error message it should work

the program is called Unlocker the website for download is HERE
 

Read other 3 answers
RELEVANCY SCORE 61.2

Hi guys, new to the forum but have lurked for a while. I don't know much about computers, just the basics. Anyways, I recently created two file folders to put some of my personal photos in. I gave the file folders long names, roughly 110 characters, to specify where the photos were taken, etc.

Now I can not access those folders, and one of them I literally created only 5 minutes ago. It won't let me rename it, delete it, open it, or anything really. When I right click on it, it only gives me 6 options, whereas functioning folders give me 19 options when I right click on them. I have folders in the same section that work perfectly, but they have shorter file names. I was thinking my long file names on the two non-working folders is causing me this problem. I don't want to delete them those folders, I really need to access them since I do not have a backup of those photos.

Anyone know how to gain access to these folders? I thought maybe I need to find a way to rename it, or maybe something else. Please help me, I will be forever grateful.

A:[SOLVED] New File Folder Created- Long Name- Now Can't Access It

Hi,

A rather old thread but I think the info still stands. See if it helps;

Windows XP won't recognize files with long file names

Read other 3 answers
RELEVANCY SCORE 61.2

Hi,We just deleted a part of a video by accident. We found the photorec and tried to recover the file. It all went well until we came to the step where it needed to save the recovered file to a certain folder. According to the discussion I found, it might be a good idea to run hjt. Here goes... (not sure if this is exactly what you need?)Would really appreciate the help! Thanks in advanceLogfile of Trend Micro HijackThis v2.0.4Scan saved at 01:21:14, on 19.08.2012Platform: Windows 7 SP1 (WinNT 6.00.3505)MSIE: Internet Explorer v9.00 (9.00.8112.16421)Boot mode: NormalRunning processes:C:\Windows\system32\taskhost.exeC:\Windows\Explorer.EXEC:\Windows\system32\Dwm.exeC:\Program Files\HP\HP Software Update\hpwuschd2.exeC:\Program Files\RocketDock\RocketDock.exeC:\Program Files\HP\HP Photosmart 5510 series\Bin\ScanToPCActivationApp.exeC:\Program Files\HP\HP Photosmart 5510 series\Bin\HPNetworkCommunicator.exeC:\Program Files\Internet Explorer\iexplore.exeC:\Program Files\Internet Explorer\iexplore.exeC:\Windows\system32\Macromed\Flash\FlashUtil32_11_3_300_271_ActiveX.exeC:\Program Files\Internet Explorer\iexplore.exeC:\Users\Beverly\Desktop\HijackThis.exeC:\Windows\system32\SearchFilterHost.exeR1 - HKCU\Software\Microsoft\Internet Explo... Read more

A:Photorec: "unable to create new folder...due to antivirus blocking write access"

Hello and welcome to Bleeping Computer! I am HelpBot: an automated program designed to help the Bleeping Computer Staff better assist you! This message contains very important information, so please read through all of it before doing anything. We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here. To help Bleeping Computer better assist you please perform the following steps:*************************************************** In order to continue receiving help at BleepingComputer.com, YOU MUST tell me if you still need help or if your issue has already been resolved on your own or through another resource! To tell me this, please click on the following link and follow the instructions there.CLICK THIS LINK >>> http://www.bleepingcomputer.com/logreply/465734 <<< CLICK THIS LINK If you no longer need help, then all you needed to do was the previous instructions of telling me so. You can skip the rest of this post. If you do need help please continue with Step 2 below.*************************************************** If you still need help, I would like you to post a Reply to this topic (click the "Add Reply" button in the lo... Read more

Read other 2 answers
RELEVANCY SCORE 60.8

So, I barely know how to state this question, which is probably not a good sign.

I am working on a self-referencing constraint and want to prevent reciprocal values. Say, for example, my relations were thus:
Code:

[SIZE="3"]`tbl_fruits`
fruit_name | fruit_color | fruit_taste
=======================================
orange | orange | sour
lemon | yellow | sour
lime | green | sour
apple | red | sweet
...

`tbl_fruit_associations`
fruit_name | fruit_like
========================
orange | lemon
orange | lime
lime | lemon
[COLOR="Red"]lemon | lime[/COLOR][/SIZE]

I want the constraint to prevent the last record in `tbl_fruit_associations` (the red one) as spurious. The logic in question is the commutative property of associated pairs.

I'd prefer to use a DB solution rather than an application layer solution, if that can be done. Any ideas?

Thanks for input,
chris

[edit]
I meant "self-referencing" not "self-reflexive."
[/edit]
 

A:Solved: How to avoid spurious records in Access 2010

Sorry to bump; looks like I should have done more research about the new features in Office 2007/2010. Apparently Access almost supports triggers these days, only they're called data macros. I was able to accomplish what I needed by creating a data macro like so:
Code:

[SIZE="3"][b]Look Up A Record In[/b] tbl_fruit_associations
[b]Where Condition =[/b]([t_f_a].[fruit_like]=[tbl_fruit_associations].[fruit_name]) And
([t_f_a].[fruit_name]=[tbl_fruit_associations].[fruit_like])
[b]Alias[/b] t_f_a

[b]RaiseError[/b]
Error Number 1
Error Description The fruit are already associated.[/SIZE]

Having only just discovered the feature, I can only guess at this point, but I believe the crux of this is the Alias property: since the table is self-referencing, the alias is necessary to distinguish the macro query (i.e. "lookup") from the real table.

Anyway, in layman's terms, here is what happens:
User attempts to create a new record by providing values for the fruit_name and fruit_like fields
Access does not immediately create the new record
Access searches the table for any record where fruit_name has the proposed fruit_like value and fruit_like has the proposed fruit_name value
If such a record is found, Access raises an error with a meaningful message and prevents the new record from being created
Of course, I don't have to worry about the possibility of strictly duplicate r... Read more

Read other 1 answers
RELEVANCY SCORE 60.8

Hello folks
First post here: I picked up some malware or adware a few weeks back, whick Norton AV 2005 wasn't able to get rid of. The message was this:

Source: mmxateam.exe
Description: The compressed file mmxateam.exe within C:\Documents and Settings\LocalService\Local Settings\Temporary Internet Files\Content.IE5\JHG70DPF\yes[1].x is a Adware threat.

There are two others like it, apparently in the same folder. However, when I open my Docs and Settings folder, the subfolder 'LocalService' doesn't exist. I have checked on the adware and tried to remove it according to NAV's instructions, but the reg keys, etc. are invalid(aren't present). I am not sure how to proceed at this point.

I have peremptorily included the requisite hijackthis log...

Logfile of HijackThis v1.99.1
Scan saved at 1:56:59 PM, on 11/28/2005
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Webroot\Spy Sweeper\WRSSSDK.exe
C:\WINDOWS\Explorer.EXE
C:\hijackthis\HijackThis.exe

R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://qca7.hpwis.com/
R0 - HKLM\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.excite.com
O2 - BHO: AcroIEHlprObj Class - {06849E9F-C8D7-4D59-B8... Read more

A:Solved: Folder with Malware in it doesn't seem to exist

Read other 11 answers
RELEVANCY SCORE 60.4

I know this must be possible, but for some reason I just can't figure it out.
I have a file path that I calculate - what I want to know is, if in that folder there exists a file with the word minutes in the name.
What I have is an application that has to keep track of the various committee and faculty meetings at the university. From the meeting dates, I create a folder. 10 days after the meeting, the committee secretary has to have posted the minutes or I need to send her a reminder. To date this has all been done manually. I want to be able to read in the files in the folder and if one of them contains the word minutes or Minutes in the name, then mark the minutes as done on my database (prefarably with the date the file was put in the folder, if that can't be done then just a Done) If a file with the word minutes or Minutes in the file name does not appear, I want to send an email to the committee secretary to remind her to post the minutes. This I know how to do via vb, and I have her email against the committee in my Access DB. How do I 'read' or put those files fron the folder into an array so that I can interrogate the name?
 

A:Solved: 'reading' file path and folder names in vb from Access

Read other 16 answers
RELEVANCY SCORE 60.4

Having a frequently occurring problem when trying to save a Thesis, the Autosave cannot update and I get the message 'the disk full trying write C:"error
I am using office2003'.
There is 26.1 GB free space on a 80GB Hard disk
Dell Latitude D820
1GB RAM
Windows XP Professional SP 3
 
I can't
***save the file to another flash drive,
***renamed as another file
***nor update existing file!!!
 
your earliest response who be most helpful.
 
Here below is the combofix log on the system
 
===============================COMBOFIX LOG REPORT =========================
 
ComboFix 13-06-28.01 - Administrator 28/06/2013   9:26.4.2 - x86
Microsoft Windows XP Professional  5.1.2600.3.1252.1.1033.18.1014.342 [GMT -5:00]
Running from: E:\ComboFix.exe
AV: avast! Antivirus *Disabled/Updated* {7591DB91-41F0-48A3-B128-1A293FD8233D}
.
.
(((((((((((((((((((((((((((((((((((((((   Other Deletions   )))))))))))))))))))))))))))))))))))))))))))))))))
.
.
c:\documents and settings\All Users\Application Data\TEMP
c:\windows\wininit.ini
.
.
(((((((((((((((((((((((((   Files Created from 2013-05-28 to 2013-06-28  )))))))))))))))))))))))))))))))
.
.
2013-06-28 14:17 . 2013-06-28 14:23 -------- d-----w- C:\32788R22FWJFW
2013-06-14 10:58 . 2013-06-14 11:01 -------- d-sh--w- c:\documents and settings\TEMP
.
.
.
((((((((((((((((((((((((((((((((((((((((   Find3M Report   ))))))))))))))))))))))))))))))))))))))))))))))))))))
.
2013-06-12 14:21 . 2... Read more

A:"The disk full trying write to C:" error in office 2003

Could be several things -- your hard drive c: is full; you are trying to save to a folder for which you don't have write permissions; your temporary folder is full; or the default Word template is corrupt.
Try the diagnostics listed here to narrow it down:
http://support.microsoft.com/kb/224031

Read other 1 answers
RELEVANCY SCORE 60.4

Hi all,

Im not sure if anyone else has had this problem or noticed it, but I have enabled the GPO prevent users from adding files to the root of thier users files folder on our network as we use folder re-directs to my documents which in theory should keep everything tidy. This works up until a point, if I try and browse to the location and create a file I cant. If I try and drag a file into that location I cant, but as soon as I try to save as it lets me - any ideas why this would be?

A:Disable write access to personal folder (root location of user area)

It only affects Windows Explorer not applications using the win32 file APIs. Which is why it resides within the "Windows Explorer" group policy tree.

Read other 2 answers
RELEVANCY SCORE 60.4

Hello,

Several years ago I created a database in Access 2003. I recently converted it to 2007. However, since then it seems I no longer have access to design view, so I can't make any changes. Any suggestions? Thanks.
 

A:Solved: Error in conversion from Access 2003 to 2007

Read other 6 answers
RELEVANCY SCORE 60.4

Hi I use an access 2000 db on machines running mainly access 2003 but also occassionally acccess 2007. I enter the data via a form with value lists. All of a sudden the first row of eaach of the value lists have become underlined and can not be selected - I can select the lower items in the lists but not the first.

Have tried repairing & copying the database into another new database but the problem reccurs in the form. Other forms work okay... is there an error or have i inadvertently chamged something

Please help.

Steven
 

A:Solved: Sudden error on access 2003 form

Read other 10 answers
RELEVANCY SCORE 60.4

When I try to add a new record, I am getting the following error message "Run-Time error 94 - Invalid Use of Null".

Here are the line of codes debug is highlighting...
Code:
x = Me.cboInfoID.Value
old = Me.cboInfoID.Column(1)

 

A:Solved: Access 2003 Null Error Message

Read other 10 answers
RELEVANCY SCORE 60.4

Can anybody tell me what a Run-time Error '2109' is?
It says, "There is no field named "PP-0123" in the current record."

I don't understand. "PP-0123" is not a field name. Help me guys. Need you help again.
--pixie
 

A:Solved: Access 2003 - Run-time Error '2109'

Read other 8 answers
RELEVANCY SCORE 59.6

Hi,

We are using windows 7 and all our clients are under the domain. one of our dept member requested me to create a share folder in his pc in which user can create edit modify any of file but not to delete any of file.
So is it possible or not???
Please help me out this issue.
Thanks


Rakesh Kumar

Read other answers
RELEVANCY SCORE 59.6

I have a search form where i have a text box that has a input mask which is the same as the table i am searching in. When i go to get the phone number from the txt box and put it as filer for my subform, it says missing operator. This is what is in my txt box (615) 777-7777 and in my table looks the same way but is not searching for it correctly. please help
 

A:Solved: Access 2003 error when trying to filter for phone number

Read other 16 answers
RELEVANCY SCORE 59.6

I have the following code:
If IsNull(Me!subfrmBrImgProc.txtBrProcDt) Then

MsgBox "The Procedure Date may not be empty." _
& vbCrLf & vbCrLf & "Please enter the Procedure Date", _
buttons:=vbOKOnly, title:="Blitz 10/2009"
Resume ExitProcedure

When I execute the code, I get the 438 error on the first line.

This strikes me as strange, since when I go to the Immediate Window I get the following:

? isnull(me!subfrmBrImgProc!txtBrProcDt)
True

TIA for your suggestions

Terry
 

A:Solved: access 2003 error 438 object doesn't support...

I just noticed that I had
"isnull(me!subfrmBrImgProc.txtBrProcDt)" in the code and
"isnull(me!subfrmBrImgProc!txtBrProcDt)"

Made all the difference in the world.
 

Read other 2 answers
RELEVANCY SCORE 59.6

Windows XPSP2, Office 2003, Office 2007 Comp. Pack, on company LAN. Trying to create a new Access database, received "Cannot open a database created with a previous version of your application." Repaired Office, no luck. Deleted and reinstalled (using ZAP to remove any remnants) and now Access will not open at all. Any suggestions?
 

A:Solved: Could not create Access 2003 db; error; reloaded; now won't open

Read other 7 answers
RELEVANCY SCORE 59.6

i using windows 7 professional , when i use mycompute and navigate throws it. i just click folder in iy. then new folder navigation window open. how to avoid this . help me. Thank you.

A:how to avoid new folder creation when i double click folder in window

In Explorer Folder Options make sure "Launch folder windows in a separate process" in not checked. If you uncheck it make sure to hit "Apply to all Folders" or it will only change the setting for the folder you have open.

Read other 1 answers