Re: Maximum fields in table problem
Wed, 30 Jul 2008 18:02:06 -0700
Access has a problem when you change fields (name, datatype, number) in a large table. It cannot have more than 255 fields in a transaction. So if you have 200 fields then change 100 fields you have 300 fields in the transaction which exceeds the 255 limit.
If you have 200 fields already you cannot change more than ...
|
New Table to Existing Database..
Wed, 30 Jul 2008 15:36:00 -0700
I am working with a linked FoxPro database. This database is accessed and
updated through another program. I am creating additional functions for
route planning and need to add new tables (because I cannot append the
existing table structure). For example- The database stores customer number
(my primary k ...
|
1st time Access Database
Wed, 30 Jul 2008 11:30:17 -0700
I am trying to create a database to allow our employees to locate artwork for
4 different product types, silkscreens, metalphoto, labels, and misc.
The artwork physically resides in individual folders, in 4-drawer file
cabinets.
I have created a customer table from quickbooks import of Customer, Contact,
...
|
Source Data >255 Fields ?
Wed, 30 Jul 2008 19:16:45 +0100
I have a third party data file (500,000 tab-delimited records) and need to
analyse a small number of fields, but there are over 400 fields and those of
interest are between 256 and 400 and so can't be readily imported into
Access 2003 !
Is there an Access 2003 add-in (or perhaps flat-file parser) that will ...
|
Reporting an incremented "ID" with a sorting requirement
Wed, 30 Jul 2008 10:26:02 -0700
I'm working on a document control database (assigns document numbers and
tracks a document from inception to release and through revisions and
signature approval process). Thanks to help from this forum, I've worked out
a multi-field "ID" system to meet the requirements for the document numbering
system and ...
|
One table or two?
Wed, 30 Jul 2008 12:11:01 +0100
Hello All
I have to create a facility within an existing 'Employee' database to manage
employee sickness absence. The data to be input will be the employee's name,
and the start and end dates of any sickness absence periods. These dates,
together with some other 'standing' data held in the existing 'employe ...
|
How to scan for currupt DB.
Tue, 29 Jul 2008 22:16:00 -0700
Every now and then a few records in some tables become corrupt.
How can I determine if corrupt records exists so that I do not end up with
ALL my backups containing corrupt records.
Is there a utility? or do I write a procedure to read thru all my tables?
--
Regards
Tom ...
|
|
|
Microsoft Works Database
Tue, 29 Jul 2008 11:13:02 -0700
I am using microsoft works 4.5 and am creating a database file. Is there a
formula that can calculate age, and grade. For example i will have a date of
birth column and i would like to have works automatically calculate age for a
another column. Also I would like to be able to have a grade column for
stud ...
|
OnCurrent Event
Tue, 29 Jul 2008 08:57:05 -0700
I have created a message box in the OnCurrent Event on the my main customer
page to obtain information the first time a customer calls. Everything works
ok, but when everytime I do a filter or open the form initially, it runs the
event twice.
I have run similar codes in the past in the OnCurrent Event an ...
|
Link Primary Key to two fields in second table
Tue, 29 Jul 2008 07:28:11 -0700
I have a "People" table that I would link to an "Orders" table. The People
table has a record for each individual. A record in the orders table will
have multiple "People" in it (e.g., Person Placing the Order, Technical
Contact, Budget Officer, etc.). I would like to link the Primary Key of the
"People" ...
|
