Questions tagged [microsoft-access-2003]
26 questions
4
votes
2 answers
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.
Bob D
- 41
- 1
- 2
3
votes
5 answers
Do whitespace and comments in VBA code affect performance?
I am new to VBA programming. I think I have seen it somewhere but I totally forgot where I saw it. Maybe I heard it from someone.
My question: does the amount of comments and whitespace in VBA affect the code's performance?
I guess it should be the…
2
votes
2 answers
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 begin with the fact that our users started to get…
Buywuhm
- 23
2
votes
1 answer
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 several options which aren't quite right:
Hold down…
Hugh Allen
- 10,120
1
vote
1 answer
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 disappeared. No "Are you sure you want to delete this…
leeand00
- 23,552
1
vote
1 answer
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 data in each table. I tried to do that directly by…
Anna
- 23
1
vote
1 answer
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 | TV
4 | TV
5 | Table
6 | TV
7 | TV
The result…
Anna
- 23
1
vote
0 answers
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 they can then run Access 2003 programs (which link…
1
vote
1 answer
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 closed date, etc) but I don't want the customer…
user74899
- 11
1
vote
1 answer
ACCESS 2003 and MySQL - problems with linked tables
I have an MS-ACCESS 2003 application with linked tables located in MySQL 5.7.25.
The Forms and Queries work correctly with the linked tables, as long as the tables include up to X records, depend which table.
When a table exceeded X records, there…
Efrat
- 11
1
vote
0 answers
missing icons in toolbar
When I start up my database all toolbar icons display properly but after a short time some of my custom icons disappear - usually the same icons but not always. The icons still work when clicked on the empty space. All my custom icons are 16X16.…
Nelson
- 11
0
votes
1 answer
Connect mysql database to Ms Access directly
I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want these things to happen between tables.
For example,…
0
votes
1 answer
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 process"
Any idea?
Thanks
additional question:
is it…
tintincutes
- 1,267
0
votes
2 answers
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 program, then the user can make some changes.
I would…
tintincutes
- 1,267
0
votes
1 answer
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 click on the "Link Table Manager" and select all…
tintincutes
- 1,267