Search results

I have a user who more than occasionally gets the following message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values...

We are having some sort of network problem. A table in its own separate database file is stating that: (paraphrasing) "This file is in use. Close the file and try again." but the file is not in use. There is no locking file open, and furthermore, multiple users have used the file...

We have a network with about 12 users. We have no server, but are using a NAS as our file source. We have the data in a back end database on the NAS, and each user has a version of the programming on a front end copy on his own workstation. Several of the users are getting the above...

When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker? I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get...

I've started distributing a package to multiple customers. If they don't have MS Access 2010 I am using Access runtime - something I have never worked with before. One user reports that he cannot cut and paste in runtime. I've tried it myself and he is right. Is this a caste in bronze...

10-15 years ago I integrated an Explorer type form into an Access 95 database. But I copied the code into an Access 2010 database and that program just didn't like it. Anyone have an easy way to search for a file inside Access? I'm trying to link photos to certain documents. I have the...

On a workstation one of my customers uses (under MS Access 2007, Windows 7) When my access application is turned on, they get the following message: Compatibility Warning: This database uses features which may be incompatible with the current version of (my database name). The database is...

I just converted a program to Access 2007/2010 format. It's a program that started in Access 95 so it is very mature. However, after the conversion, field sizes in many instances have been too small for the size of the data. Instead I have forms and reports with ##### printing instead of the...

I remember in earlier versions of MS Access (95 & 2000), a user could corrupt a table with a memo field by using the scroll wheel of the mouse and essentially scrolling right out of the record. This is in a bound form with the cycle property set as Current Record. The problem appeared to be...

Sometimes when making just a minor change in an Access 2007 or 2010 program, the system will freeze for minutes at a time - up to 5 to 10 minutes with the "Microsoft Access Not Responding" message What could be causing this problem? My FE database in this case is about 40Mb. I sometimes...

sorry to persist, but I'm under the gun. I am trying to copy a pdf file between 2 directories. I am using xCopy, although I'm not married to it. When I build my copy statement based upon various parameters, it looks something like this: xCopy C:\PDF995\OUTPUT\*.* P:\Billing\12973\44137.pdf...

I'm starting to automatically save PDF copies of certain reports in predetermined locations. I need to copy a file to a particular directory (based upon various criteria), but if the directory does not exist, I want to create the directory on the fly first. Otherwise I will just proceed...

In the distant past I've written .adp programs that linked to SQL Server 2000 and they were very nice but kinda hard to maintain from a distance. Plus, at that time SQL Server 2000 required an actual File Server, such as Windows 2000 Server or 2003 Server, which was kinda pricy and was outside...

Circumstance: A database shared by 2 workstations. the Back End is on a shared Network drive, the front ends reside on each workstation. I'm told that when a user is entering data on one workstation and someone signs into the program on the other workstation, bad things happen. Tonight there...

I need to insert a path to an image object to display a picture on an Access form. All of the pictures will be stored in a network directory. I want to use MS Explorer to allow the user to choose the picture that goes with the image object - unless there is a better way to do it. I've used...

I started as in IBM'er in 1969. --- began on wired board accounting machines, but became a proficient RPG/RPG II programmer with the System 360/20, System/3 M8-10 -12-15, System/32 (POS), System/34 and System/36. Changed over to PC's in the early '80s using various forms of Basic. I wrote my...