February 1, 2007 at 12:42 pm
I also posted this in the SQL forum.
Here is a strange one. I had an Access DB that I converted to SQL using the upsizing wizard.
The application works fine.
When trying to do a project import in MS Project, I can attach to the DB, see a list of tables, but I cannot get the list of fields. The weird thing is that I can read the fields in the dtproperties table. I can also see the fields in any other DB (not converted from Access) on the same server.
I also have DB Artisan and was going to do a data extract, then recreate the table, and push the data back in. DB Artisan reports the correct number of rows, but when I try to extract, it says there are 0 rows.
I did everything I could think of with permissions, including giving table level permissions.
Please help.
February 1, 2007 at 5:48 pm
Found it. The tables have spaces in the names. No spaces, no problem.
February 1, 2007 at 7:09 pm
Yup, can't say I like table names with spaces (inherited one system with plenty of those).
Thanx for clearing this out for us.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply