473,373 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,373 software developers and data experts.

MS Access 2000 Database Problem with Vista

yolenman
Hello -

This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge.

I'm working with a small limousine company. They presently have about 4 networked computers, all running Windows XP (w/SP2) and Microsoft Office 2000 (specifically Access 2000) - and a plain jane p3 server also running Windows XP (w/sp2) with Office 2000 loaded onto it.

These networked computers are accessing an Access 2000 .mdb file, in a multi-user fashion (more then one user is accessing this shared file at any given time) from the above mentioned server. This file is their customer database, used to run their business.

It should be noted, that this customers MUST use Access 2000, as using Access XP (2002 ?) as above causes the database to do weird things, such as create blank records, or input records that are non –contiguous. At one time, an Access database guru told me why Access XP (2002) does this, but I cannot recall the details - plus it was some time ago.

Moving forward -

This company recently purchased 4 new Dell E520's (Dual Core P4's) with the new lovely (smirk) Windows Vista 32 bit Business OS preinstalled on them.

I have installed these 4 new Dell E520 systems and networked them with the above mentioned server. All the normal stuff is working, Internet , etc etc.

I then installed (don't laugh or joke) Office 2000, just to check things out.

Now - they are no longer able to launch the Access database file (that lives on the above mentioned server), in a multi-user fashion any longer.

Example: if one user opens the file, no other networked users can open the file on the server. When the second or subsequent user double clicks the Alias to launch the database file, Vista's little blue ring goes around a few times, but nothing ever happens.

if user one exits the file, then the next subsequent user can then open the database file, but the next subsequent user cannot. so on and so forth.

Your saying to yourself - well duh - upgrade it to a newer version of Acess right? - even though it has some issues (as identified above).

Yes - I did that. I then installed and tested with Office XP (2002), Office 2003 (w/SP2), and lastly, Office 2007.

All yielded the same results, I cannot run the file in a muli-users fashion, as before in the XP environment.

I tried setting the msaccess compatibility mode to both Windows XP SP2 and Windows 2000 (for each verion of the Office apps above) - still no luck.

I tried seeting msaccess to run in Admin mode (on all above versions) - no luck

I tried Admin mode & the above compatibility mode options together - no luck.

I tried updating the access 2000 .mdb database file to the Access 2003 format using the Access 2003 conversion tool, and attempted to perform all the above testing routine again - even with Office 2007 - Still no multi-user support.

At this point - I'm at a loss to get this to work, so I have come here seeking guidance, answers, help, etc etc.

Can anyone offer me some input as to why I'm unable to run this file in a multi-user fashion under Vista and (pick your version of Office), as I used to be able to do in the XP enviroment ?

Any assistance would be greatly appreciated.

Thanks

Leonard
Mar 21 '07 #1
13 13223
MMcCarthy
14,534 Expert Mod 8TB
Hi Leonard

Open Access. Go to Tools - Options and set the Default Open Mode to Shared. When you reinstalled Access it probably reset to Exclusive. Also make sure that the Default Record Locking is set to Edited Record.

Mary
Mar 21 '07 #2
Hi Leonard

Open Access. Go to Tools - Options and set the Default Open Mode to Shared. When you reinstalled Access it probably reset to Exclusive. Also make sure that the Default Record Locking is set to Edited Record.

Mary
Hi Mary -

I checked the settings as you pointed out. It was already set to Shared, and I made the change to Edited Record. It does not seem to help - only 1 user can access the mdb file at a time....

Any other ideas ?
Mar 22 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Hi Leonard

We have had a couple of other posters on with similar issues. One of whom solved their problem initally by removing IE7. The then discovered this.

http://windowsxp.mvps.org/networkfile.htm

It seems IE7 and probably Vista are treating mde's as executable files. Anyway see if this helps to resolve your problem.

Mary
Mar 22 '07 #4
Bill C
3
I have an Access application that is the 2002-2003 version and I am experiencing the exact same problem. I really don't want to remove IE7. Does Microsoft know about this?
Apr 16 '07 #5
ADezii
8,834 Expert 8TB
Hi Mary -

I checked the settings as you pointed out. It was already set to Shared, and I made the change to Edited Record. It does not seem to help - only 1 user can access the mdb file at a time....

Any other ideas ?
For testing purposes only, and only with a reliable backup, eliminate the Front End/Back End architecture. Import all Objects from the Front End DBs into the Server Back End, set it to Shared Usage, then see if it will now allow multiuser access. If it does, it may be some sort of connectivity issue with the Front Ends.
Apr 16 '07 #6
Bill C
3
More things that don't work! I trie removing ie7 and replacing it with firefox. It didn't help!!!
Apr 21 '07 #7
I'm pretty sure with Vista's patch guard working in the background at all times making sure nothing gets it's hooks into the kernel the shared function which should have been turned on by default as everything else is in Microsoft you need to 'downgrade' to IE6, at least that's what we need to run in the c-lab at school to enable file share. IE7's new security features interfere with file share and a number of other programs we use such as MML's due to active X issues. I am far and away from an expert, but I listen and watch and this sounds like the same issues they're going through at school. Everyone will need to dump their hardware and move to a 64 bit platform in order to gain compatibility when changing over to Vista, or have headache's constantly. Good luck to you. Joe
Apr 21 '07 #8
Bill C
3
Here is a temporary workaround that may help.

I tested mt Access 2003 application today with two other computers one with Windows xp Professional and the other with Windows Xp Home edition. I first ran the application locally on the computer with Vista Home Premium then had the other two computers which are on a local LAN run the application at the same time and they ran OK including file updates.

I logged into the vista system as a user (not administrator) when I ran the Access application.

I installed Office Professional on the Vista computer
The two XP computers are running Office 2003 Professional

I set the folder to share for everybody with no password, and permissions to Read and Execute, Read, Write, and List files

I set the application to Read and Execute, Read, Write, etc.

Good Luck
Apr 24 '07 #9
SLK
1
I'm having the same probem with two Vista Home Premium computers which are networked and running Access 2003 in an Access 2000 mode. It appears that you have to open the Access database in a certain order. If I open the database from the Main computer (where the database resides in its public folder) I cannot open the database from that same public folder on the other Vista machine. The Vista ring just spins until I close the database from the Main computer and then the database opens from the other computer and then I can open the database from the Main computer and share the database. However, I'm worried about corruption and I probably going to the hotfix listed in Microsoft's KB Article No. 935366 because I have also received database corruption errors. I've also added the Main computer to the trusted sites in IE7 and it did get rid of the security notice, but didn't resolve the problem.
Apr 26 '07 #10
Hi There,

I have a similiar problem and a workaround

I have a network of 15 xp machines sharing a acess 2000 .mdb thats located on a SNAP server( simple network attached storage using a workgroup)

The setup has functioned perfectly for years but last year there was a microsoft update that messed it up.

Freshly installed xp systems have the same difficulty you speak of opening the .mdb file directly or from a shortcut.

They can however open the file just fine if you
1) start access first
2) open the .mdb file from inside access.

I've tried the internet exporer stuff and even went so far as to create a signed certificate project thing but have had no success.
Jun 1 '07 #11
Lance1
1
I had the same problem. 4 Vista machines and a shared Access 2000 database file that would only open on one machine at a time.

The solution:- http://support.microsoft.com/kb/935366

Phone Microsoft on 0870 60 10 100 with reference to Article ID :935366 (above)

They will email you the patch. Install it on all machines affected.

On the client machines you must open the Access program first then open the database file.

Works a treat for me with no sharing or rights issues.
Jul 4 '07 #12
MICROSOFT FIX THIS SHARE .MDL SHORTCUT PROBLEM.

I have the same problem. 5 Vista machines and a shared Access 2000 database files that would only open on one machine at a time.

MS Longcuts - Unless You Do These Extra Steps: (It is a pain in the neck)
1) Start access first
2) open the .mdb file from inside access every time.
That means no Shortcuts only Longcuts.

NONE OF THESE BELOW WORK WHAT A JOKE:
I Tried This: MS Download Fix (http://support.microsoft.com/kb/935366)
I Tried This: Option 1 (http://allenbrowne.com/bug-17.html)

PS: On Another topic. Also Sendkeys command doesn't work in MS Access Visual Basic.
Oct 4 '07 #13
got this from another web, it worked for me, damn pesky IE7 junk

Click on the Start menu, and open the Control Panel.

Open Add or Remove Programs.

On the left, click on Add/Remove Windows Components.

Uncheck Internet Explorer Enhanced Security Configuration.
Jan 30 '08 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

37
by: Allen Browne | last post by:
If you develop for others, you probably have multiple versions of Access installed so you can edit and create MDEs for clients in different versions. This works fine under Windows XP, even with...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
2
by: Ntl News Group | last post by:
Is it possible to run Access 97 on Windows Vista? I have installed Access 97 and Access 2000, when I run Access 2000, then try to open Access 97 it says it cant find the windows registry entries?...
3
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require...
2
by: Wayne | last post by:
I'm experiencing the following intermittent problem with Access 2003 (Access 2000 file format) under Vista. Sometimes when I close a database by closing the database window I get the following...
4
by: Cindy H | last post by:
Hi I am currently using Visual Studio.Net 2003 running on Windows Server 2000 operating system. I have used Visual Studio.net 2003 connecting to Access 2002 databases in the pass with great...
4
by: PabsBath | last post by:
Hello, help please. I have been pulling my hair out for a few weeks now and been looking on the web for answers but not managed to find anything!! I'm currently operating a small (2mb - approx...
10
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the...
1
by: teddysnips | last post by:
I have a new client who has an Access 2000 database that used to run under Windows 2000 Pro. They have just "upgraded" to Access 2007 under Vista, and the old database stopped working - buttons on...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.