I'm trying to upsize the table (structure and data) of an Access database to a SQL Server. Everything seems to go smoothly, except that Access seems to freeze when it tries to create the extended properties of the tables. After some times it just gives an error telling that it "Cannot open any more databases", and after that i just can't open any tables/forms/queries from the access database, i have to close it and to re-open it.
I've checked the help for "Limits" but it doesn't help much as i don't realy know what the Upsizing wizard is doing.
I've got ±65 tables, no relationship designed in access and i'm upsizing structure, data and default value only.
Anyone got a hint?
I've checked the help for "Limits" but it doesn't help much as i don't realy know what the Upsizing wizard is doing.
I've got ±65 tables, no relationship designed in access and i'm upsizing structure, data and default value only.
Anyone got a hint?