How to change/alter datatype of a field from a linked table in MS Access?

[Josh Andrews]

Hi, I have created a MS Access database where all data are stored in linked tables. I noticed that two of my linked tables (parent and child in a subform) are having different datatypes: the first is set to AutoNumber (Long Integer) while the other one is Integer only. These tables are combined in my forms & reports, and in my queries.

Can I programmaticall y (VBA) change the datatype of my child table? and how?

Thanks team,
Josh

**Kindly provide me with VBA code for I am not that good in programming.

[TheSmileyCoder]

Hi Josh

I dont have code on hand for that, though its probably possible, it would depend on what type of backend your using, a detail you have not supplied.

But before using time going down that road, I have to ask, why not simply open the table in the backend, and fix the issue there?

[Josh Andrews]

But before using time going down that road, I have to ask, why not simply open the table in the backend, and fix the issue there?

TheSmileyCoder, I also used MS Access as my backend. What I did to the application is that when users archive their database, a copy (MS Access backend) is created and separates the archive from the live/current.

We have more than 10 users x 5 branches x (number of live and archive backend.

I think it's better to just send them a patch that will fix the linked tables. Please help.