I have an access database that is split into frontend and backend. I am using Access 2010. I used the upsize wizard to link my tables to sql server 2008 express. I have been using the old access frontend and backend on my network sharing it from my desktop to other users. Now that I have upsized the access frontend workes fine on my desktop but when I place the frontend on a networked pc it cant connect to the database.
I know this can be done but I am missing something, like the proper path.
When I ran the upsize wizard I selected trusted as apposed to using a user id and password.
Thank you in advanced.
Randy