Search results for query: *

Hi, I've attached a screen shot of the error log from a SQL Server. I have a job that runs fine from Business Management Studio and from within SQL, but when I run it through the job agent I get an error. Looking at this log, is the error a critical error? Does the job still complete what it...

Hi thanks for the reply. Yes parcels can be combined. Michael

Hi, I was wondering how to deal with data that changes, but the user still needs to access data from the past. For a database that deals with development permits for properties I have a primary key that combines tax roll number and Parcel ID. However, when a parcel is subdivided, the parcel is...

Hi, I have a SQL 2012 database on a server, which I currently use Access on a local machine as a front end. I can access the database fine using an OBDC connection. I was hoping someone could recommend a site that lists the steps to create a trusted connection or better yet list them in a...

Thanks for the reply, it helps.

Hi Andrew, could you show where you put the code? Thanks, Michael

Hi in Access I've created a module where I refer to a local server as Sql\HINTN, but autocorrect keeps changing the line to SQL \ HINTN. How do I stop the VBA editor from making this change? The line of code should be "SERVER=" & SQl\HINTN & ";" & _ but keeps getting changed to "SERVER=" & SQL...

Hi, I have created a database that links to tables in a SQL database using an OBDC database connection. There are a couple of people in my department who need to access this database. Is there a way I can deploy the database so that all users have access to the same data? Or do I need to set...

Yes, I would like the historical table updated after the form is updated.

Hi, I'm working on a database for development permits. The main development permit table is linked to a table from our financial database which provides ownership and zoning information. We would like to maintain historical data for a development permit, who was the owner when the permit was...

Hi thanks for the reply. The table is truncated; is there an alternative? I don't know anyway of updating the data in the table without dropping the old data. And yes, it's an identity field. If the table is populated once, is there a way of populating the id field without having it as an...

Hi, I don't know if this is the correct forum or not. This is my situation: I use SSIS to bring in data from a separate SQL database to populate a table. It is during this process that I populate an ID field in the new table that is an integer, is auto number and acts as a primary key. Using...

Hi, I have a database in Access that acts as a front end for a SQL database. I have some forms that draw information from a SQL table and I also populate tables in the same SQL database. I would like to distribute this access database to people within my department. My question is to do with...

Hi, I'm having problems with page number sizes. Depending on the page the page number size grows or shrinks. I've attached an images showing the preview of 2 pages from Acrobat. You will see that page 1744 is much bigger than page 1745. Is there anyway I can adjust the size of a page number on...

Hi, I have a dtsx package that brings in a table using an OBDC connection and populate a SQL table using this table. There is a field in the destination table, an auto incremented integer, that doesn't exist in the OBDC table. I get warnings when I run the package. Is there something I can do...

It was the permissions, thanks. I had to add the correct credential to the db_ssiadmin and it works now. Thanks

Hi, I have created a package that brings in data from another database and with the data package populates a table in SQL database. The job runs fine when it is executed. I've imported it into SQL and it still works fine. But when I try to automate it using SQL Job agent, I get the error that...

Hi, when I try to use a package I created using SSIS in Management Studio, I get the following error: Error Message Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The SQL Server specified in Integration Services service configuration is not present or is not available...

Got it to work, thanks.

Thanks, for the reply. Can you tell me how to change the primary key to an identity one?