I've just imported a substantial database from Excel and Access has merged 4 of my fields into a single field. Originally, the data was entered as the...

I want to run this thought by somebody if you don't mind since I am new and I'd rather spend time planning than fixing. I work for a nonprofit org and I am...

Hi, Im building a very simple database for asset register purposes. I dont want to make any fromt end (forms) to the database, just use the datasheet view. I...

I have a table with a date field, which has an input mask of 99/99/0000;;_ I know from reading other posts in the discussion groups that even with the input...

Having problem storing data in a memo field. Several symptoms: 1. On importing a table to a new database from another database, the table data imports...

I have what seems two pretty basic questions, but they're driving me nuts. I have created a simple bank account database, with 3 basic activities--deposits,...

I have an Access table, NewExamHeader. Fields as follows: HeadRef: Primary Key Ident_No: String to Identify the Student Exam_Yr: The year, e.g. 2005 Exam_Mt:...

I am trying to design a bata base for a statistical data collection system. I have data collection sheets that need to be entered. Each sheets has Person,...

I have .rtf files and .wav files that I want to save in an Access table. What kind of datatype should I assign to the .rtf files and .wav files? Can I...

Hi, At present I have a database for my art works (in-house brewed myself). In it is a table with details of CG and drawn art works with linked...

Is @@IDENTITY thread safe in that it returns the autoincrement value for the most recent insert for that thread or just the most recent insert by...

I am looking for a template that I can use as a Rolodex. Does anyone know where I can find one? Thanks

I encountered a strange problem when I am trying to add a column into a table with less than 150 fields. The error message is "Too many fields", " The maximum...

Hi all, I have a table similar to PK further down . When first assigned on a temp bases the is the same as the field. Is their a way to may the default...

About three weeks ago I had a problem with the Link Table Manager not showing a new table I had added. A kind MVP gave a solution that worked, which was to use...

I have not been able to get much of a response to this problem. Please help if you can. Can I use referential integrity and have one table on the many side...

I have a db in Access 2000 that needs to remain in 2000 b/c not all users have had their workstations upgraded to XP. This db needs to link to tables in...

I have set up a database for service management. I have sent a copy of the databases to all my regions and need to connect these databases at one place. Can...

I'm trying to setup validation for a field in a table. The user will be entering only four digits of a year; ie: 2006. I need to be sure they enter only...

I have a backend database on our network accessed by 2 front end users with their own copy of the front end database. Some tables are linked to the backend and...