Once again...Newbee (I think I will always be a newbee)
We have SQL server on a NON-DOMAIN server. We are trying to access it (sorry for the pun) from DOMAIN members computers.
I managed to create an ODBC link to the server (using SQL authentication ) and was able to "push" the database to the SQL server, as opposed to using the SSMA on the server itself. But, I didn't split it first. Should I have?
When I look at the Access Database, I see all the objects, including the tables. I really want the application portion as a separate entity to be copied to other computers, or better yet, on a server share so only one copy would be out there for the users to use.
QUESTION: Is there a way to split it now, and then connect the application portion to the SQL database?
QUESTION: Am I beating my head against the wall trying to work outside, yet within, the DOMAIN? We really do not want this setup as part of the DOMAIN for internal political reasons (outsourced IT).
I have a ton of other questions, but this will do it for now.
Thanks