I'm working with link tables that connect via ODBC
I need a method or function that show me on the screen the name of the DB
(in the SQL server) that I'm connecting to.
Thanks.

I need some help with either reseting my security features all
together or knowing how to log out. I inadvertantly neglected to give
all my users any privaledges and now you can open the program but no
one can look at anything. Any suggestions would be great thanks.

Is there a keyboard combination I can press to go back to the beginning of
the next line?  I'm using Access 2007 and when I have a lot of database
updates to make, I just want an easy way to go back to the beginning of the
next line.  The enter key just takes me to the next cell.

I have a database in which I use to print mailing labels.  The text is
aligned to the right edge of the label.  For some reason, sometime
when I print, it cuts off half of the last character in each line on
the right of each label.  I know it has nothing to do with printer

I have ACESS DB in that I have SQL Server table linked thru ODBC DSN of type
SQL Server and its name is 'testSQLServer'
I am accessing Access DB from my ASP page and firing a query on a linked
table. I get the below error when I open a recordset with the query on the

I have a networked database that is used by my department (about 20 users).  
Each user has a copy of the front-end on their local machines that is linked
to the data of the back-end on the network.
The problem is that I need to backup the back-end every day.  This is

Hello I have a macro go to record/new on my form and its not working on some
of the computers at work it keeps giving me
Macro Name: mcr_NewRecord
Condition: True

In earlier version of Access it was possible to package the database to be
used on a computer that did not have Access installed. I have just bought
Office Ultimate Edition and wondered if it was possible to do this with
Access 2007?

Is that like VLOOKUP in excel? And is there just a LOOKUP?

I need to subtract today’s date from 2/1/2007.

First off I have tried to explain as bvest I could on what I am trying to do.
If it is a little long my apologies.
I have made a database in Access 2002.  I have finally got the fields listed
and the form setup to my liking. The last step (which is where I need help)

I tried to use SUBSTR and SUBSTRING in a SELECT sentence but it was not
recognized. I changed by MID MID$ LEFT LEFT$ but it still not working. The
error says "Undefined function 'MID' in expression". How can I extract a
string from a field in SELECT? Thanks.

My wife's hard drive crashed and was replaced with a new one. After backing
up the files and putting them on the new hard drive she tries to open an
Access file created in Access 2003 and she receives the following error:
"You do not have the necessary permissions to use the ...

I have two tables A and B (ID is the primary key), and a query C. Query C
catches ID from table A. I have created a form; this form can select ID from
query C. What I need to do is:
If the selected ID is in table B, I will show all the items in table B in

We have about a 45Mb Access database on our internal network.  It is
currently split, with the front ends on user's desktops and back end on
network.  The database runs well when people are at the office site.  When
logging in from locations away from the office the database ...