The short answer is, no.

The longer answer is, check out SQL Server Books Online (the help file for SQL Server) for details on locking. Depending on exactly how you...

As an additional resource, I highly recommend Stephen Lebans' website. http://www.lebans.com/ He has a lot of great tricks for making forms do exactly what you want...

Is the data type Long Integer? AutoNumber is always a Long Integer field.

Specifically, what kind of errors were you getting? Access should have automatically created an Errors table...

jessica, your issue is pretty much exactly what the error message sounds like. It's one of the severe limitations of Access. Because it's a file-based system, it won't...

When you say "everything begins to double," I'm guessing you mean in a SELECT query involving all three tables. Correct? And, because you mentioned doubling, I'm going to...

What do you mean by "the backend?" What tool is the user using to select the database? There pretty much has to be some sort of GUI, even...

You're not going to be able to use a pass-through query for your subform, much as the error message suggests. That's because Access can't see the structure of the...

Use the GETDATE (or GETUTCDATE) function. To ensure that you're using the right date, store it in a variable at the start of the process, and just reference the...

Sometimes yes, and sometimes no. Depending on the app and exactly what it does, it may be more efficient to allocate and de-allocate as you go. For instance,...

Assuming that the pattern you listed is actually what you want, modulo is going to be your best bet. The modulo function returns the remainder of one integer divided...

Huh. I could've sworn I've gotten errors before trying to do table aliasing with the AS clause. But BOL backs you up on that. However, you do...

If I'm understanding your structure correctly, then, yes, your solution should work properly.

You may want to also initialize all the parameters to default values before you start assigning them. ...

I think you're preaching to the choir here...

I have run across some tasks that I think /should/ be easier in SQL. Cross-products being one of the big ones. ...

There are a couple ways to go about this, depending on some more details about how you want to go about joining/filtering the tables.

SELECT

FROM TableA

WHERE TableA.Descrip NOT IN (SELECT...

When you changed to mixed mode, did you then change your connection string to send a username and password? Preferably one that already exists on the destination server?

Are you...