o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

How to open ACCESS to see tables -

I've never used ACCESS before - it's about to become apparent!

I just got sent a .MDB file and I want to extract some data. How do you launch ACCESS so that you are in design view or whatever you have like that in ACCESS?

 

[Access 2003] Cannot open any more tables -
Hi, I'm getting the above message in Access when hovering over table links. Once it appears I can not - Save - open connections to other dbs - open tables/queries Have MS 'upgraded' recently and messed up the memory/open/closing of tables? Is there a fix (apart from cl

Open Access DB Tabels From Win XP -
hello Unable to open database with full access to tables through shift / enter function after Microsoft XP was installed. Database was created in Access 2000 with a main switchboard and limited menu & toolbar options. How can I access the database tables, form design to make c

Paradox tables in Access 97 -
Does anyone know a way to open paradox tables and get the data to access 97? Apparently, these files are not supported in access 97, and I can't figure out how to open them in VB. Anyone have a solution?? Thanks In Advance

Loading mutiple tables into a data adapter {Resolved} -
Hello I'm converting from ADO/Access 2000 to ADO.net/SQL. I have an app that works with a DB with 6 tables in it. When the app is running the tables are accessed read only and a combo of user inputs and data from 2 of the tables is used to present data from the other 4 tables to

accesse XP Problem -
hi all i have office xp and i creat an access database on that v. but the activiation period expir when i try to open my database on access i found all tables are losed please if there is any way to open and return all tables again thanks in advance

Urgent - Gurus ;) **Resolved** -
Hi, I have a mdb (access 97) which I've been developing - and I'm going to upgrade to 2k. What happens if I forget to relink the tables from Access 97 ? I'm asking this 'cause I've just ran 2k and converted the front end (code etc - which worked beautifully considering its o

Help Urgent.....Please I am begging!!!*Resolved* -
I am having a problem I have had to build a VB system around an existing access system. I am using ADO from VB to connect to the Access DB... no problem however in the access db the are some linked tables from SQL Server that a link via a ODBC Datasource. My problem comes in when I tr

Newbie need help with MS Access -
Hi, I usually only use MS Access a my database manager. BUT today I have to create a module. Well I guess. I need to do a massive change to the values of some tables so I have to get recordsets, apply updates on many tables. -- I'm blocked on the first lines of code whi

[2005] Finding locations of linked tables in MS Access -
We have a large number of Access databases on our network and I'm trying to build a list of the tables in each DB, and in particular, where they are linked to. I've written a quick VB.Net app which I can point at an Access DB, which retrieves a list of tables using the OleDbSchemaGu

Very noob question on SQL (Creating a new DB) -
Hi! I've Installed Microsoft SQL Server 2005 And VB.Net 2005. Now i want to make a new SQL Database, tables, insert the values etc. But NOT from VB. Like i do in Access: I open access then i go to new Empty Databases and i start to work. How do i do this in Sql? Can i even see

Table attributes - what's goin' on -
I'm writing an application to open a database and list all the tables in a combo. But, when I use my 'For Each Tabledef' loop, it lists the system tables as well. So, I have attempted to use the attributes property of my TableDef to determine which tables to leave out of my combo.

Regaining Access to tables after recordset closed -
I am a novice at VB and have created an aplication that accesses Paradox version 3 tables. Everything is fine until I close the tables, then want to regain access to them, The tables have been moved from their original location during runtime. I have tried to programatically insert th

Relinking tables in an Access database with VB6 -
I have a local access database which my VB6 can open. There are a number of tables which are linked to an SQL Server database. Can anyone tell me please how I relink the tables via my VB app should be SQL Server name change? Thanks in advance. BB

New Window in Access 2000 -
In Access 2000, Whenever I open a query or table or form, it opens in a new window. So if you look at the taskbar, all the open windows are visible. This works fine but if I open two access database and then open the query's or tables, all the windows are open in the taskbar and I hav

open Access Database from vb -
I know it easy for you guys, but I just want to be able to open Access Database from a vb form. also I just wonder if it's possible to have Database open from CD. maybe have the tables on hard drive and the front end on CD so i can enter data. thank you just want to mention I am

Rename MS-Access tables thru code -
Hello, I am looking for a way to rename MS-Access tables thru code. It doesn't matter to me whether its DAO, ADO/ADOX, Access automation or something else; this will be a "quick and dirty" utility function I will run. The background info is that I will be importing a boat

Re-establish linked tables in Access with VB: Help! -
I have an access database that has tables linked to tables in two further access databases. What I cannot work out is how to re-establish the links to the tables after installation so that the paths to the databases/tables is correct. Is there a way to call the linked-table manag

SQL JOIN question -
I am using creating a SQL statement that uses Left Join. I have it working just fine with two tables in the same .mdb file. But what do I do if I want to create a recordset based on two tables in different Access databases? Is this possible? If not, how many tables can one "

Relinking SQL Server tables to an Access Database with VB6 -
I have a local access database which my VB6 can open. There are a number of tables which are linked to an SQL Server database. Can anyone tell me please how I relink the tables via my VB app should be SQL Server name change? Thanks in advance. BB

Joining MS Access 2000 DB Tables -
I am encountering a problem in the MS Access 2000 Database tables. I had designed the tables in MS Access 2000 application. I did all my home-work there, that is: 1. Created the tables 2. Created the Primary keys 3. Edited the Relationships to enforce data integrity 4. and

I'd like some help with some strange logon procedures! -
Hi All... I'm working with an access database that has linked tables to a local SQL server. I have to automate a process that throws SQL against the server to generate reports daily. Now... the problem: Since I don't have to log into the access database, but I do to the SQL Se

odbc returns non-static data to Access -
I have an Access database that links to two Visual FoxPro tables. Queries compare an Access table to the VFP tables to determine which rows in Access aren't in the VFP tables. Results for the same query vary by a couple each time I run the query - everything is local, nothing "

Getting tables -
I have an Access database wich contains forms. WHen I open the database, I just see the form and I can't see the tables and the fields. It has any kind of protection. Is there any way to know how many and the names of the tables that it have? Is there any way to see this structures

How to open ACCESS to see tables -
I've never used ACCESS before - it's about to become apparent! I just got sent a .MDB file and I want to extract some data. How do you launch ACCESS so that you are in design view or whatever you have like that in ACCESS?

Database tables and their fields -
Hi I'm using an Access database with ADODB. I don't have any collection that will allow me to get the names of the tables in the database, and their fields. I don't care if I have to open it a different way, then close it and re-open as I do now. I just want a list of tables a

copying HUGE amounts of data from one recordset to another -
Hi, My client gave me a few dBase tables containing the information they want to use. I've written a small vb app using ADO and ADOX to create a new MS Access database with all the tables and fields, exactly as they are in the dBase db. After that, the program opens the 2 tables, an

Oracle and Access query -
Situtaion: I have an Access 2000 database with some Oracle linked tables and some local Access tables. I need to run a query through VB that contains both the local Access tables and the Oracle linked tables. Problem: When I run this query using ADO connecting through the JET 4.0,

Restricting The Ability To Link To SQL Server Tables via MS Access -
My programming partner and I were just discussing various CONSTRAINTS that we are going to place on some of the fields on one of our database tables and the issue of linking to these tables through an ODBC connection using MS Access came up. Via the app that I'm writing, our uses sh

vb -> opening Protected mdb -
Hi I am trying to get my vb proggy to open an instance of MS Access 2k, and then open the mdb tables I am using. However, I have protected the mdb with a workgroup. How would I go about doing this ? The code I have so far is below (myfile being the workgrouped ms access file)

importing tables from ms access to mysql -
i'm going to convert my database from ms access to mysql... i already know how to create a database and tables in mysql.. but the records are just too many to input.. it will surely take time.. how can i import data in my ms access tables to the tables in mysql? anybody knows ho

Making Report Using 2 Diff Tables in Access -
I Want to combine 2 child tables in Access ,where both the tables have diffirent records?

Help w/DB & ListBox -
Could someone help me figure out how to open a DB with a Common Dialog Box and have a listBox populate itsself with the names of the tables in the DB, for the user to choose which table to open. Without knowing the names of the tables beforehand? Any input would be great. I'm using DAO

Access Project Problem -
Hi! I have an access project open, and if the PENDING command button is clicked, it needs to close the current access project and open another(which has its own set of forms and tables). Does anybody have an idea how to do this.

Access, Objects and ODBC... -
Hello all, I have an Access '97 database that has a number of tables in it linked to SQL Server via ODBC (don't ask why - let's just say I'm trying to maintain someone else's crappy system!!) In Access, whenever you go to look in one of these linked tables it pops up the Connection d

MS Access Linked Tables question -
Tiny bit of background: I have an Access 2000 database that uses several linked tables (Oracle and Firebird). Occassionally the ODBC connection fails and I have to use the linked table manager to refresh the links. The problem: I recently installed Access 2003. One feature I l

Accessing Paradox -
Hi! I'm trying to access paradox tables using DAO in VB 5, but when i'm trying to open a table, for example EmpPrin, VB send me the following error: The microsoft jet database engine cannot open the file <pathfile> . It is already open exclusively by another user or you need

Isolating user created tables from Access 2K -
I need to dynamically delete tables (not the queries) from an Access 2K database. I used this in a button: Private Sub Command1_Click() Dim dbsTWH As Database Dim tdCount As Integer Set dbsTWH = OpenDatabase("db1.mdb") tdCount = dbsTWH.

ACCESS (Querying a Query) -
Hi. I am trying to populate a data bound grid with information from an ACCESS Database. Since the information was coming from a number of tables, I decided to simplify the process by creating an ACCESS Query beforehand Let us say I have 5 tables. My Query.. Query1 has 15 recor

join 2 tables or open a rs -
I have a big table with around 50 columns. I've to upload it to a SQL Server 6.5 and then write an asp page to search the records. Since SQL 6.5 has a limit on the length of a row, I've to vertically partition my table into 2. These two tables have exactly the same number of records a

How to access multiple tables in VB.NET -
How to access multiple tables in VB.NET? We have 4 tables(in MSAccess) of which one is not related to any other table. To access all the 4 tables from a windows form should we have more than one data adapter and data set? OR Can we have independent data adapters and sets for e