MakeTable queries when using SQL backend...

[Guest]

The Access database forms and tables were all originally done in Access
2000...but now the tables are stored on the SQL server and linked in Access.

There are 5 users...each are using their own copy of the Access
database...although their databases all link to the same SQL server database
for the stored table data.

There are a lot of queries I have to redo because the new linked tables all
have dbo_ in front of them...

Question: there are a lot of MakeTable queries in the Access database...and
new queries are run from the data in the newly formed table.

BUT...where they all have their own copies of the Access frontend won't the
newly formed tables be just local to their database copy...or is their a way
to make the MakeTable query create a new SQL table??

I'm not that sure about the SQL server side of this whole thing...

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can remove the "dbo_" from the front of the table names - so you
won't have to change all references to the original table names.

Make Table queries:

Depends on what you are doing w/ the tables made during the Make Table
run. If they are temp tables - just continue using them. If they are
tables that will be around for a while, you'll have to explore SQL
Server stored procedures & create table permissions.

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

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

iQA/AwUBQd2ZVoechKqOuFEgEQJj4QCgt2OhC4HChsRHkNk4VZZIBx8xAgwAnRRx
N7+DErLBSyqUav89R9tDwNR2
=2qm2
-----END PGP SIGNATURE-----