When I've run into this, it's because I was using Windows Authentication, but did not give access to the database in SQL Server for the Windows User/Group. You might...

You can pass a command line parameter to Access to compact it. Just use

msacess.exe "database name and location" /compact

That should do it.

The problem is with the grouping, lets look at the sql I posted for a sec.

select

Threads.ThreadID,

Threads.ThreadName,

Threads.Description,

Users.UserName as LastPoster,

max(Posts.DateCreated) as LastPostDate

from (Threads left outer join Posts on Threads.ThreadID = Posts.ThreadID)

left outer...

You don't even have to create an invisible text box, you can just create a text box for the Row Number, then set it's control source to =1 and...

Disregard my previous post, i just downloaded your database.

I messed with the query posted here and got this to run

select

Threads.ThreadID,

Threads.ThreadName,

Threads.Description,

Users.UserName as LastPoster,

max(Posts.DateCreated) as LastPostDate

from (Threads left outer join Posts...

I setup the tables just like you specified and ran the query and it ran fine. What are the datatypes of the fields in each table? I just...

Sorry bout the procedure i made a little mistake, try this

ALTER PROCEDURE dbo.Year_In_@year_In_out_return

@year char(4)

AS

SELECT q.year,

SUM(CASE quarter WHEN 1 THEN amount ELSE 0 END) as Q1,

SUM(CASE quarter WHEN 2 THEN...

ALTER PROCEDURE dbo.Year_In_@year_In_out_return

SELECT year=q.year,

SUM(CASE quarter WHEN 1 THEN amount ELSE 0 END) as Q1,

SUM(CASE quarter WHEN 2 THEN amount ELSE...

once you run that then run another sql statement

DELETE * FROM Table1 WHERE Finished='Yes'

ALTER PROCEDURE dbo.Year_In_@year_In_out_return

@year char(4)

AS SELECT Year, Quarter, Amount

FROM dbo.QTRSALES

WHERE (Year = @year)

I think this is what you are looking for.

ORDER BY Quarter

I think this is what...

One other thing you might try is to create a new db and then try and import all your objects into the new db. This may or may not...

I think you have to use a windows API function to get the username. Here is the API declaration and a little function to return the windows username.

Declare Function GetUserNameA...

When you get a data type mismatch it is usually when you are trying to store a string into a number. Check the query behind the form and see...

You can use the linked table manager and select the check box at the bottom that says Always prompt for new location.

Try changing the first part of your SQL statement to DELETE a.*

I think ACCESS needs the .* along with the table name.