In the futior please do not hijack an old thread. Please start a new post.
Quote:
Originally Posted by ttitto
I have a slightly different question. I had a database that I split. Then I added passwords through exclusive access to the back end databases. When I tried to work normally with the front end database I had an error 3031 "Not a valid password". I found some solutions, that I am not sure how exactly I can implement in my case. The solutions were with connection string. I do not know which connection string to use and where should I write the connection string. Any help will be highly appreciated?
|
If you add a password to a back end then you will have to delete all the linked tables and recreate them.
Quote:
Originally Posted by ttitto
The database will be used in an network with windows XP and access 2010 from different computers. But before it is completely ready it will be develloped on a single computer with windows 7 and access 2010. i do not know if this information is usefull.
|
I do not believe that you can properly develop a multi user (split) database on a single computer. You must place the back end on a different computer/share. You also need to load test the back end.
There is just now way to properly test a multi user database that is not split or if the back end is on the same machine.
By developing and testing in an environment that closely matches the production environment then you will have a lot let things to redesign once in the production.
User Permitions
