I'd like to add that if you are using bound forms in Access, you will also need to add that unique field to the underlying data source, otherwise you will...

nabajyoti.b (12/22/2008)

---

Hi

I have table in MSAccess which i to be in SQL Server 2005.

For that i want to put the whole table structure copied without me having to write...

Here is some sample code that builds a list of tables where the name matches a pattern, and then executes T-SQL for each table. No cursors 🙂

DECLARE

@TABLE_NAME sysname,

@sql nvarchar(4000)

SET...

The Exam Cram books are the least expensive, they do an OK job but you do need to have hands-on experience with the product for them to be most effective....

Caller ID.

ChrisStar (2/26/2009)

---

To start off, I am very new to SQL Server and have been using Access for many years but have limited coding experience. What I have learned/discovered I...

Another way to do it. . .

CREATE TABLE #temp

(

[name] nvarchar(128),

...

Steve, is there a way you can configure the Google search to restrict the search to a specific forum? Also, is there an option to display a cached version like...

cindy_sinath (11/11/2008)

---

I have a form with First Name, Last Name and Date fields all of which are combo boxes. There is a preview Button to preview the report I need...

You can create your view and CAST the bigint as numeric(18,0) and Access will understand it & also tolerate joins with Long Integers.

If you use a varchar and try to...

If the user is the head of Finance then the politics can quickly get out of control. I would suggest that you talk to your boss & explain your concerns....

One more thing - if...

Yes, the application determines what they can do, based on their Windows ID. If we had used a Windows service account then we could not distinguish who the user is,...

With a Windows service account we would not have the granularity i.e. each user has specific permissions within the app based on their Windows ID.

One downside of using Windows authentication is that a user could create an Excel, Word, or Access file that connects via ODBC directly to the database. That is a big...