Search results

I have a permanent table that I'm trying to insert records into from a temp table. The 2 tables are joined by AssetID. My query basically says for an AssetID in the temp table if it is null in permanent table then insert it into the permanent table. This is the error I get: Msg 8152, Level...

Hi, I have a recurrent issue with users parking in a network access database. I need to get them out of the database for doing things such as changing the design of a form. Sometimes they get into the database and forget to exit and if they are not in the office I cannot go just shut their...

Here's the set up: I am the dbo of a SQL Server 2008 database, and we have an Access front end. I have 2 users that both have db_datareader rights to the SQL server db. They have the exact rights in SQL server 2008. User A linked a table from the SQL db in the Access front end, which I can...

Thank goodness I still have a job but I'm thinking about "beefing up" my resume just in case. I have a BS in computer science but have not worked in that area for about 6 years. During this time I have been working in another field but hacking together an Access database at work and really...

I may have to upsize my Access database to SQL server 2005. I have no experience with SQL Server, have some experience with Crystal Reports, and I'm an intermediate user of Access. I have done a lot of programming with VB, C++, Java, but not the .Net framework. Basically I will need to upsize...

I have a split database, and I'm trying to figure out the best way to update the front end for my users. Some of my users will have their own queries, reports, etc., that they have built themselves into their local copy of the front end. When I upgrade the front end, I do not want to wipe out...

Write to one table from a form, view associated data from other tables on same form I remember reading on this forum that if you try to access several tables from the same form then you cannot edit any records from the same form. This is what I need to do: Use a form as a data entry form for...

This is the query I'm using: SELECT DISTINCT t_Table1.[AssetNumber], t_Table1.DESCRIPTION FROM q_Query1 INNER JOIN t_Table1 ON q_Query1.[AssetNumber] = t_Table1.[AssetNumber]; q_Query1 is a query which only returns AssetNumbers. The [DESCRIPTION] field in t_Table1 is a memo field. It...

Hi, all, I need help with solving this puzzle: 1. I created a subform with a query as the record source. Added the subform to a main form. 2. I added a new field to a table that the subform query uses. I then updated the subform query's select clause to add the new field. 3. I added a...