Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Restricted Database Admin

    When you open access 2002, the task pane is open on the right, under the heading new, click 'Project (Existing Data)'. This will bring up a save dialog...Choose an...

  • RE: Restricted Database Admin

    One alternative is to give them Access, at least version 2000. You can create an Access Data Project (ADP) that gives the user the same interface for table design,...

  • RE: Linking SQL Server table with access forms

    Hi...I recently converted an entire access database to use SQL Server tables. I found that sometimes Access wouldn't set the primary key correctly on linked tables. Verify that...

  • RE: Connecting an access (2000) database

    Hi, I just went through this a couple of weeks ago. Even though your access database is not secure it does require a login. Set the login...

  • RE: Linked Server Security

    sorry for cross posting.....no, I didn't get an answer on either post. Thanks for the inquiry.

    Mike

  • RE: Linked Server Security

    Thanks for the input. I've checked the security tab and I have the last option button selected, "Be made using this security context" - and I have the login...

  • RE: xp_sendmail "Sent Items Folder"

    quote:


    Dont know of immediate fix. Short term you might just BCC the server email so you have the copies at least.

    Andy

  • RE: SS2K Web App

    Thanks for the advice. I have a sub to MSDN and will load Visual Studio and play with it.

    The website you mentioned...does it have tutorials?

    Thanks again,

    Mike

  • RE: SS2K Web App

    Thanks for the heads up. I think I'll take a small portion (the functionality can standalone) of an app and see if I can create a web based app....

  • RE: Linked Server Tables and Performance

    I just found my answer.

    LinkedServerName...TableName

    Very cool

    54 seconds before...now we are down to 45 seconds.

  • RE: Linked Server Tables and Performance

    Thanks for the info. I didn't want to use the OpenRowset to begin with, but I couldn't figure out how to use a table from a linked server in...

Viewing 11 posts - 1 through 11 (of 11 total)