Problem in design view after splitting

[alexmb1]

I split my database so multiple users can acess info simultaneously and now i am not able to open a query in design view. i keep getting an error that says

" is not a valid name

the same query that is giving me the problem opens fine before i split it. all of the other queries allow me to open in design view after i split except one.

any suggestions?

 

[DCrake]

Try rebuilding the query in the split database.

 

[alexmb1]

I am able to recreate in after the split and correct one of the queries i was having a problem with. however, i am still getting the same error with one of the queries. i tried to create using both the wizard and the manual way but no luck. also, i read in another forum that this may be a problem with Access 2007 that has not been fixed. there seem to be several others out there with the same issue and very little along the lines of how to fix it.

 

[alexmb1]

also, i just noticed that i get the same error message when i try to open my relationships window. my relationship is also deleted and when i create it again and save it doesnt work. this is very strange

 

[alexmb1]

FIXED. The problem appears to be a flaw in access that won't allow special characters in the file name for the back_end of the database. I had an apostrophe that was causing the error. It seemed strange that most queries still worked but i guess there will be a service pack sometime in the future to address this. heads up to anyone who experiences this in the future.

Alex