The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
1answer
18 views

How to have MS Access 2003 actually prompt you before it deletes a query?

I was testing this today, I opened the main database window in my Access 2003 database, clicked the Queries tab in the list of objects, selected Query1 and pressed the delete key. It just ...
1
vote
2answers
170 views

Access database error: The module name xxx is misspelled or refers to a module that doesn't exist

We are using Access database 2003 (I know, too old) with Win server 2008 in my company. We have one .mdb file split into two. A couple of days ago we had a problem trying to open modules. It all ...
0
votes
0answers
31 views

Query priority .xls VS .mdb

Hello to all the superusers! My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet I have a worksheet where using "Get External Data" on the "Data" ...
0
votes
2answers
243 views

Access 2013 file to open in Access 2003

I made Access Form which was working fine in Access 2013 and Access 2007 until I add some new features(I don't remember what) to it. After adding them, it keeps giving me error "Unrecognize file ...
0
votes
1answer
91 views

Microsoft Access 2003 on Windows 7 x64 fails to restart after loading a form that has a subform

Here's the problem: Open Access 2003 on Windows 7 and load a form that has a subform. Then close Access. Try to start it again. You can't. You click on the start menu to run it but nothing happens. ...
0
votes
1answer
263 views

How do I render boolean values as checkboxes from MS Access in Jtable?

I have a Field name in my database which, if inserted from JForms, is simply "Active" or "Inactive". It doesn't use the True/False data type. All I want is for that field to display as checkboxes ...
0
votes
1answer
22 views

Can not print in access but can print from word

I have office prof 2003. Ms Word prints fine as does excel - I can output msAccess reports into word and print them, BUT when I try to print the MS Access reports it outputs blank pages (of the right ...
0
votes
0answers
39 views

Access Query: Matching days up days of the week for past years

I have historic data in a table in Microsoft Access from seven years ago. I need to create a query with a column for each year and match up in each row the 1st Monday in 2007 with the 1st Monday in ...
0
votes
0answers
53 views

Divide one long line into shorter lines with the particular data

I have a query in Microsoft Access which extracts data from 2 tables: 'modems' and 'antennas' Headings: 'StName' 'ModemType' 'ModemInstallDate' 'ModemPrice' 'AntennaType' 'AntInstallDate' ...
0
votes
0answers
94 views

Access 2003 - SQL Project is not connected to a SQL Database

I believe there is something wrong with Access 2003 on a machine I rebuilt, possibly a missing component. There is an Access database that we use that connects to an SQL database, normally I just run ...
1
vote
1answer
202 views

How to link 2 tables so that changes in one tables would affect another

I have two tables in MS Access 2003. Both have some common columns. Is it possible that if I change the common data in one table it will affect another table. So I would not need to update the same ...
1
vote
1answer
84 views

Count Items in Access 2003

I have a table which contains a column with different items which i would like to count by there type. For example the table looks like the following: Id | Type ---|---- 1 | Table 2 | Table 3 | ...
0
votes
1answer
1k views

Access 2003: Show hidden menus

I'm wanting to investigate a problem with a former colleague's Access 2003 database/application. When I fire up the database, a default form opens; when I press F11 to look at the underlying code, the ...
4
votes
2answers
3k views

Can I restrict users from design view in Access 2003?

Can I prevent users from opening an access 2003 database in design view? I don't want others to be able to change structure of the tables, just add change or delete the records within the table.
0
votes
1answer
1k views

Open an Access database with scripting disabled (macros and VBA)

Suppose you want to examine the contents of an untrusted Access database. It seems there should be a way to open it in Access with macros and VBA disabled. Searching around the web, I've found ...
1
vote
0answers
191 views

2010 Runtime/Access 2003

I see that Access 2010 Runtime and the Redistributable are free and say they will run .mdb files. Does that mean that I can put the runtime and redistributable files on a client's computer and that ...
0
votes
1answer
87 views

MS Access report showing & instead of &

My Access 2003 database is showing & instead of & on its reports. How can I fix this?
1
vote
1answer
76 views

MS Access 2003 Forms

Is it possible to link 2 forms to insert data into 1 table? So, I have 1 form that a customer fills out and another form for the person who fulfills the request (this person enters comments, actual ...
0
votes
1answer
540 views

How do I use format in table to show the first sign of a capital letter?

Welcome, I would like to display first sign in table of a capital letter. I'm don't looking for input mask for new data, but format for existing data. I have inside existing table people Names in ...
0
votes
1answer
3k views

Link Table to Form

I've created a custom form in Design view in Access 2003. I cannot remember how to make the fields "see" my designed table. How do I do this? I know it has something to do with control source but I ...
0
votes
0answers
717 views

Linked Table Manager does not work

I have Microsoft Access 2003 installed. When I use the Linked Table Manager to link to a back end it does not work. There are no error messages. It just flashes and keeps asking begging for the ...
0
votes
1answer
431 views

The database engine couldn't lock the table, because it is already in use by another person or process

I tried to do "Split a Database" and after I clicked on the "Split" button, here is what I got: "The database engine couldn't lock the table, because it is already in use by another person or ...
0
votes
2answers
762 views

is it possible to access/write database ms access 2003 .mdb at the same time?

I have a user who created a database using Access 2003. The problem is, if he's opening the db and made some changes, the other user can open the db but they can't work on it. If he's exited the ...
0
votes
1answer
8k views

ms access 2007 link table manager

I'm new to Access 2007, and would like to know what this "Link table manager" does which can be found under database tools? I'm migrating Access 2003 to Access 2007 and found out last time that if I ...