Search results for query: *

Is there a way to change the default keyboard shortcuts in Access 2010?

Well! That's not what I wanted to hear, but thanks, lameid. Silly me was hoping something was going to be easy.

Is it possible to send an email from an access form, but instead of defaulting it as coming from the current user, specify another email address ie. Joe Bloggs sends it as fred@company.com and John Smith also sends one as fred@company.com. I think the current form sends the email using...

I should possibly add that I am using Windows Authentication when on the workstation.

I've linked an Access database to SQL Server 2005 express, and it works happily, so long as I run the stored procedures etc when I'm working directly on the server box. If I try to run it remotely ie. workstation on network using SSMSE, using a valid login, the database says it's linked, but eg...

You gotta wonder...what the HELL were they thinking!?!?!

Backward compatibility seems to be just about non-existant with 2005. Have you tried detaching the .mdf and .ldf file and copying them to the new server?

Ok, I can't find the references to them not being supported in future either now :p ... must've been pregnancy-brain and sleep deprivation induced. I actually wanted to delete/insert the actual table, not just write records to it...In hindsight, I don't actually and I've gotten my original...

I also meant to ask...BOL is full of dire warnings that linked servers shouldn't be used anymore. What's the best simple alternative using Express?

I've set up an Access database as a linked server. Is there a way to delete and add (ie "insert into") a table from this using a stored procedure in SQL2005 Express?

Ah well, back to my faithful old .cmd files then.....thanks Denny.

Ok, I've found the TSQL stuff which sets up jobs and assigns them to schedules which seems to set up ok in Express, except the schedule doesn't fire. Is this because Express doesn't include Agent and having the whole job/schedule thing in there is just another MS tease?

A new computer running WinXP sp2, IE6, Office 2000 and Access gives an error along the lines of it can't draw the database windwo because it needs an updated version of IE...this was before the computer had been anywhere near the internet. We have since downloaded and installed the available...

George's code would be useful if you could isolate the batch of data loaded incorrectly....actually, it'll help me too ;) 'cause I have some data with a similar problem which I've been avoiding confronting, so thanks guys :)

You can link the SQL tables to your Access front end and use the forms that you have in Access. If you use SQL 2000 use ODBC, if 2005 use Native Client.

If you want to test first without forking out $$$ to MS for a full licence, download SQL 2005 Express - you'll probably also need to download DotNetV2 and SQL Native Client. You'll need to install Native Client on all machines linking to the database via Access - it's the new ODBC and required...

Hey Denny. How much time did you book to admin for filling out 15 minute timesheets lol.

I do contract work so justifying my time is quite important. Having said that though, I find that with all my clients just having a broad description of what I've been doing with a block of time is generally sufficient and I'll add comments to my work notes if anything needed extra time for...

Yup, changing windows is about where we got to. We're going to try rebuild one that's already died as a 32-bit and see how we go.

Thanks Catadmin...hmmm support seems to be horribly unsupportive. Seems my client really is on the "bleeding edge".