Search results for query: *

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

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'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...

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?

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...

I tried the Access forum and didn't get an answer so thought I'd try the SQL people...Has anyone found a way to link SQL Server 2005 tables to Access on a 64-bit machine? Any work-arounds/solutions/suggestions?

Has anyone found a way to link SQL Server 2005 tables to Access on a 64-bit machine?

Does anyone know how to access the exif data for a jpg through code. I have a photo catalogue database and I want to be able to suck whatever exif data there is for a given jpg into it.

I feel really daft having to ask this, but how do you search using TSQL for numeric values with a wildcard eg. value of Q(number/s) as opposed to Q(char/s)(num/s)?

Is there a way to get data access pages to work with Firefox? I get a "needs IE 5 etc" error. I have PHP or RoR flagged for learning but wanted to get something out quickly....

I've made a stored procedure to link to an Access database and drop some data into it's tables, then drop the link. If I run the steps of it separately they all work ok, but running the whole thing I get an error that "Could not find server 'AccessDatabase' in sysservers. Execute...

Dilema - I have 2 databases, each to be administered by different locations. They will share backups between them so each has a recent copy of the other. We were going to upgrade both to 2005 Express as one is getting too big for MSDE but that office is now getting a new server, with Small Bus...

Silly question - I'm probably just blind, but... Where do I get access to the SQL Server Agent to set up maintenance jobs, in Management Studio Express? (It's pointed at SQL Server 2000 at the moment if that makes a difference.)

Is the SQL Server 2000 version that ships with Small Business Server 2003 the full version, or does the 2Gb storage limit apply?

Do database diagrams not work with SQL Server Management Studio Express?

I got this error message trying to run an update query on a large table in Access 2003. The query updates an Access table to flag records which also exist in a SQL Server 2000 (MSDE) linked table. The database sits on a server - both C:\ on the desktop I was using and the drive where the...

Is is possible to specify eg. letters as markers when designing a graph on a report, eg using VBA? My client just wants black and white and has lots of data points.

I'm sure this is really simple and I'm just having a blonde moment, but how do I get Access to stop automatically changing my "&" to "_" in captions/labels.

Is there a way to convince Access (2003) to print the database diagram screen onto 1 page instead of 2 - it seems to default to 2 no matter what I do?