The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
2answers
50 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
47 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
136 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
20 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
33 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
50 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
68 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
167 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
74 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
737 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
183 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
75 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
73 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
356 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
1answer
317 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
717 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
7k 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 ...