I recently split my database and it automatically placed the be version of the file in My Documents. Where do I go in Access 2007 to change the path if I move...

Hello, all. We have an Access db that we use as a front-end to a SQL Server db, with the SQL Server tables linked in via ODBC. Is there any way...

Where do I begin... I added a new table to my frontend database, forgetting that it was split. I then copied the table into my backend database and tried to...

Hello there! I'm having an issue with access 2000. I'm trying to make one form where I can select from different tables from list boxes, and then have my...

List Price:$79.99 Image: http://bestdeallocator.info/image.php?id=B0000645E8 Best price found: http://bestdeallocator.info/index.php?id=B0000645E8

I'm trying to set up a database in Access for our Instructors but am running into a problem. Some instructors teach multiple programs which in turn has...

Hello, Hoping someone can help because haven't been able to find info online, and it's driving me crazy, and please bear with me thru the background info, as...

I was wondering after reading some comments about table design. Is it wrong to use a lookup in a table to store the text of the foreign key to make the table...

You could import the data from the two sources, creating a table for each. Then, you can create a query that compares the data in the tables. "TedChicago"...

I want to make the field names in the table I am working on wrap through two lines. Is this possible in datasheet view?

I would like to use the calendar control to set a start date in the database and then automatically calculate a date 12 weeks after that date, but I would also...

I'm hoping this is the appropriate group for this, none seemed quite perfect for this question. I have an Access 2003 front end, which is linked to some SQL...

I have an HR dbase with S.S.# as the primary key and info about a person's position. I also have separate tables with S.S.# as the foreign key -- one has...

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

I have a small app in A2003 similar to Northwind. If you change a customer address in the customer table, it changes all orders in the (previously entered into...

Hi folks, I have three tables: Table1: Contacts (PK = ContactID) Table2: WebComs (PK = WebComID) Table3: ContactWebComs (junction table - multi-field PK =...

I need to calculate time differences (in hours and minutes) across a couple of days. The database is set up with a separate fields for date and time. Can I...

Every time I try and send a msge with an attachment, it won't work. I get an error 'the operation timed out waiting for a report from the sending...

I have recently been aproached with questions about Document management / Relational Databases for managing business. I also recently attended a presentation...

I have a query which includes a field - 'Risk'. This is rated on a scale of 1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in another...