Access Conversion 2

[gregmosu]

I am converting an old access db to access 2000, and every field is being converted to text!!! Is there any way I can find out what those old fields were? It will let me open the old version, but it wont let me look at the design!

 

[jebry]

Hi!

Try creating a blank database and linking to the tables in the old database. You still won't be able to change the design but you should be able to look at it.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[humbleprogrammer]

Can you link to the tables in the old version from a new db? New - Link Table? If so, you should be able to open the linked version in design view to see the field types. If not, you can create a make table query based on the old table. The make table query saves the new made table as the same data types.

 

[gregmosu]

Thanks guys. I tried to link the tables in, and it did work.. but now I'm more confused! When I converted the database, every record came up as a text field. I was sure this couldnt be right.. but apparently it is. The field OrderDate is a text field, and this is the query they are running on it..

SELECT * FROM ordhdr WHERE OrderDate >= #04/27/03# AND OrderDate <= #05/29/03#

how can this have ever worked on a text field? any ideas would be greatly appreciated!

 

[humbleprogrammer]

That query could not have worked efficiently if the date was a text field. Looks like bad database structure on the original designers end. You may want to clean it up if you have the choice. But note: changing the data types may have an effect on the existing queries and forms, so you may be in for a big task.

 

[gregmosu]

Yeah, I converted it... and it does work for the search now, but breaks other parts. I think you're right, this is just REALLY bad design!

Thanks for your help,
Greg