Make the Access database used by users on 2010 and 2003 both

[aman]

Hi guys

I have an Access database built that in future will be used by all the users whether they are running Access2010 or 2003. Now I am facing a problem, As soon as the user logon to Accessdatabase on 2003, it doesn't allow other users from 2010 to login to the Same Access database.

Can anybody please tell me why its happening?

Thanks

 

[nschroeder]

I'm developing a db that will have the same scenario. I haven't tried it with multiple users yet, but as soon as I get it finished, I was planning to split the tables out to a separate 2003 db, then have separate front-ends -- one 2003 and the other converted to 2010. If you get a chance to try this before I do, which will probably be in a week or so, let me know how it works.

 

[Mr. B]

You will need your database to be in 2003 format and it can still be opened with Access 2010.

You also need to be using a "split" database design. This is absolutely necessary if you are going to have multiple users of your database. If you are not familiar with this, search here on the forum as there are plenty of threads about this.