0
votes
2answers
82 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
54 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
0answers
34 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
51 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
74 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
171 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
77 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 ...
0
votes
1answer
804 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 ...
0
votes
1answer
78 views

MS Access report showing & instead of &

My Access 2003 database is showing & instead of & on its reports. How can I fix this?
0
votes
1answer
373 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
2answers
721 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 ...