Access 2007

Database being auto duplicate when exit.

hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...

Access 2007 IIF statement in query criteria

This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...

EMAIL From MSAcess 2007 to Oulook/Exchange Server

My mail email routine for sending emails with a .doc attachment work fine using MSAcess 2003 but don't work using MSAcess 2007 Software/Hardware used: Office 2007 OS = XP

Forms in Access 2007

I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...

Capture SQL Server logged in db User name in Access 2007 Accdb

I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

ACCESS 2007 and SQL Server 2005 Schema Updates

We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

T-SQL query to ACESS 2007 database

I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Microsoft Access table dropped primary key and index

I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Access 2007 on an Xserve Server

Is this possible to take a MS Access Db and run it on the Xserve Server

Access Switchboard Problem

The title of the switchboard changes to the title of one of the items. I can't figure out why.

External document used as an Access Form?

I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...

conversion from FileMaker Pro to Microsoft Access database

How do you convert filmaker pro 7 database to an access 2007 database file

With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form...

Access Reports to PDF file

Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...

Execute a query on table in different db that will make a table in currentdb

Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places... The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I...

Access database table linked to Excel file question

Can multiple instances of the same access database be open when linked to same excel file?

Duplicating Form FieldsAccess 2007

I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.

Populate Access 2007 object in form

I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

Performance Issue with an Access File Updated through an .accde file with Linked Tables

I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...