By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

2003 users looking at a 97 DB

P: n/a
Ant
Hi

I have an Access 97 database sitting on a shared drive on a server, users
have various versions of Office (2000 & 2003) they all need to be able to
see the tables in the 97 application and some need to be able to make new
tables which are also shared with the other users. Can anyone tell me how I
would do this? (We donít have SQL)

Thanks for any help.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, you do have SQL - it is part of an Access/JET application - usually
called Queries.

You can link Access 2000 (& higher versions) to Access 97 using the Link
Table Manager (LTM) [Main menu click Tools > Database Utilities > Linked
Table Manager. Might be under different sub menu in version 2000]. The
data tables are in a file usually called the "back-end" (though the file
can be named whatever you like). The queries, forms, reports, macros,
data access pages & VBA modules are in a file called a "front-end."

Any new tables created in Access 2000 will be readable from Access 2003
front-ends, but you will have to link the new table to the front-end.

Read the Access Help article(s) on splitting data bases, linking tables
and creating tables

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQUnhBIechKqOuFEgEQLykQCg0PoF3IROCN/4Sp465R1H8B5P1lkAn2nI
bPn0PrhA52ui0J1WmhqB+Y6q
=5qlP
-----END PGP SIGNATURE-----
Ant wrote:
I have an Access 97 database sitting on a shared drive on a server, users
have various versions of Office (2000 & 2003) they all need to be able to
see the tables in the 97 application and some need to be able to make new
tables which are also shared with the other users. Can anyone tell me how I
would do this? (We donít have SQL)


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.