Hi All, I have a problem to open secured access 2000 database. I have two files MDB and MDW. One week ago I could normaly open MDB using MDW file but now I can't. I'm getting such message when I try to login: "You do not have the necessary permissions to use the object. Have your system administrator or the person who created this obj...
I have a MS Access database (Access 2002, for the record). It has a column whose name contains a question mark, say, for example table "Users" with columns "uid" and "isAdmin?". I need to connect to this database via ODBC, and query for this column, along the following lines: select [uid], [isAdmin?] from Users order by [isAdmin?]; ...
Hi, I am having troubles with one of our applications. It's .NET 3.5 32 bits process. Upon startup we open a .mdb to read a few "metadata" values. This works on hundreds of systems, but we have a customer with a TabletPC and problems. The operating system is Windows XP Tablet PC SP3, 32 bits, bla bla. Nothing unusual. It has .NET 3.5 (f...
Hopefully someone can help me out with this. I have written a query in Access 2003 that combines a linked table "taxon_group_max_per_site" and a cross tab query "Distinct Species by group_Crosstab". From the table I have the field "Taxonomic Group" and "Max", and from the cross tab the fields "Total_Of_Species_S". The table and the cro...
here is the current complex query given below. SELECT DISTINCT Evaluation.ETCode, Training.TTitle, Training.Tcomponent, Training.TImpliment_Partner, Training.TVenue, Training.TStartDate, Training.TEndDate, Evaluation.EDate, Answer.QCode, Answer.Answer, Count(Answer.Answer) AS [Count], Questions.SL, Questions.Question FROM ((Evaluation I...
How to access a remote database with Visual Basic 6? It's been a while since I've done any code in Visual Basic 6, I remember ODBC connections however I'm not sure how I would go about it. All that I need is to have a database on a host computer and then some clients would connect to it, probably without need to guarantee simultaneous ...
I've got a list of clients who have certain tasks done on a weekly basis. Currently we use an excel spreadsheet that keeps track of this but I am in the works of automating it. In the process of moving this into our MS Access system, I have created a form that does this for a single day and can display a report that outputs in the mann...
Hi, I'm looking for a way to open an Access MDB file inside a Java App (using JDBC). A quick Google Search suggests that I need the JDBC-ODBC Bridge for this... Does this mean that I need to configure every system I want to run my app on to provide a ODBC DSN for the MDB I want to open? And one more question (since I've never used OD...
I am having a table with records like this in MS Access: ID field2 field3 field4 field5 1 345 asr 2 ase 567 788 3 456 ghy 4 jki 568 899 5 235 yui 6 hju 456 456 I want to merge it to get a table like this: ID field2 field3 field4 field5 1 345 asrase 567 ...
Is there a way to secure tables in ms access db from unauthorized access? I would like my users to use the forms in the db but i don't want them to see the contents of the tables. I know i can hide a table but anyone who knows just a bit about access can show the hidden tables anyway. I cna also change a name to UsysTableName but again -...
How can I retrieve and display a record from an Access Database. I built a simple module and it works. I would like to access the database. ...
I am trying to deploy GAL Modifier, which is an ASP.NET website which uses Microsoft Access on a Windows 2003 x64 machine. However there is no JET driver on x64 (see here), so the change is to use change the target CPU to x86. However as it is a web site there is no option in Visual Studio except Any CPU, so how can I change the settin...
I remember using a query like this which worked for me before. But now its giving me a compile error. I am trying to get only the first 3 characters of the second field. select field1, left(field2, 3) from table1; What am I doing wrong? ...
Hi, In MS Access I have a query wich takes two parameters and I'd like to get the result of this query in a ADO.NET DataSet with a TableAdapter. In Visual Studio Express 2008 I can't select the query in the assistant. In fact it seems I can't select any queries with parameters. Is there any way to use am Access parameterized query in A...
I want the column and data-type of a table in VBA ms access form how to do it easily? ...
Hi, For a few different reasons one of my projects is hosted on a shared hosting server and developed in asp.Net/C# with access databases (Not a choice so don't laugh at this limitation, it's not from me). Most of my queries are on the last few records of the databases they are querying. My question is in 2 parts: 1- Is the order of ...
Is it basically possible to do transactions with ssis and ms access 97! I have tried setting up a complicated package which doesn't work and then tried some transactions with a simple package which worked no problem with sql server to check I understood the principles. Now the question is does ms access support or does ssis support trans...
I have a MS Access database with over 10 queries which need to be updated weekly. It is a real pain to export each one separately and then upload each one separately to the SQL on my server. I have tried to connect my Access database directly to my SQL server, but my server does not allow that due to security reasons. I have found a mo...
Using VB6 and Access 2003 Query Select Temp.* into NewTable from Temp Table Name storing in Stroutput as a string. Tried Query. Select Temp.* into ‘ ” & Stroutput & “ ’ from Temp From the above query am getting error in ‘ ” & Stroutput & “ ’. When i give temptable instead of ‘ ” & Stroutput & “ ’ is working. How to give a strin...
Hi, this is my first question on SO, am really posting this out of desperation after searching around a lot for an answer and trying a few different things with no success. I have an Access database where I have recently migrated the tables to SQL 2005, Access continues to function to the users as a front-end providing forms, reports, ...