Nitro
Last Activity: Jan 28 '07, 06:59 PM
Joined: Nov 13 '06
Location:
-
So you go t every User's Machine and setup a System DSN? Isn't that a hassle?... -
UPDATE:
I finally got the LinkTables method to work onsite, however I had to use a DSN file. I copied it to a common location on the server, and linked using it. Everyone who accesses the database should have access to the DSN file.
However, I'm still baffled as to why the link doesn't work within code using the Connection String and Refresh method. Has anyone had any luck doing it this way, and would like to share their...Leave a comment:
-
I mean I just Disabled my Windows User in SQL, so the Trusted Login no longer works.
Where do set the Server to use STANDARD Mode only?
I'm using the Connection String in code. See my LinkTables Method....Leave a comment:
-
Hello again,
Both, my local and onsite SQL Servers are set to "SQL Server and Windows" (Mixed Mode). However on my local I have my Windows User setup in SQL, so I'm able to use Trusted Login. Onsite they don't have Windows users setup, so Trusted Logins will not work.
I disabled my Windows User in SQL, so now I can no longer use my Trusted Login. I verified by setting up a new ODBC, and it forces me to enter...Leave a comment:
-
Now I did. Thanks.
Here is the connection string I'm using:
"ODBC;DRIVER=SQ L Server;UID=audi tuser;PWD=audit user;SERVER=COR PMAT;DATABASE=A uditTest"
I have a Login "audituser" setup in SQL with a pasword "audituser" , with Admin rights to the database "AuditTest" . The same way I have setup locally on my machine, and in the other office that worked. BTW, I also tried the "sa"...Leave a comment:
-
Standard Security as opposed to what? Do you mean the account details of the User I'm logging on with? I just setup a standard user and gave it admin rights to the database, the same as I did on my local SQL.
I have some more info though.
Yesturday I went to another office running SQL on a server. I was able to Link the tables from a workstation using my method no problem. I used a User I setup the same as on my local....Leave a comment:
-
That's just a typo from the copy/paste. It's not that way in my code.
This code works fine on my local machine, so I don't see why it wouldn't onsite. Actually I'm going their tomorrow to personally try it out. Until I do there's not much more info I can give, ie. Error Messages etc.
One main difference is I'm running MSSQL 2K locally on my Win XP desktop. Onsite they are running MSSQL 2K on a deticated server, and connecting...Leave a comment:
-
Linking to SQL
I'm having problems getting my DB to Link to different SQL servers. I got it to work fine on my own machine, but when distributed it at the client, and to another office, the Link didn't work. It either timed out, or gave errors.
I created a LinkTables Method (below) that would allow me to distribute the DB to the client running on another server. I created a local Settings table to store the Connection Strings of different locations.... -
I'm thinking about going back to the MDB. The ADP seems to have many issues. I haven't yet started the reports, so I need to decide before I do.
Maybe someone can help me with another problem. This is the reason I changed to the ADP to begin with.
I was having problems getting my DB to Link to different SQL servers. I got it to work fine on my own machine, but when I distributed it at the client, and to another office,...Leave a comment:
-
{UNSOLVED} Access Project Issues
Hello All,
I have some questions about Access Projects. I recently converted an Access 2003 MDB to an ADP, because I was having difficulty linking the tables to SQL after moving it to different servers. I wanted an easier way to make the database portable. ie distribute the Front End to clients with different Back End servers.
I converted all the queries to SQL Views, and got the code to work. However there are still...
No activity results to display
Leave a comment: