I think you can put both the action and the query together in the same query string. So that you can do both in the same call to the database....

Hi,

If you don't want to return a parameter back from the SP (such as @@ERROR or @@IDENTITY) you can simplify your calling code by just executing the...

Hi, I don't have a full answer to your question, you may be able to do this easily in the IDE ,you may not, I don't know. But from a...

Hi,

$150,000 sounds a lot of money!

From VB add the MSINET.OCX

Add the INET control to the page as Inet1.

put the following code in the form onLoad event or under a...

Hi,

Not sure what you mean by 'view the forms using SQL'? The upsize wizard should create an access project for you (.adp file). It is this access...

Hi,

Yeah, The answer is, 'It depends'! It all comes down to how this guy wrote the application in the first place. If your lucky he did it...

Hi,

Ok, sorry, I had assumed you were using an access project to run the queries(stored procs) on the server. It looks like you have linked the SQL...

Hi,

Not an expert by any means, but..

I think the truest testing environment will be an identical mirror image of your database, as you are doing with backup/restore....

Hi,

I have no idea if this is going to help with your problem, but I had a different problem with calling stored procs in Access and adding...

Thanks everyone for their suggestions.

After further investigation I am still no closer to being able to use an Access .adp bound form to insert into a view that has an...

Hi Rachel,

you could also try this method:

Private Declare Function GetUserName Lib "advapi32.dll" _

...

Thanks David,

This looks great! I'll give it a try.

Cheers

Chris

Thanks Andy.

Cheers

Chris

Hi fromnaija,

The users need to be able to see the value of the PK, but not alter...

Hi brokenrulz

Thanks for answering.

That works fine in EM, but my users do not have access through em to put in dummy values. I am using a bound form in...