We are getting the above message and performance goes to nothing on the network. Monitoring shows it taking almost all resources. This is an Access database running as an .mdb with Access secu...
I'm trying to edit an existing database we have here. The database contains all our donators, addresses, etc and is used to create mailing labels for thank yous, donations, etc. There are fo...
Access 2007 database. Linked tables to backend SQL Server 2008 server. Running under Terminal Services on Server 2008 x64. Each user has their own copy of the frontend mdb. This message ha...
Can someone please help me in converting the 'arg1' field from hex to ascii or simple text in an Access database query. I have attached the Excel file that contains the data output from a MyS...
HI,
We are running into an error that states that there is an architecture mismatch. We are receiving the following error in the address bar when trying to connect to the local machine i.e....
Hello,
I'm really new in Access and i'm trying to make Hardware&Mobile Pohones and Blackberry inventory. I have clear idea how DB should works but i need your know-how to complete my ideas....
Hi Experts.
I have a query, xtab, in which I need to multiply each row with -1.
For instance, for Account Group: 3000, I need to display for Company A: 4158 and for Company B 5045 (inste...
I have a two Access 2003 .mdb databases that are giving me problems in Access 2007 (On Vista Ultimate) with freezing when in a table (spreadsheet) view. In one of those databases, the freeze h...
I am in the process of creating a database in access using 2007. I know in 2003 Only one person can be in the database updating tables through forms etc........ Is there a way I can set up m...
I was self-taught Access 2007 this year, and then I designed a database that our office has been using daily for several months. I am curious about how much Access will be able to handle, bec...
Hi
I have been working on it day and night , cant get it to show progress correctly. I have a status bar which is not showing the increment in progress as the sub operates till its end. C...
hi experts,
Ive got a few a few tables (fields) that need to have the text alignment centred.. how do i do this?
I've observed that the built-in function Nz() is not recognized by Access when you try to use it in table validation rule properties, yet the IIf() function is. Which functions are valid for t...
I have a Access database with some linked tables to a backend Oracle database. I need to extract all of the data from one of the tables and store it somewhere. I can create the query to select...
what i want to do is make the (row )height of the colum header bigger in an Access table
by column header i mean the text holder at the top of a column [the field name } in datashee...
I created a database application that has 3 tables that are relasted to the main table. The CUSTOMERS table has an ID field that is used in linked tables HISTORY, QUOTES, and NOTES.
When I...
Hi
There is a need to identify all the causes that have the potential to impact the performance of an applications built upon ASp.Net / Forms / VB etc using oracle 9i at the backend. The user...
Afternoon,
I have 2 tables which I wish to link on in order to update one of the tables. One table has the column "ACode" as a number, the other has "Answer" as text.
Before this query is ...
I have created a database to store all of our internal project numbers. Previously all the info was in an Excel spreadsheet so I simply imported the data, no problem right? Wrong. Our job n...
Hi Experts,
I am trying to compute the wait time in seconds for the users when access tries to do a specific process. Wait time can be more than 60 secnods but everytime the wait time has to ...
I put this in the Task Scheduler.
Action:= Start A Program
Program/Script := CScript/WScript, CScript, WScript.....I tried all 3 seperated individually
Argument ponted := "C:\Users\Rob Bur...
I have an Access 2003 DB app and one of the forms inside has 3 toggle buttons to switch between record viewing states: Active, Inactive & All
In the properties of the Toggle Buttons in Acc...
Hi
I am trying to group an Access Report into groups and I am not having much luck in succeeding.
I had asked for some help here on EE and an expert was kind enough to help me out with m...
I am trying to design what I would consider a "basic" LMS.
OOTB solutions will likely not work without significant modification/customization to the point that actually building a basic frame...
I need to create a field of type AutoNum, but when i try I recieve the error "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" . How can i fix this error without ed...
