2 problems with MS Access
-
I am currently writing a large database programfor a manufacturing company and I have to problems. 1) When I am setting up my DataAdapter I can not add more that about 100 fields anything past that and i get errors. 2) When a job is done I want to move it from one database to another. Right now i am doing it manually i would like a way to say send this record from database "a" to database "b" I would appreciate any help that can be given James Kennelly
-
I am currently writing a large database programfor a manufacturing company and I have to problems. 1) When I am setting up my DataAdapter I can not add more that about 100 fields anything past that and i get errors. 2) When a job is done I want to move it from one database to another. Right now i am doing it manually i would like a way to say send this record from database "a" to database "b" I would appreciate any help that can be given James Kennelly
vertig0730 wrote: 1) When I am setting up my DataAdapter I can not add more that about 100 fields anything past that and i get errors. There is a 100 field limit in the DataAdapter Configuration Wizard. You'll have to do it manually if you want more, or just don't pick that many fields. PRB: 100 Column Limit in DataAdapter Configuration Wizard[^] Over 100 fields in an Access database? Over 100 fields in a single table? :omg: Yikes! Ever hear of MSDE or SQL Server? vertig0730 wrote: 2) When a job is done I want to move it from one database to another. Right now i am doing it manually i would like a way to say send this record from database "a" to database "b" You'd do it the same way you'd read and write any records. Setup connections to both databases, setup the command object to read the data from a table in Database A, and execute the command. Then assign the data from each field read to the corresponding field in the parameters of the INSERT query into Database B. Execute the write command on Database B. Do this for each record you find in database A. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
vertig0730 wrote: 1) When I am setting up my DataAdapter I can not add more that about 100 fields anything past that and i get errors. There is a 100 field limit in the DataAdapter Configuration Wizard. You'll have to do it manually if you want more, or just don't pick that many fields. PRB: 100 Column Limit in DataAdapter Configuration Wizard[^] Over 100 fields in an Access database? Over 100 fields in a single table? :omg: Yikes! Ever hear of MSDE or SQL Server? vertig0730 wrote: 2) When a job is done I want to move it from one database to another. Right now i am doing it manually i would like a way to say send this record from database "a" to database "b" You'd do it the same way you'd read and write any records. Setup connections to both databases, setup the command object to read the data from a table in Database A, and execute the command. Then assign the data from each field read to the corresponding field in the parameters of the INSERT query into Database B. Execute the write command on Database B. Do this for each record you find in database A. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
1)I thought about SQL but when this project started it was only supposed to do one thing, It got bigger quick. It now spans 5 databases mostly in the 40 field range. this last one has to use data from one of the existing databases and add to it. I have tried splitting the old information and the new information but had no luck. 2)Thank you James Kennelly