Microsoft JET, Access, frustration, and tears... - Page 2

Scrooge McSam · 06-26-2008, 11:06 AM

"You must spread some mojo around before giving it to Ghoulish Delight again"

blueerica · 06-26-2008, 11:32 AM

Whacking the monitor, unfortunately, didn't work.

I am going to give the relinking thing a try. However, we were actually trying to create a new table and relationship and getting that error (If I'm understanding the situation correctly, which I may not. I'm only just now learning the mapping thing). I am thinking, however, that there's something to be said for going the Linked Table Manager route.

As far as the helpfulness of IT, most over there don't know what to do when it comes to Microsoft Access. So yes, that has been considered. I've just got a grudge at the moment, because IT slaps me down when I request a three hole punch or a certain kind of marker that shows up on dark catalog paper for our review. They control everything.

And this didn't help... there are people who know it, but I've been told they're not available. (Which yes, I understand that there are other projects out there, it's not what I'm trying to say... it's just that marketing gets almost no support, and has been threatened to be cut for the company, though we've tripled the revenues for my company since the department began just a few years ago)

Kevy Baby · 06-26-2008, 11:37 AM

Quote:

Originally Posted by blueerica

Whacking the monitor, unfortunately, didn't work.

Percussive Maintenance was successful? Wow - this really is a serious problem!

blueerica · 06-26-2008, 12:27 PM

Okay, what I am seeing is that if I try to link up the database on a new table, it's still not working. Or at least that's what I think happened. I am going to be studying Access tonight from a book that looks like it's bigger than the Bible. So, um, wish me luck...

BarTopDancer · 06-26-2008, 12:29 PM

Godspeed

Pirate Bill · 06-26-2008, 12:33 PM

Can you post screen shots of the list of tables? And maybe a screen shot of the error?

Gemini Cricket · 06-26-2008, 12:42 PM

Quote:

Originally Posted by Ghoulish Delight

Have you tried whacking the monitor a few times?

No fair. That was going to be my suggestion.

blueerica · 06-26-2008, 01:31 PM

Quote:

Originally Posted by Pirate Bill

Can you post screen shots of the list of tables? And maybe a screen shot of the error?

I will try to do it again tomorrow, if I can't discern more from the Access 2000 Bible. Just got out of retard-o conference calls and have to leave early.

Kevy Baby · 06-26-2008, 04:01 PM

Did you try jiggling the thingamajig and nudging the doohickey?

LashStoat · 06-27-2008, 06:20 PM

Dear BlueErica,

Before I even read Pirate Bill's post, I was going to suggest that the problem will definitely have been caused by changing the file locations during migration. The Linked Table Manager on the Tools Menu is the way to repair the file associations, but I think you said you still had trouble?

If so, is it possible that different versions (ie: restored from backups) have been mixed around, thus breaking the integrity of the system? Perhaps the file dates could help determine this. Are you able to run a Repair on the database(s)?

If you really, really get stuck, could you get the IT people to create a drive and folder structure that is identical to the original (ie: same drive letter and folder heirarchy), which will give you a stable starting point.

I hope this helps,

Love and hugs,

The Stoat XXX.

06-26-2008, 11:06 AM	#11
Scrooge McSam What? Join Date: Jan 2005 Posts: 1,635	"You must spread some mojo around before giving it to Ghoulish Delight again"
	Submit to Quotes

06-26-2008, 11:32 AM	#12
blueerica Nueve Join Date: Jan 2005 Posts: 6,497	Whacking the monitor, unfortunately, didn't work. I am going to give the relinking thing a try. However, we were actually trying to create a new table and relationship and getting that error (If I'm understanding the situation correctly, which I may not. I'm only just now learning the mapping thing). I am thinking, however, that there's something to be said for going the Linked Table Manager route. As far as the helpfulness of IT, most over there don't know what to do when it comes to Microsoft Access. So yes, that has been considered. I've just got a grudge at the moment, because IT slaps me down when I request a three hole punch or a certain kind of marker that shows up on dark catalog paper for our review. They control everything. And this didn't help... there are people who know it, but I've been told they're not available. (Which yes, I understand that there are other projects out there, it's not what I'm trying to say... it's just that marketing gets almost no support, and has been threatened to be cut for the company, though we've tripled the revenues for my company since the department began just a few years ago) __________________ Tomorrow is the day for you and me
	Submit to Quotes

06-26-2008, 12:27 PM	#14
blueerica Nueve Join Date: Jan 2005 Posts: 6,497	Okay, what I am seeing is that if I try to link up the database on a new table, it's still not working. Or at least that's what I think happened. I am going to be studying Access tonight from a book that looks like it's bigger than the Bible. So, um, wish me luck... __________________ Tomorrow is the day for you and me
	Submit to Quotes

06-26-2008, 12:29 PM	#15
BarTopDancer Prepping... Join Date: Jan 2005 Location: Here, there, everywhere Posts: 11,405	Godspeed __________________ Spork is the new MacGyver Postcards From My Edge
	Submit to Quotes

06-26-2008, 12:33 PM	#16
Pirate Bill Quality since 1973 Join Date: Dec 2007 Location: Right here Posts: 473	Can you post screen shots of the list of tables? And maybe a screen shot of the error?
	Submit to Quotes

06-26-2008, 04:01 PM	#19
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Did you try jiggling the thingamajig and nudging the doohickey? __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes

06-27-2008, 06:20 PM	#20
LashStoat There's a hole in the Bin Liner... Join Date: Apr 2007 Location: Merry Old Land of OZ. Posts: 428	Dear BlueErica, Before I even read Pirate Bill's post, I was going to suggest that the problem will definitely have been caused by changing the file locations during migration. The Linked Table Manager on the Tools Menu is the way to repair the file associations, but I think you said you still had trouble? If so, is it possible that different versions (ie: restored from backups) have been mixed around, thus breaking the integrity of the system? Perhaps the file dates could help determine this. Are you able to run a Repair on the database(s)? If you really, really get stuck, could you get the IT people to create a drive and folder structure that is identical to the original (ie: same drive letter and folder heirarchy), which will give you a stable starting point. I hope this helps, Love and hugs, The Stoat XXX.
	Submit to Quotes