Strange Happening with database

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Kula

Thread Starter
Joined
May 6, 2000
Messages
604
Some time ago, I created a database at work, which is on a network so everyone who had rights to a certain folder on the network could use it. Everything has been fine until recently. The person who used it most, had problems (not related to the database) with her pc. Our IT dept, said something about her profile being corrupt, so they deleted it, and created a new one. Since then, although she can get into the database, she can't link up to the external tables that retrieve the data. It can't be the database, as because we have 'roaming' profiles, I can log on to her machine, using my logon, and use it without problems. Initially, we had to log on to an external server when using the database, to get access to the tables. Our IT can't work it out. IT's solution is for her to log on as me. This isn't an ideal solution. Everyone has access to my desktop, emails, documents. The IT guy is saying it's my database that's the problem, but how can I use it on her machine, but she can't? We've even tried, her logging on to my machine to use it, under her log in, but still it doesn't work. Just wondered if anyone has any ideas, as our IT don't.
 
Joined
Jun 8, 2001
Messages
2,583
What type of database\version is this? What error message does she get? Can the user go to another PC and link the tables? Does she map network drives the same way? Are there ODBC connection/settings in play?
 

Kula

Thread Starter
Joined
May 6, 2000
Messages
604
It's Access 2003, and there are ODBC connections involved. I don't know about the mapping to drives, but in answer to your other question, she can link to them on other pc's, but only if she is logged on as me. I can access them on her pc, but she can't.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
As it is Access 2003 does it have any "User Level Security" in place, ie do you have to Log In to the actual database?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top