DoCmd.TransferSpreadsheet ....

Look this up in help and it will give you all the parameters to use.

HTH, Vic

Charle,

Are you writting the SQL code yourself?  If you use the Design Window for queries, I think you might find this quite a bit easier.

Vic

Don,

I would call Microsoft support.  You get at least two (2) free calls with every license you have.  If it is their fault, which I doubt in this case, the...

I am currently in the process of upsizing a large Access DB to SQL Server and have not found anything to "assist" in the upsizing other than just getting into...

Have you tried (just testing) to see if this same error would happen using local tables?  Then try them in a second Access database, and use ODBC to connect them...

Ritesh,

This is just a normal form within Access.  The only difference is that when you open the form, you would use this type of line in your VBA:

DoCmd.OpenForm "frmName",acNormal,,,,acDialog,"Color=Red;Style=MyStyle; "...

Ritesh, 

No way to customize msgbox, but it would be very easy to write your own popup form just the way you want it.  Use a function to do the...

ritesh-

I would suggest you ask this question in another forum altogether.  This question has nothing to do with SQL or ACCESS.  Look for a forum on web site programming.  I can...

>I have linked tables from ODBC datasource.

>when I go for updating any record then it gives me error as follows:

>Reserved Error (-7776); there is no message for this error.

>What...

Click here to download an Access database that shows you a suggested solution to your question.  Review Query4, which is a Crosstab query to show the number of minutes worked...

Yes

a quick Google search using "ms access dsnless connection to SQL Server" gave the following link in the number 2 spot:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;892490

It appears this article should answer the question.

Within Access, using the menu, File/Get External Data/Link Tables... then select "Files of type" (at the bottom of the "Link" window) and click on "ODBC Databases."

This is the only way I can think of to protect your tables from unauthorized viewing by knowledgable users:

1.  Assign a ownership of the "production" database to a newly created...

What about:

abs(datediff("m", #3/1/04#, #5/26/05#)) which equals 14 months?

or

abs(datediff("m", #5/26/05#, #3/1/04#)) which still equals 14 months?

By using "abs" (absolute) it does not matter which date is first, all you want is...