relationships window problem

smig · Nov 2, 2010

I have a problem with my relationships window
some of the tables are in place I can't see.
I can see the lines connecting to them, but not the table.

any idea how can I bring them all back to center of screen, and rearange ?

Thanks,
Tal

boblarson · Nov 2, 2010

Sorry but it is all MANUAL up there. I know it can be a pain - especially if you do something which makes Access rearrange them. You can work hard to set them just right and then you go and do one small thing and BAM! it is now back to all crunched together.

smig · Nov 2, 2010

I don't care if they all will be crunched together. this will be OK. I'm ready to rearange them.
problem is I can't araneg them as some of them are out of my screen. I can't see them, and can't do any scroll to see them.

boblarson · Nov 2, 2010

smig said:
I don't care if they all will be crunched together. this will be OK. I'm ready to rearange them.
problem is I can't araneg them as some of them are out of my screen. I can't see them, and can't do any scroll to see them.

Can you post a screenshot? I don't think I've ever not been able to scroll to them.

smig · Nov 2, 2010

look at the line on the right
I guess it's because I opened the database on machine with Hebrew menues (Normaly I only use Herew enabled)

boblarson · Nov 2, 2010

Interesting. About the only suggestion I can make is to import everything into a brand new blank database and UNCHECK the Include Relationships checkbox under Options so that you can then go set them again.

smig · Nov 2, 2010

thanks,
guess that's what I'm going to do.
not even sure I realy need the relationships as the user will never have a direct access to the tables.
all work done in forms. most of them use recordsets, only few use querys. but never a direct access to tables.

I have a weired phenomena with one of my tables. not even sure it's related to relationships. this is the most use table in my application.
once in a while I find a record with weired data on it. weired key numbers, and even unrecognized characters in other fields.
to delete this f*** record I must delete all relationships for this table or I get an error: the search key does not exist 9or something similar)

any idea what can cause this ?

boblarson · Nov 2, 2010

That is data corruption. Is this a split database (frontend/backend with the frontend as a COPY on EACH user's machine)?

smig · Nov 2, 2010

I know it'a a data corruption, I just try to find what can cause this.

yes, it is a split db, with a copy of the fe on each machine.

boblarson · Nov 2, 2010

A disconnection of the LAN (no matter how brief) can cause it. A bad Network Interface Card (NIC) on either the server or one of the computers can cause it.

smig · Nov 2, 2010

thanks
so I guess there is no real solution for this

smig · Nov 3, 2010

I can't fix everything, and can't check my costumer network.
will using recordsets, and temp tables instead of using direct connection (or via query) solve this problems?

boblarson · Nov 3, 2010

smig said:
I can't fix everything, and can't check my costumer network.
will using recordsets, and temp tables instead of using direct connection (or via query) solve this problems?

Nope, sorry. But, if you want to make it a little less susceptible to data corruption you can use SQL Server or SQL Server Express as a backend. That should help with the data. The frontends may corrupt but you can easily give the person for whom it corrupts a new copy.

SQL Server Express 2008, by the way, will store up to 10Gb of data.

smig · Nov 3, 2010

weired enough this data corruption will be in one table only - the most used one.
that's why I had the idea that using recordsets and temp tables will eliminate the problem.
by temp tables I mean tables that are on the front end machine that store a copy of the data from the back end.

boblarson · Nov 3, 2010

smig said:
by temp tables I mean tables that are on the front end machine that store a copy of the data from the back end.

But then how would you SYNCH it all up in the main backend? Not a pretty picture really.

smig · Nov 3, 2010

using single record forms, and recordsets.
preventing the user changing data in the multiple records (continious)forms. I also want to do this to have more control over what users are puting in.
as recordsets don't keep constant connection to tables I expect less problems.

boblarson · Nov 3, 2010

You can use disconnected ADO recordsets but I've not had to use them. You might post a different question about disconnected recordsets on the forum and then PM Banana and ask him to look at that thread and also let him know that I suggested you PM him to look.

dfenton · Nov 5, 2010

I'm really confused. There's a horizontal scrollbar at the bottom of the relationships window -- doesn't it work? If so, scroll to the right until you can see the table, then drag it as far to the left as possible, then scroll over to the left, and drag it some more.

This same thing sometimes happens with the database window itself (pre-2007), i.e., the thing ends up several screens down and over from the main Access window, and the only solution is incrementally scrolling and dragging until you get back to the main window.

I have always wondered where this data is stored. I don't believe it's in the registry.

boblarson · Nov 5, 2010

dfenton said:
I'm really confused. There's a horizontal scrollbar at the bottom of the relationships window -- doesn't it work? If so, scroll to the right until you can see the table, then drag it as far to the left as possible, then scroll over to the left, and drag it some more.

This same thing sometimes happens with the database window itself (pre-2007), i.e., the thing ends up several screens down and over from the main Access window, and the only solution is incrementally scrolling and dragging until you get back to the main window.

I have always wondered where this data is stored. I don't believe it's in the registry.

David - In this case the horizontal scroll bar was as far to the right as possible but the table was beyond it.

smig · Nov 6, 2010

as bob said I can't scroll to these tables.
probably because I worked on Hebrew machine at some point.
I imported everything into a new db and now it's OK

relationships window problem

Registered User.

Smeghead

Registered User.

Smeghead

Registered User.

Attachments

Smeghead

Registered User.

Smeghead

Registered User.

Smeghead

Registered User.

Registered User.

Smeghead

Registered User.

Smeghead

Registered User.

Smeghead

AWF VIP

Smeghead

Registered User.

Similar threads

Users who are viewing this thread