I've got a fairly simple db with only 4 tables. Only two are linked by a field called E58# with a one to many relationship. In the "many" table I want to...

Hello, I see that the BE database keep bigger in size. My question is if we setup the option to be " Compact on Close" on each Front End of the users, does...

I have split my database. I have four users that will be using the front end. I've read that each user should have the front end on their local systems. What...

I inherited a 10,000 record EXCEL worksheet that I will convert to an ACCESS table. The EXCEL worksheet contains about 10,000 lines (each line is one record)...

Hi, Please help...I get "unknown" error when ever I try to open a table either in design or open mode. It does allow me to create a table but does not open it.

Just starting out in access. I am trying to create a database for work that shows: 1. Events (upcoming and past) 2. Attendees I also do travel arrangements...

I split the db today into a fe/be because of the size. It did accomplish my goal of reducing the size of the be on the network, however, the front-end is...

I would like some experts-advice ... I have: Developed a database in lotus-approach (97), wich is alive and kicking. Unfortunaly, this application runs only...

Hi there, Does anyone know how to make the tab order go vertically along columns in a multiple entry form? It seems like that tabs will always goes along...

I need to revise the structure of a data base application that I have developed, so that the application can be "validated". One part is that I need a way to...

HI I apology since this may not be the best group to ask this question: I have excel spreadsheets that I am trying import into tables to be able to utilize...

I know how to make a column prevent duplicate values with an index; however, I have a column where many values are null which is OK, but I can't use an index...

Hello, I have been importing .csv files into Access using a Macro which works great. Unfortunately, the task has become more intense. I now have 20-50 csv...

I have imported ASCII data into an Access table. All of the fields show a 255 size. None of the data being imported is larger than 50 in field size. For...

Sometimes when I close Access 2007 and re-open a strange field has been added and my previous field information is gone and replaced with numbers. When I go...

Sorry for the previous post - it had two post mixed up... I have a database on Projects. I have PROJECTS that can have many participants, and PERSONS that...

Hi, I am wondering about proper or accepted practise for ID'ing records in a relational database. My question is this... If I have a table with a unique...

Hello, I tried to quickly scan most of the posts out here but found bits and pieces of what I needed to ask. I'm curious if anyone knows about some kind of...

Dear all, Could anybody tell me that how I can allow user to edit BUT NOT delete the records in a view? I know there are only 3 options when opening a...

Hi, I'm designing a new table to replace an existing table that is populated with data for the current application. The old table uses an AutoNumber...