Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

transforming access as a front end to sql problem

Status
Not open for further replies.
meekon5

meekon5

Programmer
Dec 12, 2000
15
DE
I have created an access database as a front end, linked through ODBC to our SQL server tables for a certain project.
The access database is a convenient report generator for the project.

I am also importing the same tables into another (identical) version of the database to zip and send to our off shore subsidiaries (not having time to create VPN or other links into the original).

My problem is that certain of the queries (though working in the SQL linked original) stop collecting data as soon as the tables imported and not linked.

Anyone got any pointers on this one?
 
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
345
dhookom
dhookom
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
551
mikrom
mikrom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
844
strongm
strongm
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
405
rashmibala
R

Part and Inventory Search

Sponsor

Back
Top