Access Security Issue!

[stuaz]

I have a database which i created in 2007 then saved it as a 2000 format. I then placed this file on a network area so that more than one computer can access it.

I have Access 2000 computers able to access it and use it fine, when i have two user using Access 2002 when they try and open it from the network area it says its not a trusted source and i should copy it the desktop and use it.
I don't want to do that becasue then its not on a centraliesd point. Any tips?

Thanks

Stuart

 

[Len Boorman]

Create a 2002 Interface and use linked tables so that everybody uses/updates same data source

I have 97, 2000 and 2003 users and have to support all versions using same data source.

Linked tables is the solution.

I create a Data Repository in 97 and then all interfaces use these tables via links

L

 

[angelgirl]

Len ~ How do you create the linked tables? I have the same problem that Stuart has with Access 2002 users not able to view a centralized database on our network. Users in newer versions of Access do not have this problem.

 

[Len Boorman]

You do not actually create linked tables. You actually link to tables. pedantic I know and generally referred to as linked tables.

So in the "Interface" version

File
Get External Data
Link Tables

gives you a dialogue box where you can navigate to the database containing the tables you wish to link to.

Click on the database and a sort of database window will open displaying the tables. Select which one you want and OK

whizz whizz and the tables appear in your interface with a big marker indicating they are linked tables.

Couple of gotcha's to be aware of

1) Remember that when you are using linked tables they are not copies. You are dealing with the real thing. Delete a record and it goes from the source.

2) You want to expertiment so you copy the linked table and play around. WRONG. All you have done is copy the link. You have just screwed the original data set.

3) If you browse to the database whose tables you wish to link to then you will generate a relative link. Lets say you are linking to a network drive that you know as G:\fred\charlie. That's okay for you but if I have that drive mapped as S:\fred\charlie then when Itry to use teh interface with linked tables it will fail.

4) to link using absolute references when the dialogue box opens type in \\server\path\path etc to get to the point where the database is stored. press enter 9I think and you can then select the database as before. The links all look the same but there is a significancant difference.

Where there is a mix of Access versions as I have to support I use Access 97 as the repository database and then everything will link to that. Then simply interfaces with linked tables for each version

Len