I currently have a table (t_Items) which has a multiple value field (ItemRequire). I am going to break the multiple value field into a seperate related...

Please clarify: A query is simply an SQL statement. However, it is an SQL statement that is 'public'...I mean public in the sense that you could have...

I am planning on splitting my database and putting the backend on a shared drive. Though this is a very small application, given that there will be more...

I have created an invoice table (t_PCO) with numerous related tables (t_PCOEquipment), (t_PCOLaborHours), (t_PCOMaterial). Often these invoices are...

In general are multivalue fields a bad idea to use? I am trying to ensure my small database is normalized as possible, but it seems that I every table I try...

Do underscores in object names cause any issues? Such as Daily_Report? Any tips on object naming conventions that seem to work best? Thanks in advance.

I was trying to add a first record to a table called BOOKING with the primary key defined as AUTONUMBER. I made a mistake because I needed to put a dummy...

I'm trying to design some tables for a simple booking system for school rooms. I'm having some problems with trying to come up with a workable design. In...

I need someone to point me in the right direction. I have an Access database that I created that is working perfectly. Now, I need to be able to integrate the...

I am planning on rewriting an Access database using an Access front/back ends into one that uses an Access front-end and SQL Server 2005 back end. When I...

I created this application a long time ago (Office 95) and it was used by a few users who were able to work through and with each other to search and add...

Hi All, I've been reading the posts on here about multiple users. From what I can gather, once the database is ready you can just split it into a front...

I am helping someone redesign a database, and the original designer was having problems with one existing table because it has a multiple key involving a...

Does anyone have any tips on minimizing front end growth in fe/be splits? In specific, I noticed these: #1: While under development, my db's tend to grow,...

I had this problem before but cant remember how to fix it. i created a new Query and form in my database and i am unable to add data to the form or the query,...

I see a lot of normalization questions from this discussion group. May be you can help to answer my table normalization question that I will need to design in...

Hello, I need help with something that is probably very easy, but it has been eluding me none the less. I have a main order form with an order details...

I am building a database and would like to use a country-number as a primary key to identify different matters. I'm not sure how to go about it, though. I...

I'm using MS Office 2007 Enterprise on Win XP Pro with all available updates. I can open and work with databases that I've created without any apparent...

I am developing an Access 2007 database front-end, using tables linked from SQL Server 2005. I just recently had to update one of the tables in the SQL...