Db Formatting Lost after Splitting

[Pete Merenda]

After splitting my Database, I opened the back-end to see that all (50+) fields had been reset to Text format. Additionally, all paramters that I had set (default values, input mask) -- including those not available in form field properties (i.e. Required, Allow Zero Length) -- are now returned to Access defaults

I changed them all (several hours), imported an Excel file, and they all changed back again

How can I prevent this from happening?

Please help.....

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[Pete Merenda]

I'm very eager for advice on this issue. Can anyone offer help

Thanks in advance.

 

[Lynn Trapp]

Pete,
It's hard to say without knowing more about your database, but it's possible
that the process of importing the Excel file is the cause of your problem.
When you import a file from Excel, Access looks at the first few rows of
each column to determine the datatype of the field.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

After splitting my Database, I opened the back-end to see that all (50+)

fields had been reset to Text format. Additionally, all paramters that I
had set (default values, input mask) -- including those not available in
form field properties (i.e. Required, Allow Zero Length) -- are now returned
to Access defaults.