With the need to create a relationship between tables, I am wondering if it is okay to link more than one table's Primary field with the main tables Primary...

I've recently converted a database created with Access97 to Access2002 version. The problem is when I open up one of the forms I created before, a window pops...

Before split my DB, I can open one of my tables. But after splitted my DB,I couldn't open that table from my BE DB. The warning message is "Property value is...

I have down loaded an update. When I try to execute the file I get this message. Jet35sp3.exe is not a valid Win32 application. Any ideas?? Thanks

i have 2 columns in my report. but i am not able to get page header 2 times. how to get the same page header for multicolumns?

I have a table of employes set up with an autonumber field as the primary key. Someone deleted one of the members. I'm would like to restore the member with...

I inherited a perl CGI application that uses the integer primary key in the Microsoft Access database fabricate as the file name of flat text file to hold...

i try to create a switchboard through the switchboard manager for my database. the problem is that i cannot add more than 8 items on a page. can i troubleshoot...

I have a database that has active & inactive names I cannot separate them. Is there a way to color the row that is inactive. I have tried but the whole...

I have a field of Autonumber in my table i would like to start at 50000 so i use the method of appending a record with the value that i want the auto number to...

I'll preface by saying I'm not sure where to best post this, queries or tabledesign. For a study that is being conducted, I have a test table that holds 4...

Is there any way to increase the Access Index Limitation? Number of indexes in a table 32; how to increase this value

Is there any way to increase the Access Index Limitation? Number of indexes in a table 32; how to increase this value

if i receive a string of data and AAABBBCCCDDD and after every 3rd letter, i want to insert a dash, how would i go about doing that? sometimes the data will...

I have a Products table containing the usual product fields such as a product number, description, and so on w/ an AutoNumber set as the primary key. I'm...

I am having an MS Access database and when I try to open it I get the error: Microsoft Jet database engine stopped the process because you and another user are...

I am trying to write an if statement to open a form based on a value in a table. In other words if rates = 0 then open form1 else open form2. Is there a way...

I need to create a database that will store individual resident assessments. One resident will have more than one assess over time. The score decides what...

Using Access 2000. I have applied a filter to a table with good results. If I apply another filter while in a filterd view am I filtering on the results of...