Search results

the links were created by the sql server migration assistant. If I check the properties of the tables though they say that they are odbc linked tables.

It's actually written LabProjects in the database, i must have put a space by accident, sorry.

it says: tablename (Database = lab projects)

so, what would you recommend I do to fix this problem?

i made a modification to the server made it check both sql and windows authentications, now when we try to login with the trusted connection check-box checked it says sql state S1000 and the error is 18456. does that help at all?

I opened a new query and typed use mydatabase, then select name,* from sys.sysusers nothing happened, the cursor just went to the next line. no column names, and yes the login i added has access to the database. how would i go about configuring the odbc drivers?

when I entered the queries in nothing came up at all

We connect using the first method. like I said earlier, we go to open the forms in access, and it says that we aren't connected, then a popup shows up asking to login and using the trusted connection, it doesn't connect and when we try to deselect the trusted connection and enter the windows id...

I have added the 2 users necesary to test whether this is working or not to the sql server using the management studio. It's using windows authentication. The error log just says the the username is not associated with a trusted connection

Hi, I just recently migrated my Access 2003 database over to MS SQL Server 2005 using the Migration assistant provided by MS. However at my business we have multiple workstations using this and when I try to use the database (through the access front-end) we get an error message saying that...

Hi, The problem is this, i have a combo box that as a result of selecting something it opens a form where i select a price by checking a check box. once a check box has been selected i can close the form and finish creating the invoice. however when i change a different combo box first i get a...

hi, i wanted to know if it was possible when loading a form could i check a query's content first. I needed to know if there is anything in the query or not. So if nothing is in the query then I don't have to view the sub form for the query jlabre01

Hi, I currently have a text box where I write in true or false in my form, this tell another form which option to use, I would like to use an option button instead, for some reason I can't get it to work. please help, jlabre01

thanks, i appreciate the help

well the query needs to check a couple things, to return the value

yes, i'm searching for one value

Hi, I just wanted to know what the proper format was for setting the control source for a text box to an sql statement was? jlabre01

after the whole tab is deleted, i did the compile, it says nothing

Hi, I'm trying to delete a paged in a tabbed form, this tab/page has a couple command buttons that won't let me delete them, when i do it gives the error 424 message. i deleted the event for each command button, then the button then the tab/page, and when i open the form in form view it just...

I've deleted the events for the command buttons, but when i delete the command buttons the same error still pops up.