Ask a Question related to Coldfusion Database Access, Design and Development.
-
RuBot #1
Using MS Access, is it difficult to query twodatasources?
I am debating whether I should create all of my tables within one database, or
whether it would be simple enough to create two datasources.
I have an employee database, and I'm creating a database of webpages, which
will need links to the employee IDs. Create in the existing DB or create a new
one?
RuBot Guest
-
Access Query
Hi I have written sql query in access database... SELECT email_info.* FROM email_info WHERE email_id='john@test.com.au' AND email_date + 7 < ... -
MS Access query in MX 7
Hi, Please help me. Oour company's websit was located in HostMySite. In the recently, they upgrade their server to Windows 2003 and upgrade... -
Access query help
Hi everyone, I need to modify this query from SQL Server for use in Access. Can someone please help me?! SELECT DISTINCT TOP 100 PERCENT... -
Access Query in ASP
I would like to use Accesss queries in ASP. This queries are done before in Access. I Know that i can access these queries using Visual Basic as... -
MS access SQL query help!
I am creating a database for sports league. I have a table of Leagues, Teams, and Games. I trying to get a listing of the games but I am getting... -
Dan Bracuk #2 Re: Using MS Access, is it difficult to query twodatasources?
same db
Originally posted by: RuBot
I am debating whether I should create all of my tables within one database, or
whether it would be simple enough to create two datasources.
I have an employee database, and I'm creating a database of webpages, which
will need links to the employee IDs. Create in the existing DB or create a new
one?
Dan Bracuk Guest
-
mxstu #3 Re: Using MS Access, is it difficult to query twodatasources?
You can certainly create separate datasources, but the real question is whether
it is necessary. Without much information to go on, it sounds like "employees"
and "webpages" are tables. If that is the case, then there doesn't seem to be
any reason to put them in separate databases. If not, can you provide some
more information about the data and I'm sure someone can assist.
mxstu Guest
-
quiero mas #4 Re: Using MS Access, is it difficult to query twodatasources?
its certainly easy to manage from one db - the more tables the quicker your quieries will be returned too .A couple of data sources, i imagine, may be slower.
quiero mas Guest
-
RuBot #5 Re: Using MS Access, is it difficult to query twodatasources?
Yeah, I went ahead and created them as separate tables, but I have had
instances where I needed to use two existing datasources, and I believe I ended
up being able to impor the tables and abandon the other database.
Now I just want to know what a query would look like. Thanks everyone!
RuBot Guest
-
Scott*e #6 Re: Using MS Access, is it difficult to query twodatasources?
quote: "Now I just want to know what a query would look like"?
what do you mean?
Scott*e Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
