Silly question accessing underlying data. 1

[AGus01]

Hi I have inherited an Access database. When I load the Access database using MS Access (the only available utility I have to access mda files). It loads the database with a custom built GUI front end. Please can you advise how I view the underlying table structure for the database and or access the code which creates this front end interface. Would this be VB?

Many thanks in advance for your time.

Angus

 

[PHV]

Have you tried to open the db holding the shift key depressed ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AGus01]

Further, to this first message when I create a new project and attempted to import the data into the newly created project (from the mda file on a shared network drive) i get a message saying could not import data due to lack of SQL server database connctivity.

Please advise? are there some good tutorails to read up on using Access?

Your help appreciated.

 

[AGus01]

Hi PH,

Thanks for your input you have been a great help. You could not advise me on the best tutorial on getting to grips with Access? how i work with forms to work out which data is being manipulated what are the underlying SQL queries?

I come from a SQL server background if this helps using web apps.

thanks

Angus

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AGus01]

Hi PHV,

Thanks for this is all very usefull. I can see for example a form that I would like to edit has a SQL query of the following.

	SELECT Tblevents.eventid, Tblevents.eventname, Tblevents.details, Tblevents.date, qry_home_cs_all.CountOfcontactid AS Totalatt, qry_CS_status_1.CountOfContactid AS Uni, qry_CS_status_2.CountOfContactid AS Biz, qry_CS_status_3.CountOfContactid AS Other, Tblevents.event_type FROM (((qry_CS_status_1 RIGHT JOIN Tblevents ON qry_CS_status_1.eventid=Tblevents.eventid) LEFT JOIN qry_CS_status_3 ON Tblevents.eventid=qry_CS_status_3.eventid) LEFT JOIN qry_CS_status_2 ON Tblevents.eventid=qry_CS_status_2.eventid) LEFT JOIN qry_home_cs_all ON Tblevents.eventid=qry_home_cs_all.eventid WHERE (((Tblevents.event_type)=2)) ORDER BY Tblevents.eventid DESC;

1. How do I edit this query for this form in access? Cant see an obvious method?

2. Also is there a way of refactoring the SQL so I can understand it. (i get confused when i get to the brackets bit of this query?


3. Is it possible to use MS SQL to access this database. If it is possible would I risk changing the structure of the data?

thanks for your time again.

Angus