Unable to Open ODBC Linked Tables 1

[goolawah]

I have a simple Access application with uses two ODBC linked tables to read data from an external database.

I now need to add two more tables but Access rejects the link. I have discovered that the problem seems to be due to the fact that each of the new tables (unlike the existing ones) have a Date formatted field (mm/dd/yyyy) which is unacceptable.

I am wondering if there is any way to -

1. Create a custom date format in Access that will make these fields acceptable.

or

2. Select which fields are to be included so that I can exclude the date fields. As far as I can see I must firstly link to the whole table (which fails) before I can select which fields I am actually going to use.

Any feedback/comments appreciated.

 

[hneal98]

It doesn't make sense that this format would be unaceptable. Are you in the US?

Why don't you try a test and instead of linking the tables, try to import them. Sometimes you can get more info when you try to import the data into an existing table of the format you are expecting.