I have a user without Access installed. They need to view an Access 2003 databse. Not sure what to do and I don't want to install Access.
Sample Project ----some one who already has Forms,Switchboard,Reoirts,Query,tables
to have a idea
I haven't touched Access in a long time and need some direction for help. I am using Access 2007. Here is what I have.
TableA: Main Information
TabelB: Multiple entries that links to Table...
I've created a form for users to Search/Edit records they create. I want to allow them to search for records using the Record ID, Sales Engineer, or Customer Name. I have the first option (ID...
Hello Experts -
Our company is getting a number of new machines with Access 2007. However, most of our company has Acess 2003.
Is it possible to design and build a database in 2007, bu...
Strange happenings this morning when 2 users (including myself) received a prompt asking if they want to make Outlook their default e-mail client. There has been no changes to the system and O...
I just wanted to ask how I can set a default value in MS Access that is equat to another column in the same row. Also, I want to set another column's default value to be 2 higher than another...
I have upgraded to Microsoft Office 2007. I have a program that has been migrated up since 0ffice 97. It worked fine in access 2000.
Now when I open the database I get an error message: "your...
Hello,
We have Windows server 2008, MOSS 2007 deployed and the search in portal site was working perfectly but i always had error in my event viewer (ID 6398, 6482, 7076) the search stopped...
We have 2 linked Access database files. We can open the first one correctly, but get error message when openning the other one. "The Microsoft Jet database engine could not find the object 'MS...
I have one table called tblGood. And it has primary column named goodId.
How should I set the primary column to be auto-increment, and the value starting from 1 in design view of table of MS...
I have a quiz Q & A database (MS Access), where members can ask and answer questions and also vote on other answers and questions.
sample data and table structure / fields:
------------
...
Can someone please combine these 4 IF statement that i use currently in Access 2003 query window to one SINGLE Iff statement please.
IIf([16Feb_Jetbase_2_XCOLL]!EBK_MATURITY<#16/02/2009# ...
I would like to make an access 2007 file into an exe file so that a client does not need to have access installed on their system to use the application. How do I go about doing this?
Hi,
I understand the basic concept of an AutoExec Macro and how to perform simple tasks like opening forms. However, I would like to essentially hide everything from the user except for th...
I am having a password protected Database in msaccess. what i need is to remove protection from this database. I want this same database which is not password protected. how can i achieve it.
hi,
I have got a table which has an Items column which is the (auto number) primary key. I want to create a validation rule for the Issues table in such a way so that when the user enter a ...
Hi,
I am using Access 2003 and my database has 1 table, 30 colums. I keep getting the error message "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" when I want to ...
I want to reset the autonumber field in a table so that the current values are replaced counting up from 1. Can this be done?
In Access 2003 I want to include a wildcard in a parameter query. So for instance, in a field called defect, some of the records show Seatbelt, and others will show Seatbelt, door and another ...
Does anyone know why my Menu bar toolbar is missing from my database - both the file menu at top of screen and on the toolbar customize list.
I have reinstalled Access - Repaired and Healed...
I have a DB I am importing and apparently the error I am getting is
"The number of values exceeds the column limit in Access" that is the error that I understand is my problem. Not what Acces...
I have created an Microsoft Access 2003 database. It includes Tables, Queries, Forms, Reports, and Macros. I want to be able to give this database to a a select group of people that don't ha...
I recently developed an Access database at my company with Access 2007. Developing the database and all of the forms, etc was problem free until I split my database. Since that point, problems...
I have developed an MS Access app which has been successfully implemented on several machines as a MS Access runtime 2007 .accdr install. It successfully runs on combinations of XP and Vista a...
